Senior Data Management & Analytics Engineer

Role: SeniorData Management & Analytics Engineer(full or part time)

Division: Assessment & Qualifications Delivery

Location: Rotherham or London, UK. Hybrid-working

About Pearson

We have more than 20,000 employees that deliver our products and services in nearly 200 countries, all working towards a common purpose – to help everyone achieve their potential through learning. We do that by providing high quality, digital content and learning experiences, as well as assessments and qualifications that help people build their skills and grow with the world around them.

From world-class assessment to virtual learning and beyond – we create the products and services that help tens of millions of people reach their goals each year. And we make sure our products fit with our key sustainability targets – to make learning accessible to everyone, to lead responsibly, and to give the next generation the skills they need to shape a better world.

Our success and ability to help people achieve their potential depends upon us being able to grow with, and adapt to, the rapidly changing learning market. That’s why our digital-first strategy puts consumers at the heart of everything we do, enabling us to deliver the best products and learning outcomes to more people than ever before.

Pearson is listed on both the London and New York Stock Exchanges (LON: PSON; NYSE: PSO).

About UK Assessment & Qualifications

We are responsible for the delivery of nearly 4 million examination results per annum, including A-Level, GCSE, BTEC and T-levels for students in UK and International centres. Our in-house systems process every learner from registration to marking and certification, in a highly regulated business. We currently operate a hybrid estate of predominantly bespoke systems, with an ongoing strategic transformation programme to migrate from on-prem to cloud based, cost effective, scalable and resilient services.

About the Job

The position is for a Data Management & Analytics Analyst, who has experience working with large data focused projects, and whose responsibility is around the transformation of data from legacy systems to modern cloud microservice based applications, along with working towards better methods of exploiting this data in terms of analytics and reporting. As such there will be work involving data pipelines, transformation strategies, and helping to establish a more advanced data reporting platform, with a medium to longer-term view of full data warehousing.

Currently we are in the middle of a large programme to transform a legacy estate to AWS, and therefore there is a large amount of data hosted in platforms such as Oracle and SQL server that needs to be linked in with new microservices, using CDC technology, along with making this and new microservice mastered data available for both end user reporting and downstream consumption of other data platforms.

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, from legacy to cloud preferably, and who is looking to work on fast moving projects and contribute to design decisions. A proven track record in delivering projects is an advantage.

Key Skills & Experience


  • AWS Aurora, DMS, Glue, Lambda, Quicksight, S3

  • AWS SNS\SQS pub/sub/queue concepts

  • Jenkins\Terraform – Infrastructure as code

  • JIRA – Kanban Boards, agile methodology

  • MS SQL Server – Technical knowledge

  • MySQL – Technical knowledge

  • Oracle – Technical knowledge

  • PostgreSQL – Technical knowledge

  • Python – Script writing

  • RedShift – Technical knowledge

  • Tableau – Understanding of BI reporting

Other Skills

  • Automated testing design and setup

  • Business Intelligence – Design and best practice

  • Change Data Capture understanding

  • Data Warehousing concepts, design and loading strategies

  • Excellent Communication & Planning

  • CI/CD – Pipeline setup and repository (Bitbucket) knowledge Event driven architecture knowledge

  • Microservice architecture understanding

  • SQL – Script design and writing to interrogate data

  • Teams and other Microsoft office apps

  • Experience with large-scale data environments

  • Experience with Integration / Ingestions of data sources into a Data Lake / Data Platforms

  • Excellent organisational skills, proactive, self-starter with a curious approach to data and its value

  • Presenting to stakeholders

  • Working with product management, product owners, data architects, business stakeholders

Desirable Skills & Experience

The role is aligned to either our Rotherham or central London offices. Our Rotherham office is located at Junction 1 of the M18, making it commutable from Sheffield, Leeds, Doncaster, Derby or Nottingham.

We have successfully worked from home throughout the pandemic, but ave adopted hybrid working now national restrictions are lifted; for this role that means visiting your base office no more than once a week with the possibility of occasional travel to other Pearson sites, however, adjustments to this due to personal circumstances & preferences are possible.

We work a 37.5-hour week, with all our team free to flex their day around our core hours, which are Monday to Friday, 10 to 4 GMT/BST. School runs, etc can be accommodated. Other flexible working patterns can be considered, including part-time working and non-traditional hours. As we regularly work with global teams, particularly in India and the US, there may be the occasional need to accommodate meetings outside of core hours.

We actively encourage our staff to participate in at least 40 hours of training a year, and offer relevant AWS (Amazon Web Service) training and certifi

Source link

Leave a Reply

Your email address will not be published. Required fields are marked *