Senior Data Engineer

Position: Senior Data Engineer

Hybrid - Birmingham

6 months - Outside IR35

Overview:

Join a leading UK company as a Senior Data Engineer and play a key role in a major data transformation project. You will have the opportunity to design and deliver a new Azure-based data platform, modernising the organisation's data management and reporting processes. This hands-on role offers architectural influence and is ideal for an experienced engineer with a strong background in setting up new environments, creating data pipelines, and enabling self-service analytics through Power BI.

Key Responsibilities:

Design, build, and maintain Azure data pipelines using Azure Data Factory, Synapse, or Fabric.
Implement a data lakehouse architecture (Bronze/Silver/Gold) and establish best-practise ETL/ELT frameworks.
Ingest and integrate data from multiple core systems, including ERP, finance, supply chain, and CRM platforms.
Develop and optimise SQL data models and support the creation of Power BI-ready datasets.
Apply and document data governance, quality, and validation rules within the platform.
Collaborate with Finance and IT stakeholders to translate reporting needs into technical solutions.
Monitor, troubleshoot, and optimise data pipelines for performance and cost efficiency.
Define reusable components, standards, and documentation to support long-term scalability.
Essential Skills & Experience:

Proven experience building Azure data platforms end-to-end (Data Factory, Synapse, Fabric, or Databricks).
Strong SQL development and data modelling capability.
Experience integrating ERP or legacy systems into cloud data platforms.
Proficiency in Python or PySpark for transformation and automation.
Understanding of data governance, access control, and security within Azure.
Hands-on experience preparing data for Power BI or other analytics tools.
Excellent communication skills - able to bridge technical and non-technical stakeholders.
Strong documentation habits and attention to detail.
Desirable Skills & Experience:

Experience with AS400, Tagetik, or similar finance systems.
Familiarity with Power BI Premium, RLS, and workspace governance.
Knowledge of Azure DevOps and CI/CD for data pipelines.
Exposure to data quality tools or frameworks