Data Engineer

JOB TITLE : Data Engineer

JOB TYPE : Full time

DIVISON : Assessment & Qualifications Delivery

LOCATION : Rotherham, Manchester, or London

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 18,000+ employees are dedicated to creating the high-quality, digital-first, accessible and sustainable resources for lifelong learning.

About Pearson Assessment Services : The Pearson Assessment Services (PAS) team provides assessment services to the UK and international assessment markets, supporting government education departments with project management, operational delivery and technical solutions. We are part of Pearson School Qualifications which supports the curriculum, qualifications and assessments for students in the UK and globally, delivering exams to over million students in over 80 countries annually and operating as a centre of excellence in qualifications and assessment.

About the Job :

The position is for a Data Engineer, who has experience working with large data focused projects, and whose responsibility is around the transformation, ingestion and validation of data from multiple external and internal sources, along with working towards better methods of exploiting this data in terms of analytics and reporting.

Currently we are initiating a large new programme which will hold large amounts of data hosted in AWS and in platforms such as MySQL. This role involves working with business SME’s, product owners, architects, and developers, hence excellent communication and analysis skills are required. There will also be attendance to various senior stakeholder meetings to explain project progress, design ideas and decisions etc, so good communication & planning skills are essential, with the ability to put things into non-technical terms for the wider audience.

About You

This would suit someone with a background in complex data transformation projects or project new project initiations, and who is looking to work on fast moving critical projects and contribute to design decisions. A proven track record in delivering projects and advanced data validation experience is an advantage.

Key Skills & Experience

Proficiency in one or more database systems such as Amazon Aurora MySQL, Microsoft SQL Oracle, DynamoDB, etc.

Expert level hands-on experience in designing, developing, and maintaining complex SQL queries, stored procedures to support various business applications.

Perform advanced performance tuning and optimization of data pipelines.

Implement and maintain data monitoring solutions to proactively identify and address potential issues.

Develop scripts and automation tools to streamline data management tasks.

Familiarity with version control systems for database schema changes (, Git).

Knowledge of AWS DMS, Lambda, S3, Step Functions, CloudWatch, Redshift, Glue, Event Bridge.

Change Data Capture understanding.

CI / CD – Pipeline setup and repository (Bitbucket) knowledge.

Automated testing design and setup.

Experience with large-scale data environments.

Data Warehousing concepts, design and loading strategies.

Experience with Integration / Ingestions of data.

Excellent organisational skills, proactive, self-starter with a curious approach to data and its value.

AWS SNS\SQS pub / sub / queue concepts.

JIRA – Kanban Boards, agile methodology.

Working with product management, product owners, data architects, business stakeholders.

Excellent Communication & Planning.

Desirable Skills & Experience

JIRA & Confluence

Teams and other Microsoft office apps

Trello

Your benefits and rewards :

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

Cycle to work program, volunteering days, gym membership concessions in selected office locations, along with retail and leisure discounts

Location : 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 2024.

Diversity : At Pearson we value the power of an inclusive culture and a strong sense of belonging. We promote a culture wheredifferences are embraced as strengths and opportunities are equal and accessible.

How to apply : Thank you for your interest in applying for a role at Pearson. Please submit an updated CV and cover letter (optional) in English. If you have any additional questions or require further information, please do not hesitate to reach out to us.

We look forward to receiving your application - Talent Acquisition Team

What to expect from Pearson

Did you know Pearson is one of the 10 most innovative education companies of 2022?

At Pearson, we add life to a lifetime of learning so everyone can realize the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. We are on a journey to be 100 percent digital to meet the changing needs of the global population by developing a new strategy with ambitious targets. To deliver on our strategic vision, we have five business divisions that are the foundation for the long-term growth of the company : Assessment & Qualifications, Virtual Learning, English Language Learning, Workforce Skills and Higher Education. Alongside these, we have our corporate divisions : Digital & Technology, Finance, Global Corporate Marketing & Communications, Human Resources, Legal, Strategy and Direct to Consumer. Learn more at

We value the power of an inclusive culture and also a strong sense of belonging. We promote a culture where differences are embraced, opportunities are accessible, consideration and respect are the norm and all individuals are supported in reaching their full potential. Through our talent, we believe that diversity, equity and inclusion make us a more innovative and vibrant place to work. People are at the center, and we are committed to building a workplace where talent can learn, grow and thrive.