Description 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 3.4 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 (e.g., 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 where differences 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