S
Sr. Snowflake Consultant
External job listingat Schrilltech
Tasks Design and develop enterprise-scale Star Schema data models in Snowflake using dbt. Build fact, dimension, bridge, and aggregate tables. Manage end-to-end data pipelines using Azure...
External source - not verified3 days agoOpen until: Feb 18, 2027
Salary
Not provided
Location
Houston, United States
Employment type
Full time
Workplace
Not provided
Sr. Snowflake Consultant
Houston, United States
Job description
Tasks
- Design and develop enterprise-scale Star Schema data models in Snowflake using dbt.
- Build fact, dimension, bridge, and aggregate tables.
- Manage end-to-end data pipelines using Azure Data Factory (ADF), dbt, and Data Vault.
- Develop and optimize complex SQL queries and Snowflake workloads.
- Implement dbt tests, documentation, and reusable data modeling standards.
- Automate deployments and infrastructure using GitHub Actions and Terraform.
- Review code, mentor engineers, and contribute to architecture decisions.
- Support API integrations and Power BI reporting solutions.
Requirements
- 8+ years of Data Engineering / Data Warehousing experience.
- 4+ years of hands-on dbt and Snowflake experience.
- Strong expertise in dbt models, testing, and production deployments.
- Snowflake architecture, performance tuning, and SQL optimization.
- Enterprise Star Schema / Dimensional Data Modeling.
- GitHub version control and hands-on SQL automation.
- Preferred: Data Vault Modeling
- Preferred: Azure Data Factory, Azure Synapse, or Microsoft Fabric
- Preferred: GitHub Actions and Terraform
- Preferred: Python, API integrations, and Datadog
- Preferred: SnowPro or DP-203 certification
Schedule
- Duration: Long-Term
How to apply
- Share your updated resume by email.
Location
- Houston, TX