Senior Data Engineer

Mayo Clinic is offering a hybrid Senior Data Engineer role in Rochester, MN, with a focus on building reliable data pipelines, integrations, and transformations that enable analytics and machine learning. This position supports medication management reporting and analytics, while helping shape medication-related data architectures using Microsoft Fabric and Google BigQuery.

As a member of an assigned product team, you will design and deploy data solutions using SQL-based reporting and modern cloud data platforms, then partner with product owners and Analytics and Machine Learning delivery teams to explore data, uncover trends, and deliver actionable insights through tools like Power BI and Tableau.

What you’ll do

• Develop and deploy data pipelines, integrations, and transformations to support analytics and machine learning solutions using open-source languages and vended software.
• Maintain awareness of current solutions, coding languages, and tools, applying independent judgment to support delivery.
• Provide consultative support to departments/divisions and leadership committees.
• Design, build, and install data systems aligned to the Department of Data & Analytics technology framework.
• Collaborate with delivery teams to identify and retrieve data, run exploratory analysis, and transform datasets to help visualize trends.
• Build and validate analytical models, translating qualitative and quantitative assessments into insights.
• Create complex SQL-based reporting solutions delivered via Power BI and/or Tableau dashboards.
• Design and maintain medication-related data architectures in Microsoft Fabric and Google BigQuery, including Google Cloud Data Fusion.
• Support medication reporting for the Pharmacy Informatics Reporting Team in Epic (including SlicerDicer, dashboards, metrics, reporting workbench reports, Caboodle, and Clarity), plus reporting and analytics for ancillary medication management systems such as BD Pyxis, BD logistics, BD CII safe systems, pharmacy purchasing data, operating room medication systems, and retail pharmacy systems.

What you’ll bring

• Advanced SQL experience.
• Prior experience working with healthcare data.
• Experience developing and deploying data pipelines from databases, APIs, and file systems.
• Experience leveraging cloud-based tools in Google Cloud or Microsoft Fabric.
• Programming experience, such as Python, JavaScript, PHP, C++, or Java with API integration.
• Excellent communication skills.
• Commitment to ongoing skill development and continuous learning.
• Education: a Bachelor’s degree in a relevant field plus minimum five years of professional or research experience in data visualization, data engineering, and analytical modeling techniques; or an Associate’s degree plus minimum seven years of experience in those areas.
• In-depth business or practice knowledge will also be considered.

Technologies you’ll work with

• 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 to secure your future.

Schedule and location

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

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

Preferred qualifications

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