We are seeking a Business Intelligence Analyst to assist us with developing and managing a large electronic health record data repository of data on patients with ocular diseases. This analyst will help tap into Clarity to extract relevant clinical variables from the EPIC electronic health record, clean and organize the data in a format to facilitate analysis of the data. The Business Intelligence Analyst will also assist with linking data from the repository to other internal and external data sources including working with IT staff at other academic institutions to facilitate data extraction from their Clarity databases to incorporate such data into the repository. The business intelligence analyst will spend most of his or her time working with clinicians and biostatisticians in the Department of Ophthalmology and Visual Sciences but will also spend a little time working with other Business Intelligence Analysts and IT staff at the university on projects outside of ophthalmology.
Why Join Michigan Medicine?
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world’s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.
What Benefits can you Look Forward to?
- Excellent medical, dental and vision coverage effective on your very first day
- Retirement Savings Opportunities
Design and development of complex database queries for researchers
Join data from various systems, disparate databases into a cohesive set for analytics
Maintain documentation of decisions made during the build of SQL queries
Adhere to data quality processes to ensure product is valid and reproducible
Work with a team of diverse, motivated individuals toward a shared mission
Strong analytical, time-management, problem-solving and decision making abilities
Experience with translating information requirements into SQL code
Ability to manage multiple competing priorities with competing data needs
Candidate must be committed to data security and the protection of sensitive information with demonstrated knowledge of applicable data use and sharing safeguards
Proactive and creative techniques in solving researchers’ problems
Positive attitude, ability to work well with others and independently
3-5 years' of professional experience.
Comfort translating code for SQL servers to Oracle servers and vice versa
Proficiency using Python
BA/BS in Computer Science or equivalent experience with formal SAP training and certifications preferred
Proficiency certification with EPIC training
5-10 years experience directly related to the responsibilities specified
Knowledge of Tableau, SAS, R, a plus
Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
U-M EEO/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.