Pacific Medical Centers is seeking a Data Engineer I to design and develop data-centric applications that support clinical and operational workflows across their healthcare system. The role involves building scalable data pipelines and mentoring junior engineers while ensuring the reliability and security 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