Data Engineer

at  Pearson

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.

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

Please refer the Job description for details