Senior Data Engineer - Pharmacy

Why Mayo Clinic

Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and  comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic.

Benefits Highlights

• 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.

Responsibilities

Develops and deploys data pipelines, integrations and transformations to support analytics and machine learning applications and solutions as part of an assigned product team using various open-source programming languages and vended software to meet the desired design functionality for products and programs. The position requires maintaining an understanding of the organization's current solutions, coding languages, tools, and regularly requires the application of independent judgment. May provide consultative services to departments/divisions and leadership committees. Demonstrated experience in designing, building, and installing data systems and how they are applied to the Department of Data & Analytics technology framework is required. Candidate will partner with product owners and Analytics and Machine Learning delivery teams to identify and retrieve data, conduct exploratory analysis, pipeline and transform data to help identify and visualize trends, build and validate analytical models, and translate qualitative and quantitative assessments into actionable insights.

This open position is on the Pharmacy Informatics Reporting Team. The team is responsible for medication-related reporting in Epic (e.g. SlicerDicer, dashboards, metrics, reporting workbench reports, Caboodle, Clarity), as well as 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. 

The selected candidate will play a significant role in medication management analytics initiatives through the development of complex SQL-based reporting solutions delivered via Power BI and/or Tableau dashboards. The design and maintenance of medication-related data architectures within Microsoft Fabric and Google BigQuery (Google Cloud Data Fusion) will be a significant role of the Senior Data Engineer. 

Strong candidates will have a demonstrated history of developing SQL-based reporting and analytics solutions across a variety of healthcare-related systems and strong technical expertise and know-how. Candidates should possess a passion for improving patient care and operational effectiveness, along with a strong technical mindset evidenced by a track record of delivering data-driven solutions to solve complex clinical and/or operational challenges.

This position is a hybrid role, and the candidate must live within 100 miles of any Mayo Clinic site in Minnesota, Wisconsin, Florida, or Arizona. On-site days will be purpose-driven and may include activities such as collaboration with colleagues, practice shadowing, and workflow observation. On-site requirements are estimated to average to approximately two days per quarter. 

Qualifications

A Bachelor's degree in a relevant field such as engineering, mathematics, computer science, information technology, health science, or other analytical/quantitative field and a minimum of five years of professional or research experience in data visualization, data engineering, analytical modeling techniques; 

OR an Associate’s degree in a relevant field such as engineering, mathematics, computer science, information technology, health science, or other analytical/quantitative field AND a minimum of seven years of professional or research experience in data visualization, data engineering, analytical modeling techniques. In-depth business or practice knowledge will also be considered.

Position requirements : 

1. Advanced SQL experience 
2. Prior experience working with healthcare data 
3. Experience developing and deploying data pipelines from various sources including databases, APIs, and file systems 
4. Experience leveraging cloud-based tools in Google Cloud or Microsoft Fabric 
5. Programming experience (e.g. Python, JavaScript, PHP, C++ or Java & API integration) 
6. Excellent communication skills 
7. Commitment to ongoing skill development and continuous learning

Preferred:

Google BigQuery and Google Cloud Data Fusion experience 

Google Cloud Professional Data Engineer Certification 

Tableau experience 

Power BI experience 

Epic Clarity/Caboodle certification 

Exemption Status

Exempt

Compensation Detail

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

Benefits Eligible

Yes

Schedule

Full Time

Hours/Pay Period

80

Schedule Details

8 AM - 5 PM Monday through Friday with 1-week of on call phone coverage approximately 1-2 weeks per year.

Weekend Schedule

N/A

International Assignment

No

Site Description

Just as our reputation has spread beyond our Minnesota roots, so have our locations. Today, our employees are located at our three major campuses in Phoenix/Scottsdale, Arizona, Jacksonville, Florida, Rochester, Minnesota, and at Mayo Clinic Health System campuses throughout Midwestern communities, and at our international locations. Each Mayo Clinic location is a special place where our employees thrive in both their work and personal lives.  Learn more about what each unique Mayo Clinic campus has to offer, and where your best fit is.

Equal Opportunity

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, protected veteran status or disability status. Learn more about the "EOE is the Law" .  Mayo Clinic participates in  E-Verify and may provide the Social Security Administration and, if necessary, the Department of Homeland Security with information from each new employee's Form I-9 to confirm work authorization.

Recruiter

Gloria Yarwood