Data Analytics Engineer III

Role Description

The Data Analytics Engineer 3 is responsible for designing and creating tables within data marts, data lakes, and data warehouses, along with all related extraction, transformation, and load of data functions. The role involves:

• Building systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts.
• Making data accessible for organizations to evaluate and optimize their performance.
• Developing and testing architectures for data extraction and transformation for predictive or prescriptive modeling.
• Expanding and optimizing data and data pipeline architecture.
• Optimizing data flow and collection for cross-functional teams.
• Taking direction from lead data engineers and department leadership to enhance self and team capabilities around data and analytic competencies.
• Mentoring junior data engineers and promoting data education across the organization.

Qualifications

• Required Bachelor's Degree in Business, Computer Science, Engineering, Information Systems, Public Health, or related field.
• Preferred Master's Degree in Computer Science, Business, Healthcare Management, Information Systems, or related field.
• 5 years of experience building data pipelines using ETL technologies such as SSIS or Informatica.
• 3 years of SQL development with SQL Server/Oracle environment (Required).
• 2 years of experience with cloud data platforms and associated tools such as MS Azure, AWS, or GCP (Required).

Requirements

• Deep understanding of modern data architectures, including lakehouse design patterns and scalable data processing approaches.
• Hands-on experience with Azure data platforms, including ADLS, Azure Data Factory (ADF), Databricks, and related lakehouse technologies.
• Strong experience designing and implementing metadata-driven, scalable data pipelines.
• Proficiency in Python and PySpark for building data pipelines, transformations, and distributed processing workloads.
• Experience integrating data across systems using APIs and other modern data connectivity patterns.
• Proficiency with DevOps and DataOps practices, including CI/CD for data pipelines and cloud infrastructure.
• Advanced SQL skills with experience managing and optimizing relational data platforms.
• Familiarity with Microsoft Fabric is a plus.
• Experience with healthcare data platforms such as Epic Cogito is a plus.

Benefits

• Comprehensive benefit offerings for eligible employees.

Company Description

With 11 ministries and access points across Indiana, Franciscan Health is one of the largest Catholic health care systems in the Midwest. Franciscan Health takes pride in hiring coworkers that provide compassionate, comprehensive care for our patients and the communities we serve.