Data Engineer III

Role: Data Engineer III

Division: Assessment & Qualifications Delivery 

Location: Rotherham, Manchester or London, UK 

This role aligns with positions typically advertised in the external market as AWS Data Engineer, Data Integration Engineer or ETL Developer.

About Pearson: At Pearson we ‘add life to a lifetime of learning’ so everyone can realise the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. Our Purpose | Add Life to a Lifetime of Learning. Pearson was founded in 1844 and has been built on our ability to grow with and adapt to a constantly evolving market. Our 20,000+ employees are dedicated to creating high-quality, digital-first, accessible and sustainable resources for lifelong learning. 

Job Summary 

Deliver data integration and transformation solutions for TOpS, supporting quality, compliance, and timely delivery for a major UK Government contract. Develop AWS-based data pipelines and SQL logic to enable reliable, scalable data flows across Pearson’s enterprise platforms, with a focus on tightly integrating multiple products using AWS tools. 

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

Required Skills and Competencies 

• Data pipeline development 
• SQL development (complex queries, stored procedures, views, functions) 
• Database performance tuning and optimisation 
• ETL/ELT solution development 
• GitHub/version control 
• Agile delivery experience 
• Pearson Power Skills: Adaptability, Artificial Intelligence, Learning to Learn (Intermediate) 

Qualifications (Education & Experience) 

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

Direct Reports: No direct reports at IC20 tier.

Job Location and Hours 

The role is aligned to our Manchester, Rotherham, or London offices. Our Rotherham office is located at Junction 1 of the M18. All our roles are hybrid working; our current policy requires our team to visit their base office no more than once a week, and with the possibility of occasional business travel to other Pearson sites. Candidates must be a suitable commute from their base office as our office presence policy may change to require more frequent presence in the future. 

We work a 37.5-hour week, with all our team free to flex their day around our core hours, which are Monday to Friday, 10 to 4 GMT/BST. School runs, etc. can be accommodated. Other flexible working patterns can be considered, including part-time working and non-traditional hours. 

Your benefits and rewards 

Here at Pearson we offer a range of benefits, which include: 

• 25 days annual leave (increasing by 1 day with every year of continuous service up to 30 days) 
• Private pension plan scheme where we pay in double what you contribute, up to 16% depending on your age 
• Life, private medical and dental care insurance options, plus free eye tests 
• Stock/share purchase options 
• Maternity, paternity, and family care leave as well as flexible working policies 
• An employee wellbeing assistance programme