Data Engineer

Pearson; Manchester; On-site; GBP 40,000 - 65,000; Full time

Job summary

A leading company in the education sector is seeking a Data Engineer to lead data transformation projects. The role focuses on utilizing various database systems and AWS technologies while collaborating with cross-functional teams. Competitive salary, flexible working arrangements, and benefits that enhance work-life balance are offered.

Benefits

25 days annual leave, increasing with service

Private pension with employer contributions

Life, private medical, and dental insurance

Stock/share purchase options

Flexible leave policies

Wellbeing programs

Gym discounts

Volunteering days

Qualifications

• Experience with complex data transformation projects is essential.
• Proficiency in SQL and database management.
• Strong verbal communication and analytical skills.

Responsibilities

• Manage data transformation and ingestion from various sources.
• Collaborate with stakeholders to ensure effective project delivery.
• Utilize AWS and SQL for efficient data management.

Skills

Data transformation

Database systems

SQL queries

Data pipelines

Data monitoring

Automation tools

AWS services

CI/CD pipelines

Agile methodologies

Job description

Social network you want to login/join with:

DIVISION: Assessment & Qualifications Delivery

LOCATION: Rotherham, Manchester, or London

About Pearson: 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. 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 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 curriculum, qualifications, and assessments for students in the UK and globally, delivering exams to over a 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 with experience working on large data-focused projects. Responsibilities include data transformation, ingestion, validation from multiple sources, and improving methods for data analytics and reporting.

We are initiating a large new programme hosting data in AWS and platforms like MySQL. The role involves collaborating with SMEs, product owners, architects, and developers, requiring excellent communication and analytical skills. Attendance at senior stakeholder meetings to explain project progress and design decisions is also expected, so good communication and planning skills are essential, with the ability to simplify technical concepts for a wider audience.

About You:

You should have a background in complex data transformation projects or project initiation, and be eager to work on fast-moving, critical projects, contributing to design decisions. Proven project delivery and advanced data validation experience are advantageous.

Key Skills & Experience:

• Proficiency with database systems such as Amazon Aurora MySQL, Microsoft SQL, Oracle, DynamoDB, etc.
• Expertise in designing, developing, and maintaining complex SQL queries and stored procedures.
• Performance tuning and optimization of data pipelines.
• Implementing data monitoring solutions.
• Developing scripts and automation tools for data management.
• Knowledge of version control systems like Git.
• Familiarity with AWS services: DMS, Lambda, S3, Step Functions, CloudWatch, Redshift, Glue, EventBridge.
• Experience with CI/CD pipelines and repositories (e.g., Bitbucket).
• Automated testing design and implementation.
• Experience with large-scale data environments and warehousing concepts.
• Data ingestion and integration experience.
• Strong organizational skills, proactive, curious about data and its value.
• Experience with agile methodologies using JIRA, Confluence, and Trello.
• Ability to collaborate with product management, data architects, and stakeholders.

Your benefits and rewards:

• 25 days annual leave, increasing with service up to 30 days.
• Private pension with employer contributions up to 16% based on age.
• Life, private medical, and dental insurance options, plus free eye tests.
• Stock/share purchase options.
• Flexible leave policies, wellbeing programs, cycle-to-work, volunteering days, gym discounts, retail and leisure discounts.

Location: The role is based in Manchester, Rotherham, or London. Our offices are hybrid, requiring visits no more than once a week, with possible travel to other sites. Candidates must be within commuting distance, as office presence policies may change in 2024.

Diversity: We value an inclusive culture where differences are embraced as strengths. Opportunities are equal and accessible.

How to apply: Please submit an updated CV and optional cover letter in English. For questions or more information, contact us.

We look forward to your application - Talent Acquisition Team

What to expect from Pearson:

Pearson was one of the top 10 most innovative education companies of 2022. We aim to be 100% digital, with strategic growth across divisions like Assessment & Qualifications, Virtual Learning, English Language Learning, Workforce Skills, and Higher Education. We promote diversity and inclusion, supporting talent development and a vibrant workplace.