Seeking a skilled DBT/Snowflake Engineer with extensive experience in data engineering and ETL processes. This offshore role focuses on leveraging dbt and Snowflake to build robust data solutions. A strong understanding of data transformations, quality assurance, and CI/CD integration is essential for success in this position.

This position offers the flexibility of remote work while contributing to a key data engineering function. We are looking for professionals who can bridge the gap between legacy systems and modern data warehousing practices.

Key responsibilities include translating complex Informatica mappings into dbt models within Snowflake. You will be instrumental in designing and implementing data layers, developing comprehensive data tests for quality assurance, and creating reusable dbt components like snapshots and macros. Collaboration with Snowflake developers and functional teams to ensure functional equivalence and optimize query performance will be crucial. Additionally, you will integrate dbt into CI/CD pipelines for automated workflows and contribute to essential documentation and defect analysis.

Candidates should possess over 7 years of experience in Data Engineering/ETL/DW, with a minimum of 2 years dedicated to working with dbt. Proficiency in SQL, particularly on Snowflake or similar cloud data warehouses, is a must. Familiarity with core dbt concepts, including models, tests, and macros, is expected. Prior experience with Informatica is highly desirable, as is a solid understanding of CI/CD practices and data modeling techniques. Effective communication skills and the ability to interpret existing ETL logic and documentation are also required.