Senior Data Management & Analytics Engineer

Job Description

Role: SeniorData Management & Analytics Engineer(full or part time)Division: Assessment & Qualifications DeliveryLocation: Rotherham or London, UK. Hybrid-workingSalary: £50-55k, plus target bonus of 8%About UK Assessment & QualificationsWe 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 JobThe 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, alongwith 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 mediumto 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 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 wideraudience.About YouThis 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 anadvantage.Key Skills & ExperienceTechnology

• AWS Aurora, DMS, Glue, Lambda, Quicksight, S3
• AWS SNSSQS pub/sub/queue concepts
• JenkinsTerraformInfrastructure as code
• JIRAKanban Boards, agile methodology
• MS SQL ServerTechnical knowledge
• MySQLTechnical knowledge
• OracleTechnical knowledge
• PostgreSQLTechnical knowledge
• PythonScript writing
• RedShiftTechnical knowledge
• TableauUnderstanding of BI reporting

Other Skills

• Automated testing design and setup
• Business IntelligenceDesign and best practice
• Change Data Capture understanding
• Data Warehousing concepts, design and loading strategies
• Excellent Communication & Planning
• CI/CDPipeline setup and repository (Bitbucket) knowledge Event driven architecture knowledge
• Microservice architecture understanding
• SQLScript 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

• JIRA & Confluence
• Teams and other Microsoft office apps
• Trello

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 certification as part of this role.Your benefits and rewardsHere at Pearson we offer a range of benefits, which include:

• 25 Days annual leave (increasing by 1 day with every year of continuous service up to 30 days); annual leave trading, +/- 5 days
• Annual Bonus
• 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

Diversity and Inclusion at PearsonPearson is delighted to be committed to the Race Charter and have pledged to ACT ON to support a more inclusive workplace for all our employees. We are confirmed by Stonewall in the Top 100 LGBTQ+ Employers in the Uk, and received 100% on the Human RightsCampaign Foundations Corporate Equality (CEI) Index for 2020, a primary driving force for LGBTQ workplace inclusion. We are on the Disability Equality Index, Bloomberg Gender Equality Index, have achieved Investors in People Gold, and are a Working Mums TopEmployer and Age Positive employer.#LI-POSTJob: TECHNOLOGYOrganization: Assessment & QualificationsSchedule: FULL_TIMEReq ID: 8819