Haybury are seeking an experienced Data Engineer to join our team supplying a service to one of our leading global pharmaceutical clients in Spain.
This is an urgent and critical migration project, transitioning from Snowflake to DBT for data transformation and modelling. This role will involve working closely with our existing team of data experts to ensure smooth development and migration of our SQL-based data models. You will play a key role in building and maintaining data pipelines that support advanced analytics and reporting.
Key Responsibilities:
- Other consultants will lead the preparation and ingestion of the data whilst this role will expect you to lead the development and migration of data models from Snowflake to DBT
- Role in charge of develop and ensure quality of DBT code
- Collaborate with the team to build and maintain DBT models for efficient data pipelines
- Write and optimize SQL code for data modelling and transformation
- Ensure smooth data migration and transformation processes, aligning with best practices for analytics and reporting
- Partner with other consultants handling data preparation and ingestion to ensure seamless collaboration
- Monitor data pipeline performance, troubleshoot issues, and continuously improve processes
- Maintain excellent communication in English, collaborating effectively with team members and stakeholders
Must-Have Expertise:
- Data modelling: Proven experience in developing data models for analytics and reporting
- DBT model development: Experience in building, maintaining, and optimizing DBT models
- Migration from Snowflake to DBT: Hands-on experience with transitioning code and processes from Snowflake to DBT
- SQL pipelines: Ability to develop and maintain SQL pipelines for transforming and preparing data for analytics
- Strong English communication skills: Both verbal and written, for effective collaboration
- Ability to translate technical requirements to business liaising with stakeholders
If you have the skills and experience for this opportunity, then please apply or email Loren your CV today to loren.cardy@hayburysearch.com.
Loren is a Client Partner at Haybury Search covering Europe, UK, North America and Asia.