Senior AWS Data Engineer – ETL & SQL Pipelines

Pearson; Hellaby; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

25 days annual leave

Private pension plan (double match)

Life, private medical and dental care

Stock/share purchase options

Maternity, paternity, and family care

Employee wellbeing programme

Job summary

Pearson seeks a Data Engineer III to deliver data integration and transformation solutions for a major UK Government contract. You will develop AWS-based data pipelines and SQL logic to enable reliable, scalable data flows across Pearson’s platforms, focusing on integrating multiple products using AWS tools.

Hybrid role across Manchester, Rotherham or London offices; collaborators include Data Modellers, Architects and Engineers to resolve pipeline issues and implement data models.

Qualifications

• Strong hands-on experience with data integrations services and SQL database development.
• Experience with large-scale SQL data transformation solutions.
• Familiarity with relational databases (Aurora, MySQL, PostgreSQL, etc.).
• Experience in Agile teams and enterprise data integration environments.
• Experience with CDC processes such as DMS (desirable).
• Azure or AWS certification (desirable).

Responsibilities

• Design, develop, and maintain reusable data pipelines following engineering standards.
• Build SQL-based transformation logic and database objects within relational databases (e.g., MySQL, PostgreSQL).
• Analyse SQL execution plans, optimise queries, and implement indexing strategies for performance.
• Develop automation scripts for database deployment and operational activities.
• Support schema changes via GitHub and CI/CD pipelines.
• Collaborate with Data Modellers, Architects, and Engineers to implement data models and resolve pipeline issues.

Skills

Data pipeline development

SQL development

DB performance tuning

ETL/ELT development

GitHub/version control

Agile delivery

Pearson Power Skills: Adaptability, AI

Tools

GitHub

CI/CD

Aurora

MySQL

PostgreSQL

Job description

Pearson seeks a Data Engineer III to deliver data integration and transformation solutions for a major UK Government contract. You will develop AWS-based data pipelines and SQL logic to enable reliable, scalable data flows across Pearson’s platforms, focusing on integrating multiple products using AWS tools.

Hybrid role across Manchester, Rotherham or London offices; collaborators include Data Modellers, Architects and Engineers to resolve pipeline issues and implement data models.