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.