Senior Analytics Engineer

Job Description

We’re on a mission to provide equitable access to economic opportunity, for everyone.

We close critical skill gaps in the workforce through a new kind of apprenticeship that combines work and learning. We begin by recognizing high-potential individuals both inside and outside of a company's current workforce and then we create applied, guided and equitable learning programs, with measurable impact. Because we believe the world needs a better way to match its potential.

We work with over 1,000 leading companies including the likes of Microsoft, Citi and Just Eat to help solve their business-critical problems, and we’ve trained over 12,000 professional apprentices in the tech and data skills of the future. This is made possible by our global team who are driven to achieve a mission that matters, together.

Join Multiverse and help us set a new course for work.

What we need:

As a Senior Analytics Engineer, you will be responsible for building and maintaining the data sources that underpin our analytics tools and data science models. This will primarily involve building and automating data transformation pipelines in dbt, but could also cover a wide range of other data engineering activities.

The role will be within the Data & Insight team reporting to the Director of Data Engineering and Infrastructure. You will need to be methodical, analytical, creative and collaborative, with very high attention to detail.

What you will focus on:

Data Modelling & Transformation

• Lead the design, implementation, and optimisation of dbt models, streamlining schemas, transformations, and documentation in order to scale data operations effectively

• Defining, implementing and maintaining canonical upstream data models (e.g. Kimball, Inmon) that enable a wide range of downstream use-cases

• Working closely with our Analytics and Data Science teams to understand their requirements, and ensuring that our data model designs satisfy these use cases

• Reviewing the proposed data architecture of new products being developed by our Technology team to ensure that they will provide the necessary data to meet our requirements

dbt Expertise and Mentoring

• Defining and implementing best practice usage of dbt, and ensuring that this is adopted throughout our team and codebase

• Being a subject-matter expert within the Data Engineering team on dbt, and using this knowledge to improve the skillset and performance of other team members

• Developing a testing-first culture in the team to ensure that Data Quality is both monitored and improved through our pipelines

Data Pipeline Automation and Administration

• Developing a flexible and scalable approach to data processing through dbt job definitions and scheduling

• Enhancing our deployment CI/CD pipelines to optimise our developer experience and streamline our development processes, while maintaining the quality of our deployed code

• Monitoring our dbt job executions and ensuring that errors are tracked and resolved inline with agreed SLAs

• Collaborating with other Data Engineers to define the requirements for data source ingestion pipelines

• Ensuring that our dbt deployments satisfy the data access controls of the business, and that data access is managed securely

What we’re looking for:

Required

• 4+ years of building and optimising complex PostgreSQL

• Strong experience working with dbt for analytics use-cases

• Experience with CI/CD (GitHub) for data

• Experience with writing and leveraging automated tests in dbt

• Proven track record of producing high quality and robust data deliverables

• Meticulous attention to detail

• Commitment to Multiverse’s mission and values

Desirable

• Experience with AWS services - e.g. RDS, S3, Lambda, ECS

• Working knowledge of Python

• Experience of working with various data file types (e.g. CSV, JSON, XML, Avro and Parquet for example)

• Experience with Tableau (Desktop/Server) and/or Alteryx

• Experience using Infrastructure as Code (Terraform)

• Experience working in an Agile environment

• Working knowledge of talent/admissions or education/skills sector

Benefits

• Time off - 27 days holiday, plus 7 additional days off: 1 life event day, 2 volunteer days and 4 company-wide wellbeing days

• Health & Wellness- private medical Insurance with Bupa, a medical cashback scheme, life insurance, gym membership & wellness resources through Gympass and access to Spill - all in one mental health support

• Hybrid & remote work offering - with weekly or monthly visits to the London office and the opportunity to work abroad 45 days a year

• Team fun - weekly socials, company wide events and office snacks!

Our commitment to Diversity, Equity and Inclusion

We’re an equal opportunities employer. And proud of it. Every applicant and employee is afforded the same opportunities regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. This will never change.

Safeguarding

All posts in Multiverse involve some degree of responsibility for safeguarding. Successful applicants are required to complete a Disclosure Form from the Disclosure and Barring Service ("DBS") for the position. Failure to declare any convictions (that are not subject to DBS filtering) may disqualify a candidate for appointment or result in summary dismissal if the discrepancy comes to light subsequently.