Data Engineer II - IT AI and Data Technology

St. Peter's Health; Montana; On-site; USD 90,000 - 120,000; Full time

Job summary

St. Peter’s Health is seeking a Data Engineer II to design, develop, and maintain secure data pipelines and enterprise data solutions that support analytics, reporting, and informed decision-making.

You will transform data from Epic and other systems into governed, reusable assets, collaborating with analytics, IT, vendors, and business stakeholders. Strong SQL, Snowflake, healthcare data knowledge, and data governance are essential to success in this role.

Qualifications

• Four or more years of relevant data engineering or analytics experience.
• Strong SQL and relational database knowledge.
• Experience designing and supporting data extracts, transformations, and pipelines.
• Knowledge of data modeling, quality, integration, orchestration, monitoring, and support.
• Ability to document data mappings, business rules, and runbooks clearly.
• Excellent analytical, written, verbal, and stakeholder engagement skills.

Skills

SQL

Data engineering

Data modeling

Data integration

Orchestration

Monitoring

Data quality

Runbooks

Education

Bachelor's degree in CS/IS/Analytics

Master's degree preferred

Tools

Snowflake

Epic Cogito

Epic Clarity

Epic Caboodle

Git

Azure DevOps

APIs

SFTP

Python

dbt

AWS Glue

Azure Data Factory

Job description

Job Description

St. Peter’s Health is seeking a Data Engineer II to design, develop, and maintain secure, reliable data pipelines, integrations, data models, and enterprise data solutions that support analytics, reporting, and informed decision-making. This role collaborates with analytics, IT, vendors, and business stakeholders to transform data from Epic and other systems into trusted, governed, and reusable solutions. The ideal candidate brings strong SQL and data engineering skills, experience with Snowflake or comparable platforms, and knowledge of healthcare data, Epic systems, DataOps, and data governance. Success in this role requires strong analytical and problem-solving skills, attention to accuracy and security, and the ability to work independently and collaboratively.

KNOWLEDGE/EXPERIENCE:

Required:

• Four or more years of relevant experience in data engineering, data analytics, database development, business intelligence, or related information technology work; or an equivalent combination of education and experience.
• Strong working knowledge of SQL and relational database concepts.
• Experience independently designing and supporting data extracts, data transformations, data validation, reporting datasets, analytical data assets, and production data pipelines.
• Working knowledge of data modeling, data quality, data integration, orchestration, monitoring, and production support concepts.
• Demonstrated ability to document technical work clearly, including data mappings, business rules, process steps, runbooks, and support procedures.
• Demonstrated analytical, written, verbal, customer service, and stakeholder engagement skills.

Preferred:

• Healthcare provider, payer, health system, or healthcare analytics experience.
• Experience with Epic, Clarity, Caboodle, Cogito, or a comparable EHR system.
• Experience with Snowflake or a comparable cloud data platform; BI tools; ETL/ELT or orchestration tools.
• Experience with Git, Azure DevOps, APIs, SFTP, or file-based data exchange patterns.
• Experience with Python, dbt, AWS Glue, Azure Data Factory, or similar data engineering tools.
• Familiarity with HIPAA, HITECH, healthcare data privacy, information security practices, and responsible use of AI-enabled productivity tools.

EDUCATION:

Bachelor’s degree in Computer Science, Computer Information Systems, Data Analytics, Health Informatics, Engineering, Mathematics, Statistics, Business Analytics, or a related field is preferred. In the absence of a bachelor’s degree, an associate degree or relevant advanced certifications in a related field with six or more years of relevant experience may be accepted.

A master’s degree in a related field is preferred and may substitute for a portion of required experience. Equivalent combinations of education, certification, and directly relevant experience may be considered.

LICENSE/CERTIFICATION/REGISTRY:

No license required. Preferred certifications include Snowflake, Epic Cogito / Clarity / Caboodle, Microsoft Azure, AWS, SQL, data engineering, data analytics, cloud data platform, information security, or healthcare analytics credentials.