Data Analytics Engineer

Role Description

The Data Analytics Engineer 3 is responsible for designing and creating tables within data marts, data lakes, and data warehouses, and all related extraction, transformation, and load of data functions. Their goal is to make data accessible so that organizations can use it to evaluate and optimize their performance. Responsibilities include:

• Building systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts.
• Developing and testing architectures that enable 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 and guidance from lead data engineers and department leadership.
• Mentoring junior data engineers and guiding users across the organization to promote data education and a data-driven culture.

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.
• 2 years of experience with cloud data platforms and associated tools such as MS Azure, AWS, or GCP.

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.