Mayo Clinic is seeking a Senior Data Engineer to help build and run data pipelines, integrations, and transformations that power analytics and machine learning. In this hybrid role in Rochester, MN, you will contribute to medication management reporting and analytics while designing and maintaining medication-related data architectures across Microsoft Fabric and Google BigQuery.

Working as part of an assigned product team, you will develop SQL-based reporting solutions delivered via Power BI and/or Tableau dashboards, and partner with product owners and analytics and machine learning delivery teams to retrieve data, explore it, and identify trends through robust pipelines.

Responsibilities

Develop and deploy data pipelines, integrations, and transformations to support analytics and machine learning applications using open-source programming languages and vended software.
Maintain current knowledge of the organization’s solutions, coding languages, and tools, using independent judgment to support delivery.
Provide consultative services to departments, divisions, and leadership committees.
Design, build, and implement data systems and their application within the Department of Data & Analytics technology framework.
Partner with product owners and Analytics and Machine Learning delivery teams to identify, retrieve, and explore data; then pipeline and transform it to surface 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 dashboards.
Design and maintain medication-related data architectures in Microsoft Fabric and Google BigQuery (via Google Cloud Data Fusion).
Support the Pharmacy Informatics Reporting Team, including medication-related reporting in Epic (such as SlicerDicer, dashboards, metrics, reporting workbench reports, Caboodle, and Clarity), and analytics/reporting 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 (for example: Python, JavaScript, PHP, C++, or Java and API integration).
Excellent communication skills.
Commitment to ongoing skill development and continuous learning.
Bachelor’s degree in a relevant field (or Associate’s degree with additional experience) paired with minimum experience requirements related to data visualization, data engineering, and analytical modeling techniques.
In-depth business or practice knowledge will also be considered.

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

Preferred

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

Compensation & Benefits

Salary: USD 137,134 - 205,691 per year (education, experience, and tenure may be considered with internal equity).
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
Benefits eligible: Yes

Work Model, Schedule, and Status

Location: Rochester, MN (hybrid)
Hybrid requirements: Candidate must live within 100 miles of any Mayo Clinic site in Minnesota, Wisconsin, Florida, or Arizona.
On-site frequency: Purpose-driven on-site days; estimated average of approximately two days per quarter.
Schedule: Full Time (8 AM - 5 PM, Monday through Friday), with 1-week of on-call phone coverage approximately 1-2 weeks per year.
Exemption status: Exempt
Hours/Pay period: 80
Weekend schedule: N/A
International assignment: No

Senior Data Engineer