At a Glance
- Tasks: Lead data migration projects and design innovative data models.
- Company: Join Intuita, a fast-growing consultancy making waves in tech.
- Benefits: Flexible remote work, competitive salary, and wellness support.
- Other info: Enjoy a supportive culture with opportunities for growth and fun team activities.
- Why this job: Be part of a dynamic team solving complex data challenges.
- Qualifications: Experience in data modelling and strong SQL skills required.
The predicted salary is between 45000 - 68000 £ per year.
We are Intuita - a fast growing consultancy part of FSP Group, that is 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.
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.
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 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:
- 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.
- Experience working in Agile methodologies (Scrum / Kanban).
- 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.
- 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!
Salary: £45,000 - £68,000 per annum DOE OR contractor day rates, Outside IR35 can be discussed in person for experienced Engineers with good availability.
What’s in it for you?
- (Really) flexible and remote working; 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!
Senior Consultant - Data Modeler (Engineering) in Liverpool employer: Intuita
As a leading data consultancy in the UK, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to excel. With competitive salaries, hybrid working options, and a strong emphasis on professional development, we provide our team members with the tools and support they need to thrive in their careers. Join us in Newbury, where your expertise will be valued, and you'll have the opportunity to lead impactful projects in a dynamic environment.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Consultant - Data Modeler (Engineering) in Liverpool
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Intuita!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Consultant - Data Modeler (Engineering) at Intuita.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Intuita.
✨Apply Directly through Our Website
When you find a suitable opening like Senior Consultant - Data Modeler (Engineering) at Intuita, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Senior Consultant - Data Modeler (Engineering) in Liverpool
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Intuita, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Intuita. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Intuita
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Intuita!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.