ETL/Data Warehouse Consultant

Brooksource; San Antonio (TX); On-site; USD 96,000 - 152,000; Full time

Job summary

You will build scalable pipelines, ensure data quality, and support critical reporting initiatives while collaborating with business stakeholders and engineering teams. This is a 1-year contract requiring onsite work in San Antonio, TX.

Qualifications

• 5+ years of ETL/Data Warehouse experience.
• Strong Snowflake and dbt experience.
• Advanced SQL development and Python for ETL automation.
• Onsite in San Antonio, TX for the duration of the contract.

Responsibilities

• Design, develop, test, and deploy ETL/ELT pipelines in Snowflake environments.
• Build and maintain dbt models, tests, and documentation.
• Write and optimize complex SQL queries for data extraction and reporting.
• Develop Python scripts for data ingestion, validation, and operational workflows.
• Collaborate with stakeholders and engineers to translate requirements into scalable solutions.
• Analyze data warehouse processes and recommend performance and quality improvements.
• Implement data quality checks and validation frameworks across pipelines.
• Support Snowflake performance tuning, including clustering considerations and ELT design.
• Participate in Agile ceremonies and production support activities.
• Document data mappings, transformation logic, and operational procedures.

Skills

ETL Development

SQL proficiency

Python scripting

Data warehousing concepts

Quality/data governance

Agile/Scrum

Onsite collaboration

Tools

Snowflake

dbt

Airflow

Dagster

Control-M

Jira/ServiceNow

Job description

Duration: 1-year contract

Role Type: ETL/Data Warehouse Consultant

Position Overview

We are seeking an experienced ETL/Data Warehouse Consultant to support the design, development, optimization, and maintenance of enterprise data solutions. This consultant will work primarily with dbt, Snowflake, Python, and SQL to build scalable data pipelines, transform data across warehouse layers, improve data quality, and support business-critical reporting and analytics initiatives.

Key Responsibilities

• Design, develop, test, and deploy ETL/ELT pipelines to move and transform data within Snowflake data warehouse environments.
• Build and maintain dbt models, macros, tests, documentation, and lineage to support reliable data transformation workflows.
• Write, optimize, and troubleshoot complex SQL queries for data extraction, transformation, performance tuning, and reporting support.
• Develop Python scripts and automation to support data ingestion, transformation, validation, monitoring, and operational workflows.
• Partner with business stakeholders, data analysts, architects, and engineering teams to gather requirements and translate them into scalable technical solutions.
• Analyze existing data warehouse processes and recommend improvements related to performance, reliability, data quality, and maintainability.
• Implement data quality checks, reconciliation processes, and validation frameworks to ensure accuracy and consistency across data pipelines.
• Support Snowflake performance optimization, including query tuning, warehouse sizing, clustering considerations, and efficient ELT design.
• Participate in Agile ceremonies, design reviews, deployment planning, defect resolution, and production support activities.
• Document technical designs, data mappings, transformation logic, and operational processes for long-term supportability.

Required Qualifications

• Strong hands-on experience as an ETL Developer, Data Warehouse Developer, Data Engineer, or Data Warehouse Consultant.
• Proficiency with Snowflake, including databases, schemas, warehouses, roles, security concepts, and performance optimization.
• Hands-on experience with dbt for data modeling, transformations, testing, documentation, and deployment workflows.
• Advanced SQL development skills, including complex joins, window functions, query optimization, stored procedures, and data validation.
• Python development experience for ETL automation, scripting, data processing, and workflow support.
• Solid understanding of data warehousing concepts, dimensional modeling, data marts, data lakes, metadata management, and data lineage.
• Experience building and supporting production-grade ETL/ELT pipelines in cloud data environments.
• Ability to troubleshoot data issues, pipeline failures, performance bottlenecks, and production defects.
• Ability to work onsite in San Antonio, Texas 4–5 days per week for the duration of the contract.

Preferred Qualifications

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Familiarity with CI/CD tools and version control practices, including Git-based deployment workflows.
• Experience with orchestration or scheduling tools such as Airflow, Control-M, Dagster, or similar platforms.
• Exposure to enterprise data governance, data quality, security, and compliance practices.
• Experience working in Agile/Scrum environments with tools such as Jira and ServiceNow.
• Prior experience supporting large-scale data warehouse migrations or modernization initiatives.