Covenant Health is seeking a Data Engineer I who is responsible for designing and developing data-centric applications that support clinical and operational workflows across the healthcare system. The role involves building scalable data pipelines and working closely with various teams to ensure the reliability and efficiency of the enterprise data platform.
Responsibilities:
- Automation and monitoring batch/streaming ELT/ETL pipelines across cloud services and Snowflake; keep data fresh and accurate
- Triaging failures, performing root-cause analyses and post-mortems, and continuously reducing MTTR
- Orchestrating schedules and dependencies (e.g., Ctrl-M) and managing connectors (in Fivetran/HVR)
- Building operational automation with SQL, Python, and shell (Bash/PowerShell) on Linux
- Implementing observability: logging, alerting, data-quality checks, audits, and runbooks
- Optimizing Snowflake performance and spend (warehouses, caching)
- Enforcing access controls and secrets management, supporting compliance and audit needs
- Partnering with product/analytics teams; documenting procedures and providing reliable on-call support (rotational)
Requirements:
- Bachelor's in CS/Engineering or equivalent experience; senior-level hands-on ownership of production data operations
- 1 or more year of related experience in Snowflake, CTRL-M, and ADF
- Strong SQL, plus hands-on Python and shell scripting (Bash/PowerShell) on Linux
- Experience with cloud computing and data warehousing on relational platforms
- Solid understanding of OLAP/dimensional modeling and RDBMS fundamentals
- Knowledge of semi/unstructured data (JSON/Parquet) and API integrations
- Familiarity with open-source ELT/ETL tooling
- Git-based workflows and CI/CD basics for data deployments
- Experience building and managing data ingestion pipelines from multiple sources into cloud data platforms
- Working knowledge of Snowflake, including database objects, warehouses, and basic query optimization
- Master's degree in computer engineering, Computer Science, Mathematics, Engineering, or an equivalent combination of education and experience
- Snowflake administration experience (account management, RBAC, resource monitors, storage/warehouse configuration, network policies)
- Fivetran and/or HVR (Fivetran HVR) experience or equivalent CDC/replication tools
- Snowflake operations expertise (performance tuning, Streams/Tasks, Snowpark), plus knowledge of Snowflake AI features
- Streamlit for lightweight internal apps and operational dashboards
- Experience with enterprise schedulers (e.g., Ctrl-M) and data-quality/observability platforms
- Background in regulated environments (e.g., healthcare/HIPAA) and service management (e.g., ServiceNow)