Senior Data Engineer Pharmacy

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

A Bachelors 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 Associates 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 -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