At a Glance
- Tasks: Design and implement data integration solutions using Snowflake and dbt.
- Company: Join a leading tech firm focused on innovative data solutions.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on continuous improvement.
- Why this job: Be at the forefront of data technology and make a real impact.
- Qualifications: 7 years in data engineering with strong SQL and dbt skills.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking a talented and experienced Data Warehouse Modeler and Engineer to join the Data Solutions domain in EMEA. As a key contributor, you will be responsible for designing and implementing end-to-end data integration and transformation solutions on Snowflake. This role combines ETL/ELT design, data mapping, data modeling, and hands-on data engineering using dbt.
Key Responsibilities:
- Design and implement ETL/ELT pipelines for data ingestion, transformation, and consolidation.
- Perform data mapping from source systems to target Snowflake structures.
- Design and maintain conceptual, logical, and physical data models, staging, and integration marts.
- Develop, test, and maintain dbt models following best practices.
- Optimize Snowflake performance, query design, materializations, and clustering.
- Ensure data quality, consistency, lineage, and documentation.
- Collaborate with engineering, analytics, and platform teams to align on data patterns and standards.
Technical Qualifications:
- Bachelor's or Master's degree in Computer Science, Data Engineering, or a related technical field.
- 7 years of experience in a similar role within a fast-paced, enterprise-scale environment.
- Strong proficiency in SQL and hands-on experience with DBT Core or Cloud, or any other traditional ETL Tools (ODI, Informatica, Talend, SSIS, etc.).
- Snowflake data engineering, SQL data modeling, Kimball, Inmon, Data Vault concepts, ETL/ELT design, and data mapping.
- Data quality governance and performance optimization.
- A solid understanding of end-to-end data ingestion and transformation processes.
- AWS data stack (S3, Glue, EMR, PySpark, Iceberg) - nice to have.
Non-Technical Skills:
- Demonstrated commitment, ownership, and accountability.
- Strong attention to detail with a proactive approach to identifying and resolving problems.
- A genuine interest in emerging data technologies and a curiosity about continuous improvements.
- Excellent verbal and written communication skills.
Data Warehouse Modeler in Basildon employer: TESTQ Technologies
Join a forward-thinking company that values innovation and collaboration, where as a Data Warehouse Modeler, you will play a pivotal role in shaping data solutions within the EMEA region. Our inclusive work culture fosters continuous learning and professional growth, offering you the chance to work with cutting-edge technologies like Snowflake and DBT while enjoying a supportive environment that prioritises employee well-being and development.
StudySmarter Expert Advice🤫
We think this is how you could land Data Warehouse Modeler in Basildon
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field, especially those who work with Snowflake or DBT. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best data models and ETL pipelines. This is your chance to demonstrate your hands-on experience and problem-solving abilities, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data modelling questions and Snowflake specifics. We recommend practising your answers with a friend or even in front of the mirror to boost your confidence.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and engaged with our platform.
We think you need these skills to ace Data Warehouse Modeler in Basildon
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Snowflake, DBT, and data modelling. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data engineering and how your background makes you a perfect fit for our team at StudySmarter.
Showcase Your Technical Skills:Don’t forget to mention your proficiency in SQL and any hands-on experience with ETL/ELT tools. We love seeing candidates who can demonstrate their technical prowess, especially with Snowflake and DBT!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from our team!
How to prepare for a job interview at TESTQ Technologies
✨Know Your Snowflake
Make sure you brush up on your Snowflake knowledge before the interview. Understand its architecture, features, and how it integrates with ETL/ELT processes. Being able to discuss specific use cases or projects where you've implemented Snowflake will show your expertise.
✨Showcase Your SQL Skills
Since strong proficiency in SQL is a must-have, prepare to demonstrate your SQL skills during the interview. You might be asked to solve problems or optimise queries on the spot, so practice common SQL scenarios and be ready to explain your thought process.
✨Familiarise Yourself with DBT
DBT is a key part of this role, so make sure you know how to develop and maintain models using it. Be prepared to discuss best practices and any challenges you've faced while using DBT in previous projects. This will highlight your hands-on experience and problem-solving abilities.
✨Communicate Clearly
Excellent communication skills are essential, especially when collaborating with engineering and analytics teams. Practice explaining complex data concepts in simple terms, and be ready to discuss how you've worked with cross-functional teams in the past. This will demonstrate your ability to align on data patterns and standards.
