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.
Summary
The University of Michigan Medical School is seeking a qualified analyst to join the Medical School Data and Analytics team in an embedded role within our Office of Faculty Affairs. Faculty Affairs supports senior leaders in the Medical School and UM-Health across numerous high-priority and high-visibility workstreams. This position will provide important data and analytical capabilities in support of this work and will be exposed to best practices, operational challenges, and data across higher education, academic medicine, and healthcare administration. Faculty Affairs supports a broad range of domains including: faculty/physician compensation, faculty/physician productivity and key performance indicators, faculty/physician wellness, faculty life cycle and demographic analysis, and compliance with institutional, state, and federal policies and regulations. The right candidate will serve as a thought partner and will be encouraged to take an entrepreneurial approach to solving problems and supporting collective learning. The right candidate will also take a slow and methodical approach to validating data logic and will leverage institutional partners to ensure accuracy in reporting and analysis.
Faculty Affairs supports over 3,000 faculty across 29 Academic Departments and a faculty payroll of over $725 million. This position will focus on meeting the Medical School’s needs around the full complement of faculty data, in coordination with the Medical School Data and Analytics (MSDA) Team. This position will report day-to-day to the Office of Faculty Affairs, who will be responsible for setting priorities and work planning to make sure the most immediate data and information needs are met in the timeframes required. They will also be responsible for advising/advocating how faculty data should be exposed to enable reproducible results and to improve its connectedness to the greater Michigan Medicine data ecosystem. In addition, the role will support Faculty Affairs’ leadership around faculty data governance. They will be supported by MSDA with consultative and technical resources as needed, provided opportunities for professional development, and be expected to participate and potentially take the lead in groups/committees related to improving/connecting the institution's analytic ecosystem.
The direct supervisor in this role will be the UMMS Senior Manager for Analytics and Business Consulting, but as noted above, will be housed in the Office of Faculty Affairs, will attend Faculty Affairs team meetings, and will functionally be a member of the Faculty Affairs team. In this capacity, they will report day-to-day to the Faculty Compensation, Compliance, and Analytics Lead. Candidates for this position will be expected to be comfortable with leveraging various resources (documentation, SMEs, etc.) to learn the primary data environments impacting their typical operational activities, conduct current and new data analysis, create series of standard reports based on analytics, and serve as an innovator in developing new ways to analyze and present data to leadership. Candidates should be able to function independently, deliver projects in a timely and effective manner, and enjoy creating new and novel solutions.
What a Typical Day Will Look Like
As a Business Intelligence Analyst, a typical day will likely include:
A combination of managing and/or administering the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction for complex analyses, as well as doing quality assurance to validate sourced data is correct.
At times working collaboratively/proactively with the broader analytics on deliverables that require cross domain involvement.
Engaging with the University’s information technology department on data, definitions, and ETL processes.
Working in a variety of reporting and analysis tools creating and maintaining dashboard/reports and deliverables that meet active business needs, as well as exploring new ways of showing data and information to better support actionable decisions.
Interacting with your internal customers to discover what their business needs are, how data analytics can assist those needs, and presenting alternative solutions to improve the business and better support strategic goals and decisions.
Identifying the needs and implementing the solutions outlined in the prior bullet point.
Researching trends in the industry as well as best practices from other academic medical centers in order to move Michigan Medicine into a position of being the leader amongst academic medical centers.
Being the lead for answering domain related data questions and supporting the creation/updating domain specific data governance processes/documentation as needed in coordination with the data governance group.
Participating on institutional committees/groups as needed as a domain expert.
Is This Job Right for You?
This job might be right for you if…
Using data and data analytics to support business decisions and strategic goals sounds exciting.
You are skilled in identifying, analyzing, and interpreting trends or patterns in complex data sets.
You enjoy problem solving and making new discoveries.
Working in ambiguity and creating business solutions that are novel to the organization sounds stimulating.
You pay attention to details and do not let anything fall through the cracks – as far as you are concerned, anything worth doing is worth doing right, every time.
You can thrive while working in both team and individual settings.
You currently use Tableau and/or have a desire to become an expert user of the software.
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.
Responsibilities*
Reporting and Analysis: (40%)
Design report formats and graphical representations of data intended for audiences ranging from senior leaders to front line departmental staff
Deliver graphical presentations (dashboards, reports, portal interfaces) of provider, product, program, and service specific data to internal staff, faculty, UMMS leaders, relevant committees, and other constituencies
Conceptualize and develop cross-functional client/unit strategic objectives, business processes, and initiatives that drive or increase organizational value
Work with other BI Analysts, data managers and business systems analysts to plan and implement the data management and analysis of products and programs, including definition of data requirements, data capture and storage, analyses required to measure and evaluate performance, and reporting needs
Lead and guide business process improvement discussions leading to advice on potential problem resolutions including gathering the support and resources for BI initiatives
Manage cross functional unit projects and/or teams which include project planning, task management, status reporting, etc.
Data Support and Governance: (30%)
Develop and maintain supporting documentation of measurement methods and algorithms, data sources and reporting processes
Become the SME for your domain data and provide consultation/advice to the wider institution as needed as well as identifying emerging issues that need to be addressed to support improved decisions/operations
Review reports and analyses and test datasets
Extract data for reporting from departmental and enterprise sources. Administer the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction needed for reporting
Define and help create mechanisms to extract and reorganize data from existing systems for storage and reporting in departmental databases
Provide support and documentation (data/metric definitions, exceptions, common questions, etc.) to facilitate other domains use of your data to support their business needs
Participate in the development of communication related to the analysis, interpretation, and dissemination of data
Work to identify and automate tools that deliver routine performance information
Maintain on-going reporting for the dashboards and reports developed in this role and by others
Maintain communication with technical groups inside and outside of the department
Ensure adherence to quality standards and facilitate improvement efforts
Follow all appropriate data quality and security guidelines
Problem Framing and Analytics: (20%)
Apply knowledge of data analytics, measurement and analysis to the completion of complex assignments
Produce analytic results by creating and applying algorithms to data which are extracted and integrated across multiple sources
Translate business needs into analytical solutions
Validate data quality and reasonableness in reports and/or analyses prior to distribution
Communicate and collaborate with other departments to address problems with data quality
Evaluating performance to measures against results from peer institutions, external compliance requirements and internal benchmarks
Other Duties as Assigned: (10%)
Work with department and wider institution as needed in internal process improvements
Support/participate in committees as needed/directed that focus on data governance, data interpretation or process improvements
Documentation of information important to the continued delivery of analytic services
Other duties as assigned
Required Qualifications*
Required for Senior Level:
Bachelor’s Degree in a quantitative field like Business, Computer Science, Informatics, Engineering, biostatistics, public health, Economics or equivalent combination of education and experience.
A minimum of 5 years of progressively responsible experience in data analysis and visualizations
Proficiency in the use of data analytic and BI reporting tools such as Tableau, SQL, SAS, Excel or other BI tools
Understanding of database structures and data architecture relevant to the development of dynamic reporting
Ability to consistently meet deadlines in a fast paced and changing environment with multiple competing tasks and priorities
Experience with Data Warehouse and BI systems
Strong customer service skills and commitment to excellent customer service
Strong analytical and problem-solving skills
Good verbal, written and visual presentation skills
Demonstrated ongoing ability to function effectively on and across teams
Ability to anticipate requests and needs in advance and plan accordingly
Skills to work effectively across internal functional areas in ambiguous situations
Required for Intermediate Level:
Bachelor’s Degree (Quantitative Field like biostatistics, public health, Computer Science, Economics, Engineering, Informatics) or equivalent combination of experience and education.
A minimum of 3 years of progressively responsible experience in data analysis
Ability to develop and maintain proficiency in the use of analytic and reporting tools such as SQL, SAS, Microsoft Excel, Tableau or other BI tools
Ability to consistently meet deadlines in a fast paced and changing environment with multiple competing tasks and priorities
Experience with Data Warehouse and BI systems
Strong customer service skills and commitment to excellent customer service
Strong analytical and problem-solving skills
Demonstrated ongoing ability to function effectively on and across teams
Good verbal, written and visual presentation skills
Ability to anticipate requests and needs in advance and plan accordingly
Skills to work effectively across internal functional areas in ambiguous situations
Desired Qualifications*
Bachelor’s Degree (with quantitative elements) with an advanced degree (Business, Biostatistics, Public Health, Computer Science, Economics, Engineering, Informatics) preferred
5 or more years of progressively responsible experience in health care/HR analysis and data visualizations
Ability to incorporate R, Python or other programming languages to enhance reporting through statistical analysis, forecasting and modeling
Experience with working with administrative data (HR, Development, Space, Learner, etc.)
Work Locations
Flexible First Work Policy
This position is eligible for the University of Michigan’s Flexible First Work Policy. The selected candidate will be able to work with their manager to establish a flexible work schedule that can range from fully remote to fully on-site. The analyst may need to be on-site from 4-10 days per year.
Underfill Statement
This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.
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.
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/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.
U-M COVID-19 Vaccination Policy
COVID-19 vaccinations, including one booster when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine. This includes those working remotely and temporary workers. More information on this new policy is available on the U-M Health Response website or the UM-Dearborn and UM-Flint websites.