IT Product Engineer

Overview

Inspired by faith. Driven by innovation. Powered by humankindness. CommonSpirit Health is building a healthier future for all through its integrated health services. As one of the nation's largest nonprofit Catholic healthcare organizations, CommonSpirit Health delivers more than 20 million patient encounters annually through more than 2,300 clinics, care sites and 137 hospital-based locations, in addition to its home-based services and virtual care offerings. CommonSpirit has more than 157,000 employees, 45,000 nurses and 25,000 physicians and advanced practice providers across 24 states and contributes more than $4.2 billion annually in charity care, community benefits and unreimbursed government programs. Together with our patients, physicians, partners, and communities, we are creating a more just, equitable, and innovative healthcare delivery system.

Responsibilities

This is a remote position.

About the Enterprise Business Intelligence Team

The Enterprise Data & Analytics team is responsible for building and maintaining the robust and scalable data infrastructure that empowers CommonSpirit Health to deliver exceptional patient care, improve operational efficiency, and drive data-driven decision-making. We are a team of passionate data professionals dedicated to delivering high-quality, secure, and reliable data products. We are committed to leveraging cutting-edge technologies, particularly Google Cloud Platform (Google Cloud Platform), to build a world-class, automated data foundation. We adhere to strict HIPAA compliance standards.
Job Summary

The Product Engineer Role is a critical contributor to the design, development, optimization,automation, and maintenance of our core data platform and analytical solutions, with a strong focus on leveraging Google Cloud Platform services for business operations. The Product Engineer will work closely with data analysts, clinicians, and other engineers to understand their data needs and translate them into robust, scalable, performant, and automated data pipelines and infrastructure. The Product Engineer will be responsible for ensuring the reliability, performance, security, data quality, and HIPAA compliance of our data infrastructure. This role is heavily focused on data engineering and infrastructure development, with a strong emphasis on data flow orchestration and automation, hands-on development of ETL processes using Python and SQL and visual dashboard development in Google Cloud Platform environments.
Job Responsibilities

• Data Pipeline Design, Development, and Automation
• Design, develop, test, deploy, and automate highly scalable and reliable data pipelines and ETL/ELT processes using Google Cloud Platform services such as Dataflow, BigQuery, Cloud Functions, Cloud Composer, and Cloud Storage.
• Implement data ingestion, transformation, and loading strategies for various data sources, including clinical systems, operational databases, and external data feeds.
• Optimize data pipelines for performance, scalability, cost-effectiveness, and automated execution.
• Implement robust error handling and monitoring mechanisms to ensure data quality and pipeline stability.
• Design, develop, and maintain complex DAGs (Directed Acyclic Graphs) in Apache Airflow (or Cloud Composer) to orchestrate data pipelines and workflows.
• Implement automated testing and deployment strategies for Airflow DAGs.
• Develop and maintain ETL processes using Python and SQL to transform and load data into BigQuery and other data stores.
• Implement data quality checks and validation rules within data pipelines to ensure data accuracy and completeness.
• Lead two or three data engineers on-shore or off-shore

Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 2+ years of experience in data engineering or a related role, with a strong focus on building, maintaining, and automating data pipelines and infrastructure, and ensuring data quality for operational executive reporting.
• Hands on experience with financial, people and related operational data in Healthcare provider systems.
• Strong proficiency in SQL and experience with relational databases (e.g. MySQL, BiqQuery).
• Hands-on experience with Google Cloud Platform (Google Cloud Platform) services such as BigQuery, DAGs, Dataflow, Cloud Functions, Cloud Composer, and Cloud Storage
• Proficiency in Python and SQL for developing ETL processes.
• Experience with data pipeline development and ETL/ELT processes in Google Cloud Platform platform.
• Experience with version control systems (e.g. Git) and AppDev tools such as ADO.
• Proven experience designing, developing, and deploying complex DAGs in Apache

Airflow (or Cloud Composer).

• Experience with automating data pipelines and infrastructure using scripting and orchestration tools
• Experience with Qlik and Tableau for development of customer focused dashboards
• Experience with data modeling and schema design.
• Strong problem-solving and analytical skills, specifically related to data engineering challenges, automation, and data quality.
• Excellent communication and collaboration skills.
• Experience working with Protected Health Information (PHI)..
• Experience with data profiling and data quality assessment techniques.
• Experience with data governance principles and practices.
• Strong attention to detail.

• Ability to work independently and as part of a team.
• Ability to manage multiple projects simultaneously.
• Strong organizational skills and time management skills.
• Understanding of HIPAA regulations and data privacy policies.

#LI-Remote

#LI-CSH