Senior Data Engineer

Join Mayo Clinic to build and deploy data pipelines and reporting solutions that support analytics and machine learning, with a focus on medication management reporting.

Responsibilities

• Develop, deploy, and maintain data pipelines, integrations, and transformations for analytics and machine learning within an assigned product team
• Apply independent judgment to support current solutions, coding languages, and tooling used across the organization
• Provide consultative support to departments/divisions and leadership committees
• Design, build, and install data systems aligned to the Department of Data & Analytics technology framework
• Partner with product owners and Analytics and Machine Learning delivery teams to identify and retrieve data
• Conduct exploratory analysis and support pipeline and data transformation work to help identify and visualize trends
• Build and validate analytical models and translate qualitative and quantitative assessments into actionable insights
• Create complex SQL-based reporting solutions delivered through Power BI and/or Tableau
• Design and maintain medication-related data architectures in Microsoft Fabric and Google BigQuery (including Google Cloud Data Fusion)
• Support medication-related reporting on the Pharmacy Informatics Reporting Team for Epic (e.g., SlicerDicer, dashboards, metrics, reporting workbench reports, Caboodle, Clarity)
• Support reporting and analytics for ancillary systems including BD Pyxis, BD logistics, BD CII safe systems, pharmacy purchasing data, operating room medication systems, retail pharmacy systems, inpatient automation technologies, and other medication management technologies

Requirements

• Advanced SQL experience
• Prior experience working with healthcare data
• Experience developing and deploying data pipelines from multiple sources including databases, APIs, and file systems
• Experience leveraging cloud-based tools in Google Cloud or Microsoft Fabric
• Programming experience (examples provided: Python, JavaScript, PHP, C++, Java, including API integration)
• Excellent communication skills
• Commitment to ongoing skill development and continuous learning
• Education and experience:
  • Bachelor's degree in a relevant field AND minimum 5 years professional or research experience in data visualization, data engineering, and analytical modeling techniques
  • OR Associate's degree in a relevant field AND minimum 7 years professional or research experience in data visualization, data engineering, and analytical modeling techniques
• In-depth business or practice knowledge will also be considered

Preferred

• Google BigQuery and Google Cloud Data Fusion experience
• Google Cloud Professional Data Engineer Certification
• Tableau experience
• Power BI experience
• Epic Clarity/Caboodle certification

Technologies

• SQL, Power BI, Tableau, Microsoft Fabric, Google BigQuery, Google Cloud Data Fusion
• Python, JavaScript, PHP, C++, Java
• Epic, SlicerDicer, Caboodle, Clarity
• BD Pyxis, BD logistics, BD CII safe systems

Benefits

• Medical: multiple plan options
• Dental: Delta Dental or reimbursement account for flexible coverage
• Vision: affordable plan with national network
• Pre-Tax Savings: HSA and FSAs for eligible expenses
• Retirement: competitive retirement package

Location and Work Model

• Rochester, MN (hybrid)
• Hybrid requirements: candidate must live within 100 miles of any Mayo Clinic site in Minnesota, Wisconsin, Florida, or Arizona
• On-site days are purpose-driven and may include collaboration, practice shadowing, and workflow observation
• Estimated on-site frequency: approximately two days per quarter

Schedule and Status

• Full Time
• Hours/Pay period: 80
• Schedule: 8 AM - 5 PM, Monday through Friday
• On-call: 1-week phone coverage approximately 1-2 weeks per year
• Exempt position
• Weekend schedule: N/A

Compensation

• $137,134 - $205,691 per year
• Education, experience, and tenure may be considered along with internal equity when offers are extended