Snowflake DBT Engineer

We have an opening for Snowflake DBT Engineer at Chicago, IL or Atlanta, GA Kindly apply with your updated resume if you are interested. Please find the job details below:

Position: Snowflake DBT Engineer

Location: Chicago, IL or Atlanta, GA

Duration: 12 Months contract position

We are seeking a skilled Snowflake DBT Engineer to design, develop, and optimize modern cloud-based data warehouse solutions. The ideal candidate will have hands-on experience with Snowflake, DBT (Data Build Tool), SQL, and ETL/ELT processes. The role involves building scalable data models, transforming raw data into analytics-ready datasets, and supporting data-driven business initiatives.

Description:

• Design, develop, and maintain data transformation pipelines using DBT.
• Build and optimize data models, marts, and warehouse structures in Snowflake.
• Develop and maintain SQL-based data transformations and business logic.
• Implement ELT processes to load and transform data from multiple sources.
• Monitor and optimize Snowflake performance, storage, and query efficiency.
• Create reusable DBT models, macros, tests, and documentation.
• Collaborate with Data Engineers, BI Developers, Analysts, and business stakeholders.
• Ensure data quality, integrity, and governance through automated testing and validation.
• Troubleshoot data pipeline issues and implement performance improvements.
• Participate in code reviews, deployment activities, and CI/CD processes.
• Strong experience with Snowflake Data Warehouse.
• Hands-on experience with DBT (Data Build Tool).
• Advanced SQL development and query optimization skills.
• Experience with ETL/ELT frameworks and data integration tools.
• Knowledge of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
• Experience with Git version control.
• Understanding of cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Familiarity with data orchestration tools like Airflow, Prefect, or similar.