Data Analytics Engineer

Franciscan Health seeks a Data Analytics Engineer to design and assemble data structures within data marts, data lakes, and data warehouses, while administering ETL processes to deliver analytics-ready data to stakeholders. The role includes mentoring peers and fostering a data driven culture across clinical and operational teams. This position is based in Mishawaka, Indiana with remote work options.

Responsibilities

• Design and build tables across data marts, data lakes, and data warehouses, handling all related extraction, transformation, and loading tasks
• Collaborate across diverse environments to develop systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts
• Aim to make data readily accessible to support performance evaluation and optimization efforts
• Develop and validate architectures that enable data extraction and transformation for predictive and prescriptive modeling
• Expand and optimize data and data pipeline architectures, improving data flow for cross functional teams
• Take direction from lead data engineers and department leaders to advance the team’s data and analytics capabilities
• Mentor junior data engineers and guide users across the organization to promote data literacy and a data driven culture in clinical and business operations
• Consult with data and analytics experts to enhance system functionality and coordinate with data systems management to align with broader needs
• Under leadership guidance, design, implement, and continuously expand data pipelines, perform ETL activities, and maintain optimal pipeline architecture
• Assemble large, complex data sets that meet functional and non-functional requirements, while identifying opportunities for process improvements
• Gather requirements and business process knowledge to transform data in ways that serve end users
• Present data storage options including lakes, marts, and warehouses based on storage needs
• Ensure the data architecture remains scalable and maintainable
• Investigate data for potential ETL issues, notify end users, and propose effective solutions
• Conduct preliminary testing of warehousing and database environments prior to data extraction
• Extract data and migrate it to warehousing environments, other databases, or files
• Test the system after data migration to verify integrity and performance
• Provide ongoing maintenance and support, maintain documentation and code comments, and perform additional 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

Qualifications

• Bachelor's Degree
• Minimum 2 years of related experience

Travel

Travel is rarely required for this role.

Compensation

Annual salary range: USD 82,932 to 114,031.