Expert Data Analytics Engineer (DBT and Snowflake)

Ian Martin Group; Spring (TX); On-site; USD 96,000 - 110,000; Full time

Job summary

Raise is hiring an Expert Data Analytics Engineer (DBT and Snowflake) onsite in Spring, TX for a 12-month contract. You will own the analytics layer, turning raw data into trusted star schemas in Snowflake using dbt, with 70% hands-on work and the rest coaching engineers and refining the platform.

You will design star-schema models, manage end-to-end data flow from ADF to Power BI, and automate SQL workloads. Strong dbt and Snowflake experience is required, with leadership in technical design.

Qualifications

• 8+ years in data engineering or data warehousing.
• 4+ years hands-on dbt and Snowflake work.
• Expert, hands-on dbt experience producing models and tests.
• Snowflake expertise including architecture and SQL optimization.
• Proven experience designing enterprise-scale star schemas.
• Hands-on automation of SQL workloads and data processes.
• Track record of independent work and leading technical design decisions.
• GitHub version control experience.

Responsibilities

• Design and build star-schema data models in Snowflake using dbt.
• Own end-to-end data flow from Azure Data Factory through dbt to Power BI outputs.
• Write, tune, and automate complex SQL for large Snowflake workloads.
• Build dbt tests, docs, and reusable patterns to ensure data quality.
• Automate builds and infrastructure with GitHub Actions and Terraform.
• Review code and coach backend engineers and data engineers.
• Set data modeling standards and influence platform architecture.
• Propose improvements and contribute new ideas to the platform.
• Support API components feeding data into the platform.
• Collaborate with product owners and business teams on data models.

Skills

dbt

Snowflake

SQL optimization

Star schema

GitHub

Power BI

Automation

Data modeling

Tools

Azure Data Factory

Terraform

GitHub Actions

Datadog

Azure Synapse

Microsoft Fabric

Job description

Expert Data Analytics Engineer (DBT and Snowflake)

• Pay Rate: $70 - $80/hour (on W2)
• Contract Length: 12 Months
• Location: Onsite | Spring, TX 77389

Raise is currently hiring a contract team member on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader.

Job Overview

Your data models show leaders how their projects perform. In this role, you own the analytics layer that turns raw data into trusted star schemas in Snowflake, built with dbt (data build tool) and used in Power BI. You spend about 70% of your time hands‑on and the rest reviewing code, coaching engineers, and bringing in new ideas. You don’t need industry‑specific experience. Strong data engineering practice is what counts.

Responsibilities

• Design and build star-schema data models in Snowflake using dbt, including fact, dimension, bridge, and aggregate tables.
• Own the data flow end to end, from intake in Azure Data Factory (ADF), through dbt and a Data Vault layer, to the star schemas that power Power BI reports.
• Write, tune, and automate complex SQL and large Snowflake workloads.
• Build dbt tests, documentation, and reusable patterns that keep data quality high.
• Automate builds and infrastructure with GitHub Actions and Terraform.
• Review code, spot what works and what doesn’t, and coach backend developers and data engineers side by side.
• Set data modeling standards and shape architecture decisions for the platform.
• Propose improvements and bring new ideas to the platform.
• Support the API components that feed data into the platform.
• Partner with product owners, architects, and business teams to turn project performance questions into data models.

Qualifications

Required

• 8+ years in data engineering or data warehousing, including 4+ years of hands‑on dbt and Snowflake work.
• Expert, hands‑on dbt experience: you’ve built models, written tests, and deployed them to production yourself.
• Expert Snowflake experience, including architecture, performance tuning, and SQL optimization.
• Proven work designing and building enterprise‑scale star‑schema (dimensional) data models.
• Hands‑on experience automating SQL workloads and data processes.
• A track record of working on your own, solving data problems from start to finish, and leading technical design decisions.
• Hands‑on experience with GitHub for version control and team development.

Preferred

• Data Vault modeling.
• Azure Data Factory (ADF), Azure Synapse, or Microsoft Fabric.
• GitHub Actions and Terraform.
• Python for data engineering and automation.
• Experience using AI in data work.
• Experience with API data integration.
• Observability tools such as Datadog.
• SnowPro, DP-203, or similar cloud data certifications.

Looking for meaningful work? We can help

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/

#USENSF26