Senior Consultant Data Modeler (Engineering)

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

The Team

Were Intuita a fast growing consultancy part of FSP Group thats 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 clients businesses

If you dont fit the above criteriaexactlybut are interested in working for us get in touch anyway! we hire people not a job spec!

Whats in it for you

• Salary: 45000 - 68000 per annum DOE
  OR contractor day rates Outside IR35 can to be discussed in person for experienced Engineers with good availability.
• (Really) flexible and remote working we dont 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 youll 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 its in-person at socials or via silly Slack conversations.
• Dog friendly offices were a team of dog lovers so weve made our offices dog friendly!

Longer term our permanent hires attract the following key benefits as well as lighter wider perks and of course a welcoming supportive environment in which to develop and thrive is our best offering!

• Ourenhanced benefits package overview

If you require any support with your application please contact

Required Experience:

Senior IC