Data Engineer
Ascot Lloyd
Birmingham, United Kingdom
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Birmingham, United Kingdom
Tech stack
Agile Methodologies
Azure
Business Intelligence
Information Engineering
Data Integration
ETL
Performance Tuning
Power BI
Azure
SQL Databases
Data Storage Technologies
Azure
GIT
Powerquery
Microsoft Fabric
Azure
Software Version Control
Data Pipelines
Job description
The Data Engineer will play a key role in developing and maintaining Power BI reports and dashboards to support the business's operational MI, while contributing to broader data initiatives within Azure Data Factory, Synapse Analytics, and the ongoing migration to Microsoft Fabric. This is a hands-on delivery role suited to a mid-level engineer with strong technical ability and a desire to grow within a modern cloud data environment., * Build and maintain Power BI reports and dashboards that deliver accurate and timely insights for operational and business stakeholders.
- Develop, test, and maintain ETL pipelines in Azure Data Factory (ADF) to ensure reliable data integration and transformation.
- Work with Azure Synapse Analytics to model, query, and optimise data for analysis and reporting.
- Support the team in the transition to Microsoft Fabric, assisting with data model migration and integration activities.
- Write and optimise SQL queries to support data preparation and reporting needs.
- Collaborate with analysts, engineers, and business teams to understand requirements and deliver fit-for-purpose solutions.
- Contribute to data quality checks, documentation, and continuous improvement across the data platform.
- Participate in Agile delivery using Azure DevOps for task management and version control.
Requirements
- Power BI: Strong experience in developing and publishing reports, dashboards, and data models using DAX and Power Query.
- Azure Data Factory: Hands-on experience building and maintaining ETL pipelines.
- Azure Synapse Analytics: Working knowledge of data modelling, views, and performance tuning.
- SQL: Proficient in writing, optimising, and troubleshooting queries.
- Azure Data Lake: Understanding of data storage and structure for analytics use cases.
- Git / Azure DevOps: Familiar with version control and Agile delivery workflows.
- Microsoft Fabric (Desirable): Awareness or early exposure to Fabric data pipelines, dataflows, and workspace management.
Soft Skills
- Strong analytical mindset with attention to detail and accuracy.
- Effective communicator who can translate technical outputs into business value.
- Collaborative and eager to learn from senior engineers and peers.
- Proactive in identifying improvements to processes and data quality.
Experience
- 2-4 years of experience in a Data Engineering or BI Development role.
- Demonstrable experience with Power BI, Azure Data Factory, and SQL.
- Exposure to Azure Synapse Analytics and an interest in Microsoft Fabric preferred., 1. You must act with integrity
- You must act with due care, skill and diligence
- You must be open and co-operative with the FCA, PRA and other regulators
- You must pay due regard to the interests of customers and treat them fairly
- You must observe proper standards of market conduct
- You must act to deliver good outcomes for clients