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

Similar jobs