Azure Data Engineering Specialist

Two driven and experienced Azure Data Engineering Specialists with proven experience as data engineers are needed to join the team at this ambitious local authority based in Bedfordshire on a full-time, hybrid working, 24-month contract basis.
As part of their talented team, you'll collaborate with like-minded colleagues who share your passion for technology and its ability to help improve the lives of their residents and to better support their staff.
Working from home and any council offices, including Priory House, Shefford. You will be expected to attend a council location as required to perform your role but at a minimum monthly.
This is an excellent opportunity to progress your career with a well-established company!
About the Company
The council is a large unitary authority serving nearly 300,000 residents. Their ambition is to be a great place to live and work. One way they are achieving this is through their use of technology.
In recent years they have made significant improvements to many of their systems, and the value this has had to the organisation has been recognised with continuing demand to further this innovation. They have an ambitious programme of work over the next couple of years to deliver further IT enhancements.
About the Role
They are looking for talented, forward-thinking team members who can help them deliver their exciting programme of projects, which includes enhancements to their case management systems and improvements that will make it easier for residents to access the services they need.
They are seeking two driven, knowledgeable, experienced Azure Data Engineers to support a variety of data-related projects over the next two years. You will have an opportunity to work with cutting-edge Azure ecosystem tools, including Databricks and Synapse Analytics.
Key Responsibilities:
Lead migrations from on-premises SQL Server to Microsoft Azure SQL and/or 3rd Party hosted platforms
Execute Data Migration ETL Projects to migrate data to new target replacement systems
Contribute to the Azure Data Platform/ Lakehouse projects by designing and implementing data warehouses and dimensional models
Develop ETL data pipelines using Azure Data ETL tools such as Data Factory and Databricks.
An understanding of legacy SSIS packages will be beneficial
Write Python/ PySpark scripts and T-SQL for Lakehouse/ Database management (tables, views, indexes, stored procedures)
Use Azure Data Factory, Databricks, and Synapse for advanced data engineering tasks
Work with related Azure resources, including Key Vault, Storage Accounts and understanding of Azure DevOps
Support reporting and analytics using tools like PowerBI or equivalent
Required Experience:
You will have proven experience as a Data Engineer/Specialist in data warehouse and migration projects
Have the ability to hit the ground running with minimal supervision and proficiency in Azure Synapse Serverless SQL and associated technologies
It is essential that you have experience in Python/ PySpark and T-SQL scripting, Azure Data Factory, Databricks, and Synapse Analytics, designing and implementing Data warehouses and associated dimensional models, and proficiency in reporting and analytics tools, such as PowerBI
A strong background in developing ETL data pipelines with Azure Data ETL tools is also required
Benefits:
Annual leave allowance of 25 days+ statutory holidays rising to 32 days with length of service
Generous family-friendly policies and practices
Local Government Pension Scheme (LGPS) - This is a valuable part of their rewards package for employees and includes life insurance
A huge variety of courses and role-specific training and learning to help you succeed and develop
The opportunity to lease electric vehicles at competitive rates with their staff electric vehicle (EV) leasing scheme (permanent staff only)
An exceptional Employee Assistance Programme which helps support employees and their households with workplace changes as well as other work, family and personal issues
A comprehensive IT package to support you to work safely and effectively
Annually paid social work fees for qualified social workers in adults and children's (including senior practitioners) and Team Managers where required
Access to discounts on top UK retailers and local retailers
Sounds interesting? Click the

APPLY

button to send your CV for immediate consideration.
Candidates with previous experience or job titles including; Azure Data Engineer, Cloud Data Engineering Specialist, Azure Data Platform Engineer, Cloud Data Architect, Azure Data Solutions Engineer, Azure Data Integration Engineer, Cloud Data Pipeline Engineer, Azure Data Warehouse Engineer, Cloud Data Infrastructure Specialist, Azure Data Analytics Engineer will also be considered.
IND123