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:
Google BigQuery and Google Cloud Data Fusion experience
Google Cloud Professional Data Engineer Certification
Tableau experience
Power BI experience
Epic Clarity/Caboodle certification
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.
Mayo Clinic has expanded and changed in many ways, but our values remain true to the vision of our founders. Our primary value – The needs of the patient come first – guides our plans and decisions as we create the future of health care. Join us and you'll find a culture of teamwork, professionalism and mutual respect, and most importantly, a life-changing career.
Mayo Clinic was founded in Rochester, Minnesota by brothers Dr. William James Mayo and Dr. Charles Horace Mayo. More than 100 years later, their vision continues to evolve around a single guiding value: "The needs of the patient come first." Today we are the largest integrated, not for-profit medical group practice in the world.
We are recognized for high-quality patient care more than any other academic medical center in the nation. These endorsements are very gratifying, but also humbling. They remind us of the tradition that has been entrusted to each one of us, and the legacy of excellence that we uphold every day.
