Intuita

Senior Consultant – Data Modeler, Engineering

Intuita

full-time

Posted on:

Location Type: Hybrid

Location: Liverpool • 🇬🇧 United Kingdom

Visit company website
✨ AI Apply
Apply

Salary

💰 £45,000 - £68,000 per year

Job Level

Senior

Tech Stack

ETLSQL

About the role

  • 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!

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data modellingETLELTSQLdata warehouseanalytical modellingdimensional modellingreporting data modelsdata validationreconciliation testing
Soft skills
collaborationdocumentationcommunicationproblem-solvingattention to detail