Data Engineer

Data Engineer

Rotherham Full-Time 28800 - 48000 £ / year (est.) Home office (partial)
P

At a Glance

  • Tasks: Transform, ingest, and validate data from various sources while enhancing analytics and reporting.
  • Company: Join Pearson, a leader in creating impactful learning experiences since 1844.
  • Benefits: Enjoy 25 days annual leave, private pension, flexible working, and wellness programmes.
  • Why this job: Be part of critical projects that shape education for millions globally with a supportive team culture.
  • Qualifications: Experience in data transformation, SQL, AWS, and excellent communication skills are essential.
  • Other info: Hybrid working model with occasional travel; embrace diversity and inclusion at Pearson.

The predicted salary is between 28800 - 48000 £ per year.

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 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 SMEs, 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 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

Data Engineer employer: Pearson Education

At Pearson, we are committed to fostering a vibrant work culture that prioritises employee growth and well-being. With generous benefits such as a robust pension scheme, flexible working policies, and opportunities for professional development, our Rotherham, Manchester, and London offices provide an ideal environment for Data Engineers to thrive while contributing to meaningful projects that impact learners worldwide.
P

Contact Detail:

Pearson Education Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer

✨Tip Number 1

Familiarise yourself with AWS services mentioned in the job description, such as Lambda and S3. Having hands-on experience or projects showcasing your skills with these tools can set you apart during discussions.

✨Tip Number 2

Brush up on your SQL skills, especially complex queries and performance tuning. Be prepared to discuss specific examples of how you've optimised data pipelines in past roles.

✨Tip Number 3

Practice explaining technical concepts in simple terms. Since the role involves communicating with non-technical stakeholders, being able to convey your ideas clearly will be crucial.

✨Tip Number 4

Network with current or former employees of Pearson, especially those in similar roles. They can provide insights into the company culture and expectations, which can help you tailor your approach.

We think you need these skills to ace Data Engineer

Proficiency in database systems such as Amazon Aurora MySQL, Microsoft SQL, Oracle, DynamoDB
Expertise in designing, developing, and maintaining complex SQL queries and stored procedures
Advanced performance tuning and optimisation of data pipelines
Implementation and maintenance of data monitoring solutions
Development of scripts and automation tools for data management
Familiarity with version control systems (e.g., Git)
Knowledge of AWS services including DMS, Lambda, S3, Step Functions, CloudWatch, Redshift, Glue, Event Bridge
Understanding of Change Data Capture
CI/CD pipeline setup and repository knowledge (Bitbucket)
Automated testing design and setup
Experience with large-scale data environments
Data Warehousing concepts and loading strategies
Integration and ingestion of data
Excellent organisational skills and proactive approach to data
Understanding of AWS SNS/SQS pub/sub/queue concepts
Experience with JIRA and Kanban Boards
Strong communication and planning skills

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the Data Engineer role. Focus on your proficiency in database systems, data transformation projects, and any experience with AWS or SQL.

Craft a Compelling Cover Letter: Although optional, a cover letter can set you apart. Use it to explain why you're passionate about the role and how your background makes you a perfect fit for Pearson's mission of enhancing learning experiences.

Highlight Communication Skills: Since the role requires excellent communication and planning skills, provide examples in your CV or cover letter where you've successfully communicated complex data concepts to non-technical stakeholders.

Showcase Relevant Projects: Include specific projects in your application that demonstrate your experience with large-scale data environments, data validation, and automation tools. This will help illustrate your hands-on expertise and problem-solving abilities.

How to prepare for a job interview at Pearson Education

✨Showcase Your Technical Skills

Be prepared to discuss your experience with database systems like MySQL and AWS. Highlight specific projects where you designed complex SQL queries or optimised data pipelines, as this will demonstrate your hands-on expertise.

✨Communicate Clearly

Since the role involves explaining technical concepts to non-technical stakeholders, practice simplifying your explanations. Use analogies or examples that relate to everyday experiences to make your points clear and relatable.

✨Demonstrate Problem-Solving Abilities

Prepare to discuss how you've tackled challenges in previous data projects. Share specific instances where you identified issues in data management and the steps you took to resolve them, showcasing your analytical skills.

✨Familiarise Yourself with Agile Methodologies

As the role involves working with product management and agile teams, brush up on your knowledge of JIRA and Kanban boards. Be ready to discuss how you've used these tools in past projects to manage workflows and enhance team collaboration.

P
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>