Job Title: Data Engineer

Job Description

We are seeking a proactive Data Engineer with deep expertise in data management to own and stabilise a data ecosystem. This role is critical to transforming fragmented, unreliable data from multiple source systems into trusted, governed, analytics-ready datasets using medallion architecture principles (Bronze/Silver/Gold). This position requires a hands-on problem solver who takes initiative, investigates data issues at the source, collaborates with upstream system owners, and designs resilient data pipelines with strong data quality controls.

Responsibilities

• Design, build, and maintain scalable data pipelines leveraging OneLake and medallion architecture (Bronze, Silver, Gold layers).
• Architect robust ingestion, transformation, and serving layers that support analytics, reporting, and downstream use cases.
• Develop and optimise complex SQL/M-Query/Power Query-based transformations for performance, reliability, and maintainability.
• Design and develop scalable semantic models that enable governed, self-service analytics and democratise access to trusted data across the organisation.
• Own end-to-end pipeline reliability, from source system ingestion through curated datasets.
• Design and implement data quality checks, validations, and reconciliation controls across all pipeline layers.
• Proactively detect, troubleshoot, and resolve pipeline failures, especially those caused by upstream schema or data changes.
• Build monitoring, alerting, and logging mechanisms to ensure data issues are identified early and resolved quickly.
• Continuously improve pipeline resilience and reduce manual intervention.
• Actively engage with source system owners, application teams, and business stakeholders to understand data issues and resolve root causes.
• Take ownership of ambiguous or poorly defined data problems and drive them to resolution independently.
• Implement and manage Row-Level Security (RLS) to ensure proper data access controls.
• Apply data governance best practices including dataset certification, lineage, documentation, and access standards.
• Ensure compliance with internal data security, privacy, and governance policies.

Essential Skills

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related technical field (or equivalent experience).
• 4+ years of hands-on experience as a Data Engineer, with at least 1-2 years working in data ecosystems.
• Strong troubleshooting and root-cause analysis skills in complex, messy data environments.
• Ability to work independently, take initiative, and drive issues to resolution without waiting for direction.
• Hands-on experience with Fabric & OneLake in real projects.
• Expertise in medallion architecture (Bronze/Silver/Gold).
• Advanced skills in SQL/M-Query/Power Query for data transformation and optimisation.
• experience in building and maintaining production-grade data pipelines (ingest ? transform ? serve).
• Proficiency in handling broken or changing source data and implementing data quality checks.
• Knowledge of data security and access controls, specifically Row-Level Security (RLS).

Bracknell, UK

350.00 - 375.00 GBP Daily

Trading as TEKsystems. Allegis Group Limited, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at our website.

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go our website.

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice on our website for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.