What are the responsibilities and job description for the BI Analyst Lead position at Michigan Medicine?
How to Apply
A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.
Job Summary
The Department of Pediatrics Health Metrics and Learning Health Systems Program is seeking a skilled and motivated Data Visualization and Business Intelligence Analyst Lead to join a team that is passionate about using data-driven insights to improve the health and well-being of children. This individual gathers, analyzes and interprets data from a variety of administrative and clinical databases to contribute to operational, clinical care, quality improvement, and research initiatives for the Department of Pediatrics. The analyst will have expertise in the creation of data sources and data dashboards to support faculty-led initiatives focused on clinical transformation, quality improvement, and measurement of pediatric health outcomes, as well as Departmental enterprise reporting of finances, faculty productivity, and other KPIs to the Departmental Administrator and Chair. This position will report to Dr. Joyce Lee, Associate Chair for Health Metrics and Learning Health Systems for the Department of Pediatrics.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
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?
Database Management and Reporting
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
Background Screening
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.
Application Deadline
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 Statement
The University of Michigan is an equal employment opportunity employer.
A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.
Job Summary
The Department of Pediatrics Health Metrics and Learning Health Systems Program is seeking a skilled and motivated Data Visualization and Business Intelligence Analyst Lead to join a team that is passionate about using data-driven insights to improve the health and well-being of children. This individual gathers, analyzes and interprets data from a variety of administrative and clinical databases to contribute to operational, clinical care, quality improvement, and research initiatives for the Department of Pediatrics. The analyst will have expertise in the creation of data sources and data dashboards to support faculty-led initiatives focused on clinical transformation, quality improvement, and measurement of pediatric health outcomes, as well as Departmental enterprise reporting of finances, faculty productivity, and other KPIs to the Departmental Administrator and Chair. This position will report to Dr. Joyce Lee, Associate Chair for Health Metrics and Learning Health Systems for the Department of Pediatrics.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
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
- 2:1 Match on retirement savings
Database Management and Reporting
- Collaborate with healthcare business stakeholders (physicians, administrators, project managers, staff) and manage cross functional unit projects across all project stages to understand their data needs and translate them into effective visualizations and dashboards to increase organizational value
- Create and maintain enterprise-level data sources, Tableau dashboards and workbooks that are user-friendly, visually appealing, and that effectively communicate complex data insights and support the translation these insights into clear, actionable recommendations for business stakeholders
- Connect to various enterprise data sources, including databases, spreadsheets, and cloud platforms, to extract and transform data for the purposes of database creation, analysis, visualization, and action
- Ensure optimal dashboard performance and user experience and apply best practices in data visualization and dashboard design to ensure clarity, accuracy, and accessibility
- Perform data quality checks and validation to ensure the integrity of data used in visualizations
- Ensure proper handling of data and data governance with all data sources
- Create and maintain comprehensive documentation of measurement methods and algorithms, data sources, and reporting processes
- Work collaboratively to support physician and staff training of Tableau and data analysis best practices
- Utilize R and Python to enhance data analysis and visualization capabilities, including data cleaning, statistical modeling, and predictive analytics
- Collaborate on novel opportunities to develop and implement predictive models and machine learning algorithms to improve patient outcomes and optimize healthcare delivery
- Bachelor's Degree (quantitative field like biostatistics, public health, computer science, economics, engineering, informatics) with an advanced degree preferred
- 8 years of experience with data loading, extraction, analysis, and reporting
- Exceptional SQL skills, including the ability to write complex, optimized queries
- Strong understanding of data modeling and dimensional design principles
- Experience in Tableau dashboard design and data visualization best practices, including the ability to create and maintain interactive dashboards, data flows and Tableau server/online administration
- Excellent problem-solving and critical thinking abilities including the ability to lead change management processes to improve BI tools and resources
- Experience with version control and documentation practices
- Ability to gain certification in querying analytic EHR databases (Clarity, Caboodle) through training
- Experience with Data Warehouse and BI systems
- Master's Degree (biostatistics, public health, computer science, economics, engineering, informatics)
- Tableau Desktop Certified Professional certification
- Clarity Certification
- Experience with Python or R for advanced data manipulation and analysis
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
Background Screening
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.
Application Deadline
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 Statement
The University of Michigan is an equal employment opportunity employer.
