remote
IT Data Engineer III - Consumer Direct Care Network
Data Engineer
Senior Data Engineer responsible for designing, building, and maintaining scalable data pipelines and warehouses on AWS, leveraging Python, SQL, Snowflake, and Airflow to support analytics and reporting for a growing care services organization.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines to ingest, transform, and load data from multiple sources into Snowflake.
- Implement and manage workflow orchestration using Apache Airflow, ensuring reliable scheduling and monitoring.
- Collaborate with data analysts, scientists, and product teams to define data models that meet reporting and analytical needs.
- Optimize SQL queries and data warehouse performance for cost‑effective, high‑throughput processing on AWS.
- Establish data quality checks, monitoring, and documentation to guarantee data integrity and compliance.
Requirements
- 5+ years of hands‑on experience building data pipelines and warehouses, preferably in a cloud environment (AWS).
- Proficiency in Python for data manipulation and automation.
- Strong SQL skills and experience with Snowflake or comparable cloud data platforms.
- Experience with workflow orchestration tools such as Apache Airflow.
- Solid understanding of data modeling, ETL best practices, and data governance principles.
Skills
pythonsqlawssnowflakeairflow