We are looking for an experienced Snowflake DBT Architect to join our team and lead the design and implementation of scalable, cloud-native data platforms. The ideal candidate will have strong expertise in Snowflake, dbt, modern data architecture, and data transformation frameworks.
Key Responsibilities
- Design and architect enterprise-grade data warehouse and lakehouse solutions using Snowflake.
- Develop and implement scalable ELT frameworks using dbt Core/dbt Cloud.
- Build reusable dbt models, macros, snapshots, and testing frameworks.
- Define and implement data modeling standards including Star Schema and Data Vault.
- Optimize Snowflake performance, scalability, and cost efficiency.
- Design secure, governed, and high-quality data solutions.
- Collaborate with business stakeholders, data engineers, analytics teams, and solution architects.
- Lead technical discussions, code reviews, and architecture best practices.
- Mentor teams and drive data modernization initiatives.
Required Skills
- 8+ years of experience in Data Engineering and Data Warehousing.
- 4+ years of experience with Snowflake.
- 3+ years of hands-on experience with dbt (Core or Cloud).
- Strong SQL and Python programming skills.
- Expertise in Snowflake features such as Streams, Tasks, Snowpipe, Dynamic Tables, Time Travel, and Secure Data Sharing.
- Experience with CI/CD tools such as Azure DevOps, GitHub Actions, or Jenkins.
- Strong understanding of data modeling, ELT frameworks, and performance tuning.
- Experience working on Azure, AWS, or GCP platforms.
Preferred Qualifications
- SnowPro Core or SnowPro Advanced Certification.
- dbt Fundamentals Certification.
- Experience with Airflow, Azure Data Factory (ADF), or other orchestration tools.
- Exposure to Power BI, Tableau, or Looker.
- Consulting and client-facing experience preferred.