Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data migration projects and design innovative data models in a dynamic consultancy.
- Company: Fast-growing consultancy with a focus on technology and client satisfaction.
- Benefits: Competitive salary, flexible remote work, wellness support, and continuous learning opportunities.
- Why this job: Join a supportive team and tackle exciting data challenges while making a real impact.
- Qualifications: Experience in data modelling, ETL processes, and strong SQL skills required.
- Other info: Dog-friendly offices and a culture that values collaboration and creativity.
The predicted salary is between 39000 - 61000 £ per year.
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 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 OR contractor day rates, Outside IR35 can to be discussed in person for experienced Engineers with good availability.
(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.
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.
Our enhanced benefits package overview.
Senior Consultant in Liverpool employer: Intuita - Vacancies
Contact Detail:
Intuita - Vacancies Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Consultant in Liverpool
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend relevant events, and engage with professionals on platforms like LinkedIn. We can’t stress enough how important it is to make those personal connections that could lead to job opportunities.
✨Tip Number 2
Prepare for interviews by researching the company and its projects. Understand their values and recent developments, especially in sectors like telecoms and finance. We want you to show them you’re not just another candidate, but someone who genuinely cares about their mission.
✨Tip Number 3
Practice your pitch! Be ready to explain how your skills align with their needs, particularly around data modelling and ETL processes. We believe that a confident presentation of your expertise can set you apart from the crowd.
✨Tip Number 4
Don’t forget to follow up after interviews! A simple thank-you email can go a long way in keeping you top of mind. We recommend expressing your enthusiasm for the role and reiterating how you can contribute to their team.
We think you need these skills to ace Senior Consultant in Liverpool
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Consultant role. Highlight your experience in data modelling and any relevant projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to tell us why you're passionate about this role and how your background makes you a perfect fit. Don't forget to mention your experience in the industries we prioritise!
Showcase Your Technical Skills: Since this role is all about data, make sure to showcase your technical skills clearly. Mention your SQL expertise, ETL/ELT development experience, and any familiarity with AWS services. We love seeing those details!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get the best experience possible. Plus, it shows you're keen to join our team!
How to prepare for a job interview at Intuita - Vacancies
✨Know Your Data Modelling Inside Out
Make sure you brush up on your data modelling principles, especially Kimball and dimensional modelling. Be ready to discuss how you've applied these in past projects, as this will show your expertise and understanding of the role.
✨Showcase Your ETL Experience
Prepare to talk about your hands-on experience with ETL/ELT processes. Have specific examples ready where you've analysed existing transformation logic or validated data pipelines, as this will demonstrate your technical skills and problem-solving abilities.
✨Communicate Clearly and Confidently
Since you'll be collaborating with various stakeholders, practice explaining complex data concepts in simple terms. This will not only highlight your communication skills but also your ability to understand client contexts and build relationships.
✨Be Ready for Agile Discussions
Familiarise yourself with Agile methodologies like Scrum and Kanban. Be prepared to discuss how you've worked in such environments before, as this will show that you can adapt to their dynamic team structure and contribute effectively.
