Hybrid Senior Consultant – Data Modeler, Engineering

Posted 3 weeks ago

Apply now

About the role

  • Senior Consultant specializing in data modeling for consultancy projects in various sectors. Leading the migration to modern AWS-based environments and ensuring data quality and best practices.

Responsibilities

  • Analyse existing data warehouse structures, ETL logic, and reporting datasets to understand current data flows and business rules.
  • Design and document dimensional, analytical, and reporting data models aligned to business requirements and best-practice modelling standards.
  • Design clear mapping specifications from source systems to target dimensional models.
  • Perform testing, reconciliation, and validation of new models and pipelines to ensure data correctness and completeness.
  • Collaborate with Data Engineers, BI Developers, and business stakeholders to ensure models support analytical, reporting, and operational needs.
  • Support the wider project team with documentation, data lineage, definitions, and modelling artefacts.
  • Contribute to improving modelling standards, governance, and data quality across the project.

Requirements

  • Strong understanding of data modelling principles (e.g., Kimball, dimensional modelling, analytical modelling).
  • Proven experience delivering or contributing to a data warehouse build or migration project.
  • Hands-on experience designing analytical and reporting data models.
  • ETL/ELT development experience, including analysis of existing transformation logic.
  • Strong SQL skills, comfortable writing complex queries for transformation, validation, and reconciliation.
  • Experience validating data pipelines and performing reconciliation testing between legacy and new environments.
  • Ability to translate business requirements into robust data model designs.
  • Strong documentation skills, including producing data dictionaries, mappings, and model diagrams.
  • Experience working in an Agile methodologies (Scrum / Kanban).

Benefits

  • Really flexible and remote working – we don’t mind when, where or how you work; you are trusted to work in the way that suits you best.
  • Genuine care and support for your health and wellbeing – free therapy sessions, financial education, birthday treats and much more.
  • Incredible training and learning opportunities – you’ll be surrounded by the best in the business and encouraged to keep growing.
  • Freedom and empowerment to own problems and explore new ideas – we allow our consultants to actually be consultants, not just bodies.
  • A supportive, friendly team – we work hard and enjoy spending time together, whether it’s in-person at socials or via silly Slack conversations.
  • Dog friendly offices – we’re a team of dog lovers, so we’ve made our offices dog friendly!

Job title

Senior Consultant – Data Modeler, Engineering

Job type

Experience level

Senior

Salary

£45,000 - £68,000 per year

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job