We are looking for an experienced Snowflake / dbt Engineer to design, develop, and maintain scalable data warehouse solutions. The ideal candidate will have strong hands-on experience with Snowflake, dbt, SQL, and modern cloud data platforms, with the ability to build reliable and efficient data transformation pipelines.
Key Responsibilities
- Design, develop, and maintain data models using Snowflake and dbt.
- Build and optimize complex SQL queries, stored procedures, and data transformations.
- Develop scalable ELT/ETL pipelines for integrating data from multiple sources.
- Implement dbt models, tests, macros, snapshots, and documentation.
- Optimize Snowflake performance, query execution, and warehouse costs.
- Work with data engineering and analytics teams to deliver high-quality data solutions.
- Implement data quality checks, governance, and best practices.
- Troubleshoot data pipeline issues and ensure data reliability.
- Participate in architecture discussions and contribute to data platform improvements.
Required Qualifications
- Strong hands-on experience with Snowflake Data Cloud.
- Proficiency in dbt (data build tool), including dbt Core or dbt Cloud.
- Advanced SQL skills and experience with complex data transformations.
- Experience building and managing ELT/ETL data pipelines.
- Understanding of data warehousing concepts and dimensional modeling.
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Familiarity with Git, CI/CD, and data development best practices.
- Strong analytical, problem-solving, and communication skills.
Preferred Qualifications
- Experience with Python or other scripting languages.
- Familiarity with Airflow, Fivetran, Matillion, or similar data integration tools.
- Experience with data governance, data quality, and metadata management.
- Experience working in Agile development environments.