Data Analytics Engineer

Franciscan Health is seeking a Data Analytics Engineer to design and implement data structures across data marts, data lakes, and data warehouses, while stewarding the ETL processes that make data accessible for analytics teams and business users. In this role, you will mentor peers and foster a data-driven culture across clinical and operational teams, contributing to a scalable analytics foundation from Mishawaka, Indiana with remote work options. The position offers a salary range aligned with a bachelor’s degree and a couple of years of hands-on experience in the field.

Responsibilities

• Design and build tables within data marts, data lakes, and data warehouses, handling all related extraction, transformation, and load tasks.
• Develop systems in diverse settings to collect, manage, and convert raw data into information usable by analytics developers and business analysts.
• Make data accessible to support performance evaluation and optimization across the organization.
• Design and test architectures that enable extraction and transformation for predictive or prescriptive modeling.
• Expand and optimize data and data pipeline architecture, improving data flow and collection for cross-functional teams.
• Take direction from lead data engineers and leadership to enhance the team’s data and analytic capabilities.
• Mentor junior data engineers and guide users to promote data education and a data-driven culture in clinical and business operations.
• Collaborate with data and analytics experts to improve data systems, and consult with data systems management to align with broader data needs.
• Under leadership guidance, design, implement, and continuously expand data pipelines, performing ETL activities and maintaining optimal pipeline architecture.
• Assemble large, complex data sets to meet functional and non-functional requirements, while pursuing internal process improvements such as automation and scalable infrastructure redesigns.
• Gather requirements and business process knowledge to transform data in ways that serve end users.
• Present data storage options (lakes, marts, warehousing) based on storage needs and scalability considerations.
• Ensure the data architecture remains scalable and maintainable over time.
• Identify potential issues within ETL pipelines, notify end-users, and propose solutions.
• Conduct preliminary testing of warehousing and database environments prior to data extraction.
• Extract data and transfer it into the warehousing environment, other databases, or files.
• Test the new system after data transfer to validate integrity and performance.
• Provide ongoing maintenance and support, maintain documentation and code comments, and perform other duties as assigned.

Technologies

• Azure Data Factory (ADF)
• Azure Data Lake Storage (ADLS)
• Databricks
• Python, PySpark
• SQL, SQL Server, Oracle
• Microsoft Fabric, SSIS, Informatica
• AWS, GCP
• Epic Cogito

Travel

Travel rarely required.

Qualifications

• Bachelor's Degree
• Minimum 2 years of related experience in data analytics or data engineering

Compensation

Salary range: USD 82,932 - 114,031 per year.