Mid Level Data Engineer - KT

Role Overview

The Data Engineer works closely with statisticians, analytical teams, and business stakeholders to design, build, and maintain the data infrastructure needed to support rigorous statistical production processes. The role centres on building reliable and maintainable data pipelines, validation and frameworks that support statistical production processes.

You will contribute to the migration and modernisation of legacy processes, ensuring that existing business logic is preserved and that outputs are accurately reconciled against current production results. You will also contribute to the engineering practices required to operate the platform reliably in production.

Key Responsibilities

• Design, develop and maintain efficient and reliable ETL processes and data pipelines for the ingestion, transformation, and integration of data from multiple source agencies.

• Develop and maintain modular, production-quality code for statistical production processes, including optimising legacy processes while preserving business logic and reconciling outputs against existing results.

• Design and maintain database schemas, data models and storage structures to support efficient ingestion, validation, transformation and retrieval of large datasets.

• Build reusable data engineering components such as common libraries, configuration frameworks, logging standards, and utilities to streamline production workflows.

• Implement and maintain CI/CD pipelines for data engineering workflows, including automated testing and deployment, and establish workflows to safely isolate and synchronise Development, UAT, and Production environments.

• Design and configure complex pipeline workflows and schedules using enterprise tools, including dependencies, failure handling, recovery and operational monitoring.

• Establish version control structures using GitLab, set up code review frameworks, and produce technical documentation.

• Monitor and troubleshoot pipelines, perform root-case analysis and continuously improve operational reliability and system performance for large-scale datasets.

• Collaborate with technical team, business users and other stakeholders to translate business and statistical processing requirements into robust technical implementations.

Required Skills & Experience

• 4-7 years of professional experience in data engineering, data platform development, or a related software engineering role.

• Strong proficiency in Python and SQL, including experience in complex data transformations, analysis, and quality monitoring.

• Hands-on experience with dataframe processing libraries (e.g. Polars, pandas) for high-performance execution and memory-efficient processing of large datasets