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, health insurance, and flexible working options.
- Why this job: Be part of critical projects that shape education for millions globally with a supportive 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 36000 - 60000 £ 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 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 SNSSQS 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 - UK
Contact Detail:
Pearson - UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as AWS services and SQL databases. Being able to discuss your hands-on experience with these tools during interviews will demonstrate your suitability for the role.
✨Tip Number 2
Prepare examples of past projects where you successfully managed data transformation or ingestion. Highlight your problem-solving skills and how you communicated complex data concepts to non-technical stakeholders.
✨Tip Number 3
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 be invaluable during your interview.
✨Tip Number 4
Stay updated on the latest trends in data engineering and analytics. Being knowledgeable about industry advancements can help you engage in meaningful discussions during interviews and show your passion for the field.
We think you need these skills to ace Data Engineer
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 skills, provide examples in your CV or cover letter where you've successfully communicated complex technical concepts to non-technical stakeholders.
Showcase Project Experience: Detail your experience with large-scale data projects, particularly those involving data ingestion and validation. Mention specific tools and methodologies you've used, such as CI/CD pipelines or JIRA.
How to prepare for a job interview at Pearson - UK
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in database systems like MySQL and AWS during the interview. Be prepared to discuss specific projects where you've designed complex SQL queries or optimised data pipelines, as this will demonstrate your hands-on experience.
✨Communicate Clearly
Since the role involves explaining technical concepts to non-technical stakeholders, practice simplifying complex ideas. Use examples from your past experiences to illustrate how you’ve successfully communicated project progress or design decisions to a diverse audience.
✨Demonstrate Problem-Solving Skills
Prepare to discuss how you've proactively identified and addressed data issues in previous roles. Share specific instances where your analytical skills led to improved data management or performance tuning, showcasing your ability to think critically under pressure.
✨Familiarise Yourself with Agile Methodologies
Since the company uses JIRA and Kanban boards, it’s beneficial to understand agile methodologies. Be ready to talk about your experience working in agile environments and how you’ve contributed to team success through collaboration and adaptability.