Better places, thriving communities.
Data Engineer
Contract Details
1. Contract Type: Permanent
2. Hours: 40 hours per week
3. Location: Hybrid working with occasional visits to one of our offices in Birmingham, Bristol, London or Manchester
Job Summary
We are looking for a forward-thinking Data Engineer with strong proficiency in both SQL and Python to join our Group Operations Data Transformation Team. The successful candidate will be responsible for supporting and enhancing our Microsoft Fabric platform, developing data pipelines, and crucially, identifying and resolving data quality issues at source.
Unlike a standard developer role, this position has a critical focus on Data Quality and Governance. You will not just be moving data; you will be responsible for ensuring its integrity. You will be tasked with identifying quality issues at the source (e.g. detecting null anomalies) and designing automated, AI-driven processes to rectify them.
Working closely with Analysts, BI Developers, and Information Systems (IS), you will transform raw system data into a "Gold Standard" format to enable regular reporting and insight. You will be expected to understand the business context behind the data, ensuring that what we build drives tangible value for our clients.
Key Responsibilities
Platform & Pipeline Development
4. Design, develop, and maintain robust ETL/ELT pipelines using Microsoft Fabric (primary), Azure Data Factory, and Python.
5. Manage the ingestion of raw data from diverse sources (CAFM, Finance Systems, Salesforce, IoT, HR) into the Data Lakehouse.
6. Work with Cloudera and Azure stack technologies to deliver comprehensive data solutions Collaborate with the architecture team to design the optimal, future-proofed solution and support the transition from the ‘as-is' to the ‘to-be' solution.
Data Quality (DQ) & Governance
7. Proactive DQ Monitoring: Implement automated scripts (SQL/Python) to identify data quality issues at the source
8. AI & Automation: Design, implement, and maintain processes to improve data quality using AI and Automation
9. Governance Framework: Maintain Data Governance standards, ensuring data dictionaries, lineage, and schematics are kept up to date.
10. Conduct root cause analysis on data discrepancies and collaborate with source system owners to rectify issues upstream.
Collaboration & Optimisation
11. Assemble large, complex datasets that meet functional and non-functional business requirements.
12. Review and improve user-generated scripts (SQL/Python) for performance and scalability.
13. Conduct performance analysis and provide recommendations for optimisation.
14. Communicate technical developments and infrastructure changes clearly to non-technical stakeholders and business users.
What We Are Looking For
Technical Skills
15. SQL & Python: Expert-level SQL skills for complex querying and stored procedures, combined with strong Python skills for data manipulation (Pandas, PySpark) and automation.
16. Microsoft Fabric & Azure: Experience with the Azure Data Stack (ADF, Synapse, Data Lake) is essential. Experience with or a strong desire to master Microsoft Fabric is required.
17. Big Data Ecosystems: Knowledge of Cloudera/Hadoop environments is highly beneficial.
18. Data Quality Automation: Demonstrated experience in automating data quality checks and using logic/AI to improve data integrity.
Experience & Qualifications
19. 3+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field and is keen to progress their career in Data Engineering and Data Development
20. Proven track record of delivering ETL/ELT projects (ingestion, modelling, mapping).
21. Experience implementing Data Governance controls and documentation.
Soft Skills
22. Investigative Mindset: You don't just fix the error; you analyse why the error happened.
23. Communication: Excellent written and verbal skills; able to translate "data issues" into "business impacts".
24. Self-Starter: Motivated and organised, with an ability to work to tight deadlines in a hybrid environment.
25. Remote Working: A good, reliable internet connection at home is required.
Our market-leading offering provides you with benefits that suit your lifestyle.
We have a virtual GP on hand for you and members of your household. So you can get expert advice by video or phone without having to leave your home. We offer financial wellbeing assistance through our Salary Finance scheme. For example, you could access 50% of your earned pay before payday for a small fee. Salary Finance also offers competitive loans.
When you join us, we’ll give you a link to our flexible lifestyle benefits platform, Choices. You might choose to purchase up to five extra days’ holiday each year. You might buy critical illness insurance, seek dental treatment or buy technology products at an affordable cost. There are many choices!
We give you access to high street discounts from thousands of well-known retailers, gyms and more through our MiDeals platform. And we have a cycle-to-work scheme. Life cover of up to four times your salary is available. We also offer enhanced pension contributions, a save-as-you-earn scheme, and a Mitie Matching Share Plan (you could even be awarded free shares in Mitie).
We award our employees with Mitie Stars as recognition for their hard work. There are cash prizes up for grabs each month and at the end of the year there’s a chance to scoop a top prize of £10,!
Our success is a direct result of the experience and quality of our people. Progressing your career is therefore a top priority for us. We offer a diverse variety of training and development avenues via a wide selection of learning resources to suit you.
We are committed to ensuring our recruitment process is inclusive and accessible to all. If you have a disability or long-term condition (for example dyslexia, anxiety, autism, a mobility condition or hearing loss) and need us to make any reasonable adjustments, changes or do anything differently during the recruitment process, please let us know by emailing Ashish Gautam at .