ETL/Data Warehouse Consultant

ETL/Data Warehouse Consultant Location: San Antonio, Texas — Onsite 4–5 days per week 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.