At a Glance
- Tasks: Design and support a modern cloud data warehouse using Snowflake and dbt.
- Company: Join a global consulting firm with a focus on innovation.
- Benefits: Competitive daily rate, hybrid work model, and potential contract extensions.
- Other info: Dynamic role with opportunities for professional growth and collaboration.
- Why this job: Make an impact in data engineering while working with cutting-edge technologies.
- Qualifications: Experience with Snowflake, dbt, and strong SQL skills required.
Robert Half International (an S&P 500 global staffing provider) is supporting a global consulting firm in sourcing an interim DBT Data Engineer. This role will focus on designing, delivering and supporting a modern cloud data warehouse using Snowflake and dbt, building scalable ELT pipelines and high-quality data models to support business-wide analytics and reporting.
Assignment Details
- Initial 6-month contract (extensions expected)
- Hybrid - 2 days per week on-site in the City of London
- £400-450 p/day + 12.07% hol pay (PAYE with employer's NI & Tax deducted at source)
- Start Date: c. 1-2 weeks turnaround
Key Skills & Experience
- Insurance / Reinsurance experience strongly preferred but broader Financial Services experience will also be considered
- Strong hands-on experience building and supporting data solutions in Snowflake (ELT pipelines, performance optimisation, data modelling)
- Proven experience with dbt including models, incremental loads, hooks, testing, snapshots and documentation
- Good operational understanding of dbt model failures, notifications, troubleshooting and production support workflows
- Excellent SQL engineering and data modelling experience (star/snowflake schemas, best practices)
- Experience designing and supporting end-to-end data pipelines (ingestion, transformation, validation)
- Familiarity with Snowflake features including Time Travel, cloning and RBAC
- Experience working in cloud-based data environments (Azure preferred, AWS also considered)
- Familiarity with CI/CD pipelines and deployment processes (Azure DevOps or similar)
- Strong communication skills and ability to work across technical and business stakeholders
Nice to have
- Experience with orchestration tools (Airflow, Azure Data Factory or similar)
- Python for automation, testing or data engineering support
- Exposure to Databricks or modern Lakehouse environments
All candidates must complete standard screening (Right to Work, DBS, credit/sanctions, employment verification). Robert Half Ltd acts as an employment business for temporary positions and an employment agency for permanent positions. Robert Half is committed to diversity, equity and inclusion. Suitable candidates with equivalent qualifications and more or less experience can apply. Rates of pay and salary ranges are dependent upon your experience, qualifications and training.
DBT Data Engineer employer: Robert Half
Robert Half International is an exceptional employer, offering a dynamic work environment in the heart of the City of London. With a strong commitment to diversity, equity, and inclusion, employees benefit from competitive pay rates, flexible hybrid working arrangements, and opportunities for professional growth within a global consulting firm. The collaborative culture fosters innovation and supports career advancement, making it an ideal place for those seeking meaningful and rewarding employment in the data engineering field.
StudySmarter Expert Advice🤫
We think this is how you could land DBT Data Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with data engineering or at firms that use dbt and Snowflake. 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 projects, especially those involving ELT pipelines and data modelling. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common technical questions related to dbt and Snowflake. We recommend practising your SQL skills and being ready to discuss your experience with data pipelines and troubleshooting model failures.
✨Tip Number 4
Don’t forget to apply through our website! It’s the easiest way to get your application noticed. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace DBT Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the DBT Data Engineer role. Highlight your experience with Snowflake, dbt, and any relevant financial services background. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific projects where you've built ELT pipelines or data models. We love seeing real examples of your work, especially if they relate to cloud data environments or CI/CD processes.
Be Clear and Concise:When writing your application, keep it clear and to the point. Use bullet points for key achievements and avoid jargon unless it's relevant. We appreciate straightforward communication!
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. We can’t wait to hear from you!
How to prepare for a job interview at Robert Half
✨Know Your DBT Inside Out
Make sure you’re well-versed in dbt, especially its features like models, incremental loads, and testing. Brush up on how to troubleshoot model failures and understand the production support workflows, as these are likely to come up during your interview.
✨Showcase Your SQL Skills
Prepare to demonstrate your SQL engineering prowess. Be ready to discuss your experience with data modelling, particularly star and snowflake schemas. You might even want to bring examples of past projects where you optimised performance or built scalable ELT pipelines.
✨Familiarise Yourself with Snowflake
Since this role heavily involves Snowflake, ensure you know its features like Time Travel and RBAC. It’s a good idea to have some practical examples of how you’ve used these features in previous roles to support your answers.
✨Communicate Effectively
Strong communication skills are key, especially when working with both technical and business stakeholders. Practice explaining complex technical concepts in simple terms, as you may need to do this during your interview to showcase your ability to bridge the gap between teams.
