Senior Data Engineer, SEO, Perm, Liverpool/ Newport

Job overview

Key responsibilities

• Design, build, test, and maintain scalable data pipelines and processing solutions.
• Implement secure, efficient, maintainable ingestion and integration patterns across Azure services.
• Develop models for analytics and operational use with analysts and architects.
• Improve engineering standards, coding conventions, and design patterns.
• Mentor engineers, review code and pipelines, and promote best practice.
• Investigate data issues, establish root causes, and implement preventative measures.
• Monitor and optimise pipelines and storage for reliability, performance, and cost effectiveness.
• Develop data flows and transformations, including SQL logic, stored procedures, and views.
• Contribute to Azure data platform evolution, including Synapse and layered architecture approaches.

Essential criteria

• Diagnose and resolve complex data problems and deliver robust solutions.
• Collaborate effectively with engineers, analysts, architects, and service teams.
• Communicate data engineering concepts to technical and non-technical stakeholders.
• Maintain data quality, accuracy, and reliability.
• Provide technical leadership through design guidance, code and pipeline reviews, and engineering standards.
• Design and build pipelines using modern cloud platforms such as Azure Synapse, Data Factory, or Databricks.
• Develop performant SQL transformations and ELT patterns; work with relational and/or big data technologies.
• Use CI/CD, version control, and automated testing in data engineering workflows.
• Support data platforms across multiple environments, including production.
• Strong SQL and Azure data tools knowledge, including examples such as ADF, Synapse, Delta Lake, and Data Lake Gen2.
• Familiarity with infrastructure as code, DevOps practices, and monitoring.
• Python, PySpark, or similar programming languages are desirable.

Technical scope

• The role includes data integration, modelling, data standards, technical leadership, problem resolution, and performance and reliability engineering.

Salary and pension

• Advertised salary is £44,027; no salary payment cadence is specified.
• The employer contributes £12,754 towards membership of the Civil Service Defined Benefit Pension scheme.

Working pattern

• The advertised working pattern includes full-time, part-time, flexible working, or compressed hours.

Location

• The listed work locations are Bootle, North West England, and Newport, Wales.

Benefits

• The advert describes Civil Service Defined Benefit Pension scheme membership.