Role Summary
Build and support production-grade cloud data pipelines and data products. This is a hands-on role focused on Snowflake
and AWS engineering, with responsibility for reliable delivery from source onboarding through production support.
Key Responsibilities
Design and build scalable ingestion and transformation pipelines across Snowflake Bronze, Silver, and Gold layers.
Develop modular dbt models, advanced SQL transformations, and Airflow workflows.
Build AWS-based integrations using files, APIs, events, and cloud storage patterns.
Perform source profiling, source-to-target mapping, cleansing, standardization, reconciliation, and data validation.
Implement automated unit, integration, regression, and data quality tests using frameworks such as SODA.
Support CI/CD, production deployments, monitoring, troubleshooting, performance tuning, documentation, and
hypercare.
Collaborate closely with architects, product teams, data stewards, and distributed engineering teams.
Required Skills and Experience
Strong hands-on Snowflake skills, including advanced SQL, data modeling, performance tuning, and secure data
access.
Strong hands-on AWS data engineering skills.
8+ years in data engineering, ETL/ELT, or cloud data-platform development.
Production experience with dbt and Airflow.
Experience with SnapLogic or similar integration tools, Kafka, REST APIs, Git, and CI/CD.
Experience implementing data quality frameworks such as SODA, automated testing, reconciliation, and
observability.
Ability to troubleshoot production pipelines and work effectively across onsite and offshore teams.
Ability to work onsite in Dallas three days per week.
