Senior Consultant - Data Modeler (Engineering)

Intuita - Vacancies; Remote; GBP 45,000 - 68,000; Full time

Job summary

A fast-growing consultancy in the UK seeks an experienced data engineer to lead a migration project, focusing on transforming an existing Data Warehouse into a modern AWS-based environment. This role requires expertise in data modelling, ETL processes, and strong SQL skills. Candidates will enjoy flexible remote working, a supportive team culture, and opportunities for professional development. Join this dynamic environment where your expertise will help solve complex data challenges while contributing to the company's success.

Benefits

Flexible working arrangements

Health and wellbeing support

Training and learning opportunities

Dog friendly offices

Supportive team environment

Qualifications

• Strong understanding of data modelling principles, such as Kimball.
• Proven experience in a data warehouse migration project.
• Hands-on experience in designing analytical data models.

Responsibilities

• Lead the delivery of a key migration project.
• Analyse existing data warehouse structures and reporting datasets.
• Design and document dimensional and analytical data models.

Skills

Data modelling principles

SQL

ETL/ELT development

Agile methodologies

Tools

AWS data platform services

dbt

Job description

🏢 All our office locations considered: Newbury & Liverpool (UK); Šibenik, Croatia, and India (considered)

👥 The Team

We’re Intuita – a fast growing consultancy part of FSP Group, that’s making waves in both the consultancy and technology space. With our ambitious goals we are looking for talented individuals to complement the team of experts we already have working across our business, becoming a pivotal part of our journey, to not just meet, but continuously exceed our client expectations!

We can offer an interesting insight into projects spanning a variety of sectors, which may include industries such as telecoms, insurance, finance and mortgages.

🧑🏾Who are we seeking?

Crucially we will prioritize and are ideally seeking those from the following industries:

Telco, Financial Services (ideally insurance, banking and pensions) and Healthcare and /or Life Sciences.

🦸♀️ First and foremost we seek strong Consultants; so if you are ready to explore our dynamic team where you can truly act as an expert in your field in support of our clients and their challenges in the world of data and technology, read on!

📝The Role

We are looking for an experienced, driven, and hands‑on data engineer with strong data modelling experience, to join our growing consultancy and lead the delivery of a key migration project.

You will play a key role in the migration and redevelopment of an existing Data Warehouse into a modern AWS‑based environment. This position focuses on analysing current ETL processes, understanding existing data structures, and re‑engineering them in line with dimensional and analytical modelling best practices.

There will be a strong emphasis on data modelling, transformation logic, and data quality.

Key to this role will be the ability to take ownership of highly technical data challenges, with an unrivalled attention to detail. You will thrive on complex data challenges, working both independently and through collaboration with team members to find elegant and efficient solutions.

Key outputs for 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.

Required Skills and Experience

Essential

· 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).

Desirable

· Experience with dbt for transformation modelling.

· Experience working within the Telecoms sector.

· Experience with AWS data platform services.

· Familiarity with BI/reporting tools and how data models support downstream consumption.

· Knowledge of data governance, metadata management, and data lineage practices.

What about You? You will be....

· Proactive, dynamic, and driven by delivering quality work, with a great eye for detail

· Takes accountability and ownership of tasks, and finds the best way to solve problems

· An excellent communicator who can make sense of and communicate complex ideas

· Ability to quickly understand client context and demonstrate expertise in their business

· A relationship builder, with the ability to motivate and engage effectively to build trust with clients and colleagues

· An interest in industry trends, emerging technologies, and client’s businesses

If you don’t fit the above criteria exactly but are interested in working for us, get in touch anyway! – we hire people, not a job spec!

❔ What’s in it for you?

• 💷 Salary: £45,000 - £68,000 per annum DOE
• 🏠 (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!

• Our enhanced benefits package overview

📧 If you require any support with your application, please contact [e-mail]