Azure Data Engineering Specialist

Two driven and experienced Azure Data Engineering Specialists with proven experience as data engineers are needed to join our team at Central Bedfordshire Council based in Bedfordshire on a full-time, hybrid working, 24-month contract basis.  

As part of our talented team, you'll collaborate with like-minded colleagues who share your passion for technology and its ability to help improve the lives of our residents and to better support our staff. 

Working from home and any CBC offices, including Priory House, Shefford. You will be expected to attend a CBC 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 Us

Central Bedfordshire Council is a large unitary authority serving nearly 300,000 residents. Our ambition is to be a great place to live and work. One way we are achieving this is through our use of technology.  

In recent years we have made significant improvements to many of our systems, and the value this has had to the organisation has been recognised with continuing demand to further this innovation. We have an ambitious programme of work over the next couple of years to deliver further IT enhancements. 

About the Role

We are looking for talented, forward-thinking team members who can help us deliver our exciting programme of projects, which includes enhancements to our case management systems and improvements that will make it easier for residents to access the services they need. 

We 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 CBC 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 CBC 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 our 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 our 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.