Data Engineer

Cpl; Greater London; On-site; GBP 44,000 - 74,000; Full time

Job summary

CPL in London is seeking an experienced Data Engineer to join a fast-paced technology environment. You will design, build and optimise ETL/ELT pipelines, develop robust data models and curate data assets to support complex enterprise data flows.

The role requires strong SQL skills, data engineering expertise and the ability to translate business requirements into auditable datasets. This is a fully onsite contract role with competitive daily pay.

Qualifications

• Strong SQL and data engineering expertise.
• Experience building reliable data pipelines and curated datasets.
• Ability to investigate complex data issues and identify root causes.

Responsibilities

• Design, build and optimise ETL/ELT data pipelines across multiple data sources.
• Write and optimise complex SQL queries including joins and window functions.
• Translate business requirements into auditable datasets.
• Perform data mining, reconciliation and root-cause analysis across data sources.
• Map end-to-end data lineage and system flows from source to serving.
• Build and maintain curated data layers, data marts and warehouse structures.
• Design and implement data quality controls, monitoring and remediation processes.
• Investigate pipeline failures and data anomalies and resolve issues at source.
• Develop scalable processes for data quality issue prioritisation and resolution
• Work with product, analytics, platform and source-system teams.
• Produce technical documentation including lineage maps and DQ rules.
• Lead workshops on systems, data flows and root-cause analysis.
• Hands-on SQL with advanced querying and performance optimisation.
• Experience in commercial Data Engineering within complex enterprise environments.
• Strong data platform security, access controls and auditability.

Skills

SQL

ETL/ELT

Data pipelines

Data quality

Data governance

Data modelling

Data warehousing

Data observability

Job description

Rate: Up to £400 per day

Contract: Contract

Working Pattern: Fully onsite

We are looking for an experienced Data Engineer to join a fast-paced technology environment in London. This role will focus on building reliable data pipelines and curated datasets, improving data quality, and understanding complex data flows across multiple systems.

The successful candidate will combine strong hands-on SQL and data engineering expertise with the ability to investigate complex data issues, identify root causes and work across technical teams to implement sustainable solutions.

Key Responsibilities

• Design, build and optimise ETL/ELT data pipelines across multiple data sources
• Write and optimise complex SQL queries, including joins, window functions and performance tuning
• Translate business requirements into reliable, auditable datasets
• Perform data mining, reconciliation and root-cause analysis across complex data sources
• Map end-to-end data lineage and system flows, from source and ingestion through transformation and serving
• Build and maintain curated data layers, data marts and warehouse structures
• Design and implement data quality controls, monitoring, alerting and remediation processes
• Investigate pipeline failures, data anomalies and quality issues and resolve problems at source
• Develop scalable processes for the identification, prioritisation and resolution of data quality issues
• Work closely with product, analytics, platform and source-system teams
• Produce clear technical documentation including lineage maps, data definitions, DQ rules and operational runbooks
• Lead technical workshops around systems, data flows and root-cause analysis
• Strong hands-on SQL skills, including advanced querying and performance optimisation
• Commercial Data Engineering experience within complex enterprise environments
• Strong experience designing and developing ETL/ELT pipelines
• Data warehouse and/or domain data platform experience
• Strong understanding of dimensional and/or domain-oriented data modelling
• Hands-on data quality engineering, profiling and remediation experience
• Experience investigating data issues across multiple systems and identifying root causes
• Understanding of incremental loads, CDC, backfills, late-arriving data and rerun-safe pipelines
• Experience with data observability, monitoring and troubleshooting
• Strong system and data-flow discovery skills
• Excellent stakeholder management and communication skills
• Data governance, ownership and stewardship frameworks
• Compute infrastructure supporting modern data platforms
• Scheduling and orchestration concepts
• Data platform security, access controls and auditability
• Incident, change and problem management / ITIL environments
• Experience working within large, matrixed enterprise organisations