Data Engineer

Data Engineer

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).

Location

Bracknell, UK

Rate/Salary

350.00 – 375.00 GBP Daily

Company

TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom.