Data Engineer

Mackenzie Jones IT; England; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

A leading manufacturing organization is seeking a Data Engineer to join its team in Cambridgeshire. The ideal candidate will work on data movement, ETL processes, and support the migration of data services to AWS. The role requires strong skills in Azure Data Factory, SSRS, and data warehousing methodologies. A comprehensive benefits package is offered, alongside a hybrid working model.

Benefits

31 Days Annual Leave

Contributory Pension

Income Protection

Life Assurance

Store Discount

Well Being Programme

Cycle to Work Scheme

Electric Car Salary Sacrifice Scheme

Qualifications

• Experience with Azure Data Factory is essential.
• Hands-on experience with SSRS is required.
• Understanding of Data Warehousing Methodologies is a plus.

Responsibilities

• Design, implement & manage ETL processes.
• Monitor daily Data Loads & ETL workflows.
• Support the migration of Data Services to AWS.

Skills

Azure Data Factory

AWS Data Services (Redshift, S3, Lambda)

SSRS - hands-on experience

ETL - Design, Data Quality Frameworks & Pipeline Management

SQL - Star Schema - Data Modelling

Data Warehouse Design, Development & Testing

Data Warehousing Methodologies

User Support - Power BI

Excellent communication skills

Collaborative approach to teamwork

Job description

Data Engineer. Permanent. T6/MN/(phone number removed). Hybrid - 2 Days Onsite Weekly - Cambridgeshire. Must be Eligible to work in the UK.

International Manufacturing organisation is seeking to secure a Data Engineer. Member of a small Data Engineering Team which is part of a much larger IT function.

Role:

• Data Movement & Transformation processes between Application/Services/Solutions.
• Azure Data Factory Pipelines & SSRS reporting solutions - maintenance & optimization
• ETL - Design, implement & manage ETL processes - ensure accuracy, quality & consistency.
• Monitor daily Data Loads & ETL workflows.
• AWS - Support the migration of Data Services to AWS - scalable & cloud-first solutions.
• Deliver UK Data Roadmap - aligned to Data Infrastructure & Business Strategy.
• Gather & Define Requirements - identify new opportunities for the business/internal teams.
• Troubleshoot & resolve pipeline failures, reporting errors & performance bottlenecks.
• Validate & Reconcile Data - ensuring accuracy.
• SSRS, Power BI & other BI tools - User Support.
• Provide Governance, Security & Compliance - aligned to Data best practices.
• Liaison with IT Business Systems & Business Teams & Third Parties.
• Drive Continuous Improvement.

Technical Skills Required:

• Azure Data Factory.
• AWS Data Services (Redshift, S3, Lambda) - Desirable.
• SSRS - hands-on experience.
• ETL - Design, Data Quality Frameworks & Pipeline Management.
• SQL - Star Schema - Data Modelling.
• Data Warehouse Design, Development & Testing.
• Data Warehousing Methodologies.
• User Support - Power BI - desirable experience.
• Undertake & Support IT Governance processes (License review etc).
• Customer Focused & Proactive approach.
• Excellent communication skills - explain technical concepts to non-technical audiences
• Collaborative approach to teamwork.

Contractual Hours: Monday to Friday - 40 Hours Per Week.

Benefits Package: 31 Days Annual Leave - Including Bank Holidays / Contributory Pension / Income Protection / Life Assurance / Store Discount / Well Being Programme / Cycle to Work Scheme / Electric Car Salary Sacrifice Scheme. Cambridge, Permanent, T6/MN/(phone number removed).