Fancy working for a company that is committed to creating a fun workplace, where people have a voice, are safe and reach their full potential?
Who are they?
Leading civil engineering and construction company, delivering design-and-build projects with clients in the water sector and beyond, across the UK.
1,300 people across 9 office locations and hundreds of construction sites nationwide.
Turnover in excess of £300 million.
They believe people are their most valuable asset, so they’re dedicated to investing in them by having comprehensive training and development schemes.
Who do they work with?
A lot of water companies, canals, river trusts and ports.
They also work with well known companies like Rolls Royce.
You'll have the opportunity to contribute to projects that will protect local communities from flooding.
What will you be doing?
Responsible for developing new systems, integration with 3rd party systems and maintaining existing applications.
Other duties include:
- Analyse business requirements through collaboration with stakeholders, IT Management and the user community.
- Engage with stakeholders on data extraction and manipulation tasks
- Help write and optimise in-application SQL statements
- Ensure performance, security and stability of databases
- Provide support to users with regard to report errors, debugging and fixing the issues
- Integrate new datasets into the data warehouse
- Create and maintain SQL data feeds in/out of internal, partner and supplier systems
- Migrate reports from Excel/VBA into SSRS
- Develop SSIS packaged solutions
- Provide support towards the design and architecture of a new data warehouse
The team
The data team is 12 in size.
4 in the Data Engineering team.
7 in the Power Platform team.
Office location / Remote working
They’re based right in the centre of Leeds (they’ll let you claim your parking back).
You can work from home 50% of the time.
Working hours
37.5 hours - 8:30 - 17:00 with an hour for lunch
Tech stack
Microsoft stack - SSRS, SQL, Power Platform, some .NET
Benefits include:
- 26 days holiday plus bank holidays with the option to buy and carry over
- Flexible pension contributions up to 5% employee 10% employer
- Life assurance of 4 x salary
- Income protection
- Private medical insurance
- Health cash plan
- Car benefit
- Annual professional institution subscription costs
- Career and professional development opportunities
- Bonus twice a year (just paid out 4%, could be up to 8% this Christmas)
- Annual pay review
Required experience
You will have the following essential requirements/experience:
- Minimum of 2 years working in a database developer/ data engineer role
- Strong MS SQL experience creating stored procedures, queries, scripting, indexes
- Skilled at writing and optimising large, complicated SQL statements
- Experience of debugging and performance tuning existing SQL procedures
- Strong relational database / data warehouse design principles
- Proficient understanding of using code versioning tools (Git / SVN)
Experience of:
- Undertaking development work in C#
- Creating and troubleshooting SSRS reports
- Line management / mentoring
- Debugging VBA macros (linked to stored procedures for running reports)
- Exposure to data warehouse development and maintenance
Interview process
2 stage interview process.
1st - online (40 mins - 1 hour)
2nd - in-person (40 mins - 1 hour)
No technical tests.
How to apply
For more details please click 'apply'.
Recent CV not necessary; we can sort that out at a later date.
Alternatively, get in touch with Tom Smith - 01642 271428 / tom@hainton.com