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