At a Glance
- Tasks: Design and implement scalable data models using BigQuery and DBT.
- Company: Join a forward-thinking tech company focused on data innovation.
- Benefits: Competitive daily rate, flexible working arrangements, and opportunities for professional growth.
- Why this job: Make a significant impact on data architecture in a dynamic environment.
- Qualifications: Hands-on experience with BigQuery, Data Vault 2.0, and advanced SQL skills.
- Other info: Collaborate with talented teams and mentor others in best practices.
We are looking for a highly experienced Senior Data Modeller / Modeler with strong hands-on expertise in BigQuery, DBT, and Data Vault 2.0 to design and implement scalable enterprise data models on Google Cloud Platform (GCP).
This role requires someone who can independently design, implement and optimise Data Vault models within DBT, ensuring robust, scalable, and high-performing data structures to support analytics and business-critical reporting.
You will work closely with Data Engineers, Architects and Analytics teams to ensure models are both technically strong and aligned to business needs.
Key Responsibilities- Design and implement enterprise-scale data models in BigQuery
- Build and implement Data Vault 2.0 models using DBT (Hubs, Links, Satellites)
- Define and enforce data modelling standards, patterns and governance frameworks
- Translate business requirements into scalable logical and physical models
- Optimise BigQuery performance, partitioning and cost efficiency
- Ensure strong data lineage, traceability and auditability
- Support architecture decisions across the data lifecycle
- Collaborate closely with engineering and analytics teams
- Mentor teams on best practice enterprise modelling approaches
- Strong hands-on experience with BigQuery in production environments
- Proven experience implementing Data Vault 2.0 models (not just theoretical knowledge)
- Strong experience using DBT to build and manage transformations
- Ability to design and optimise enterprise-scale data models
- Advanced SQL skills, including performance tuning and optimisation
- Strong understanding of data lineage, governance and modelling standards
Data Modeler in Stoke-on-Trent employer: Norton Blake
Contact Detail:
Norton Blake Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeler in Stoke-on-Trent
✨Tip Number 1
Network like a pro! Reach out to your connections in the data modelling space, especially those who work with BigQuery and DBT. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best Data Vault models and any projects you've worked on. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling standards. Be ready to discuss how you’ve optimised performance in BigQuery and implemented Data Vault 2.0 models. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it’s a great way to ensure your application gets the attention it deserves.
We think you need these skills to ace Data Modeler in Stoke-on-Trent
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Modeler role. Highlight your hands-on experience with BigQuery, DBT, and Data Vault 2.0. We want to see how your skills match what we're looking for!
Showcase Your Projects: Include specific projects where you've designed and implemented data models. We love seeing real-world examples of your work, especially if they demonstrate your ability to optimise performance and ensure data governance.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Explain why you're passionate about data modelling and how your experience aligns with our needs. We appreciate a personal touch that shows us you really want to be part of the team.
Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at Norton Blake
✨Know Your Tools Inside Out
Make sure you’re well-versed in BigQuery, DBT, and Data Vault 2.0. Brush up on your hands-on experience and be ready to discuss specific projects where you've implemented these tools. The more detailed examples you can provide, the better!
✨Understand the Business Needs
Before the interview, take some time to think about how data modelling supports business objectives. Be prepared to explain how you translate business requirements into scalable models. This shows that you not only understand the technical side but also the bigger picture.
✨Showcase Your Collaboration Skills
Since this role involves working closely with Data Engineers, Architects, and Analytics teams, be ready to share examples of how you’ve successfully collaborated in the past. Highlight any mentoring experiences too, as they demonstrate leadership and a commitment to best practices.
✨Prepare for Technical Questions
Expect to dive deep into technical discussions during the interview. Brush up on advanced SQL skills, performance tuning, and optimisation techniques. Practising common interview questions related to data lineage and governance will help you feel more confident.