Data Pipeline Architect for Snowflake & dbt

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

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.