Snowflake Data Architect (with DBT, SQL Experience) - Houston, TX

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Snowflake
DBT
SQL
Data Architect
Data Engineer

Job Details

We are seeking a highly skilled Data Architect / Sr. Data Engineer with strong expertise in Snowflake and DBT to design, build, and optimize data solutions that drive business insights and decision-making. The ideal candidate will be hands-on with data modeling, ETL/ELT processes, and performance tuning, with a strong command of SQL. Prior financial industry experience will be advantageous but is not mandatory.

Type: Contract

Location: Houston, TX (hybrid 3 days)

Local Preferred

Key Responsibilities

  • Architect, design, and implement scalable data solutions leveraging Snowflake and DBT.
  • Develop and optimize SQL queries, data models, and transformation pipelines.
  • Collaborate with business stakeholders, analysts, and data scientists to translate requirements into efficient data solutions.
  • Implement best practices for data governance, quality, security, and compliance.
  • Monitor, troubleshoot, and enhance data pipelines for performance and reliability.
  • Drive automation and CI/CD practices within the data engineering ecosystem.
  • Provide technical leadership and mentorship to junior engineers where needed.

Required Skills & Experience

  • 8+ years of experience in data engineering or data architecture roles.
  • Strong hands-on expertise with Snowflake (data modeling, performance optimization, security, and integration).
  • Proficiency in DBT for transformation and workflow management.
  • Advanced knowledge of SQL (query optimization, complex joins, window functions, CTEs).
  • Experience in data pipeline orchestration and integration tools (e.g., Airflow, Prefect, or similar).
  • Solid understanding of ETL/ELT design patterns, data warehousing concepts, and modern data architectures.
  • Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform).

Nice to Have

  • Previous experience working in the financial services domain (banking, insurance, capital markets, fintech).
  • Exposure to data visualization or BI tools (Tableau, Power BI, Looker).
  • Experience with version control, CI/CD, and DevOps practices for data.
  • Strong problem-solving, analytical, and communication skills.

Share resumes to - knikesh (at) techwave (dot) com

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.