Overview In this role you will lead the modernization of a Snowflake-based data platform, driving architecture reviews, performance improvements, and governance. You'll collaborate with data engineers and platform teams to implement scalable, cost-efficient solutions and mentor junior developers. The position combines hands-on DBT/Snowflake work with architectural guidance to shape a robust data warehouse. A strong emphasis on optimization, best practices, and cross-team collaboration anchors your impact.
Responsibilities- Architecture review and optimization of the Snowflake data platform to improve scalability and cost-efficiency
- Code and SQL review of DBT models, SnowSQL scripts, and transformation logic with a focus on modularity and performance
- Performance tuning of slow queries and pipelines, advising on warehouse sizing, clustering, caching, and materialization
- Establish coding standards, data governance, lineage, and documentation practices; implement monitoring and alerting for data pipelines
- Collaborate with data engineers, analysts, and platform teams; mentor junior developers on Snowflake and DBT; participate in sprint planning, code reviews, and architectural discussions
Key requirements- Cloud Data Architect or Senior Data Engineer experience with Snowflake and other cloud DB environments
- Hands-on expertise in DBT, SnowSQL, and SQL performance tuning
- 10+ years in data modeling, ETL/ELT design, and data warehouse performance optimization
- Understanding of CI/CD pipelines, version control, and deployment automation
- Excellent communication skills to translate technical findings into actionable recommendations
- Experience with Oracle Exadata and PL/SQL is a plus for comparative analysis
- communication
- mentorship
- collaboration
- Snowflake
- DBT
- SnowSQL
