Data Engineer 3

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