Job Description

Job Title: Senior Data Engineer - SC
Location: Hybrid (2 days/week on site) – Choice of locations nationwide
Contract Duration: 23/4/2026
Daily Rate: £700/day (Umbrella – Maximum)
IR35 Status: Inside IR35
Security Clearance: SC

 
The Role:

• You will form part of a multi-disciplinary team responsible for the delivery of a range of outcomes in support of the wider Technology Services teams. You will play a key role within the team whose deliverables include: -
• Development of data products such as data warehousing, data models, reporting, and business applications at scale to support improved business outcomes.
• Provision of specialist skills in Microsoft BI Stack (Azure SQL, Fabric, Synapse Analytics, Power BI).
• Understanding in Power Platform to deliver new business intelligence solutions and maintain existing solutions.
• Analysis of data focusing on descriptive, diagnostic, and predictive analytics.
• Provision of insights to inform decision-makers and other stakeholders.
• Provision of a managed service to support projects and BAU activities.
• Governance of data quality across systems to ensure high standards are achieved and maintained, providing high levels of assurance.

• ETL/ELT development using tools such as Azure Data Factory.
• Extensive experience with SQL Server and Data Warehousing.
• Strong understanding and experience working with Microsoft Fabric.
• Experience working with large and complex datasets.
• Data Modelling and Design expertise.
• Basic DBA skills.
• Report development in Power BI.
• Experience with data lake and cloud data warehousing.
• ServiceNow experience is an advantage.
• Code version control via GitHub or similar would be an advantage.
• CI/CD experience would be an advantage.
• Microsoft certification in Fabric or Power BI is an advantage.

Key Responsibilities:

As a Senior Data Engineer, you will:

• Implement data flows to connect operational systems, analytics platforms, and business intelligence (BI) systems.
• Document source-to-target mappings and define data architecture.
• Re-engineer manual data flows to enable scalability and reusability.
• Support the build of data streaming and batch processing systems.
• Write ETL (extract, transform, load) scripts and code to ensure optimal ETL performance.
• Develop reusable business intelligence reports and dashboards.
• Build accessible and governed data solutions for analysis.
• Recognise opportunities to reuse existing data flows and optimise processes.
• Lead the implementation of data streaming solutions and best practices.
• Optimise code and ensure high-performance data processing.
• Lead work on database management, ensuring security, scalability, and reliability.

Essential criteria:

• Communicating between the technical and non-technical: Effectively communicate with stakeholders across various technical and business functions. Support and facilitate discussions within multidisciplinary teams while managing differing perspectives.
• Data analysis and synthesis: Conduct data profiling and source system analysis. Present clear insights to support data-driven decision-making.
• Data development process: Design, build, and test complex and large-scale data products. Lead teams to complete data integration services.
• Data innovation: Stay updated on emerging trends in data tools, analysis techniques, and data usage to drive innovation.
• Data integration design: Select and implement the appropriate technologies to deliver resilient, scalable, and future-proofed data solutions.
• Data modelling: Produce relevant data models across multiple subject areas. Understand and apply industry-recognised data modelling patterns and standards.
• Metadata management: Design and maintain metadata repositories, ensuring effective storage and management of metadata assets.
• Problem resolution (data): Diagnose and resolve data-related issues in databases, data processes, and services. Implement preventative measures to enhance data reliability.
• Programming and build (data engineering): Use best practices to design, code, test, and document programs and scripts. Collaborate with teams to refine requirements and specifications.
• Technical understanding: Apply core technical concepts to design and optimise data solutions.
• Testing: Define test conditions, identify issues and risks, and analyse test results to improve data quality.

Disability Confident

As a member of the disability confident scheme, CLIENT guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group.

Armed Forces Covenant   

CLIENT is proud to support the Armed Forces Covenant and as such, we guarantee to interview all veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group.

If you qualify for the above, please notify us on 0121 794 8181.

We will be in touch to discuss your suitability and arrange your Guaranteed Interview.

Should you require reasonable adjustments at any point during the recruitment process or if there is a more accessible way for us to communicate, please do let me know.

To apply for this role please submit your latest CV or contact Aspect Resources on 0121 794 8181