Senior Data Engineer

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.