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

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