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.

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.

The Rogel Cancer Center is seeking a highly skilled Business Intelligence Analyst Intermediate to support the development of a centralized analytics and reporting infrastructure aligned with National Institutes of Health (NIH) Cancer Center Support Grant (CCSG) operations and leadership decision support.

This position will serve as the primary analyst responsible for the integration, transformation, validation, and visualization of complex research administration and cancer center operational data across multiple institutional systems and platforms. The role will support the development of scalable reporting workflows, reusable transformation logic, and leadership-facing dashboards that enable timely, accurate, and actionable insight across the cancer center enterprise.

The successful candidate will work closely with cancer center research administration, Health Information Technology Services (HITS), leadership stakeholders, and operational teams to support the transition from fragmented, manually assembled reporting toward a centralized, sustainable business intelligence environment. This includes supporting development of standardized reporting processes, dashboard-based visualizations, repeatable analytics workflows, and integrated reporting across cancer center operational domains.

This position is embedded within a highly collaborative environment and will support operational, leadership, and federal reporting across areas including research funding, publications, membership, internal funding programs, shared resources, and other cancer center metrics.

Data Integration, Transformation, and Validation (40%):

• Develop and maintain reusable data transformation workflows, reporting logic, validation processes, and standardized reporting structures across institutional and external data sources
• Aggregate, integrate, reconcile, and validate complex datasets related to cancer center operations, research administration, and leadership reporting
• Apply structured attribution and transformation methodologies to institutional grant and funding data in support of CCSG and related reporting requirements
• Develop scalable workflows and structured datasets to support recurring reporting cycles, analytics platforms, and dashboard environments
• Collaborate with HITS and institutional data partners to:
  • define data requirements and technical specifications
  • support development of structured data extracts, reusable data views, and relational datasets
  • improve scalability, consistency, and repeatability of reporting workflows
• Support development and maintenance of relational datasets and reporting environments, including systems such as Advarra EVAL
• Implement and maintain data quality assurance processes to ensure consistency, integrity, and reproducibility across reporting environments

Dashboard Development and Reporting (25%):

• Design, develop, and maintain leadership-facing dashboards and visualizations using Tableau, Power BI, Envisio, or similar business intelligence platforms
• Translate complex operational and research data into clear, actionable visual reporting outputs for leadership, strategic planning, and operational decision-making
• Support longitudinal performance tracking, trend analysis, and visualization across cancer center operational domains
• Develop reusable reporting views and scalable dashboard infrastructure to support institutional reporting, external advisory board reviews, and presentation needs
• Support sustainable dashboard refresh, maintenance, and validation workflows

CCSG and Cancer Center Metrics Production (20%):

• Produce and maintain standardized cancer center reporting datasets and metrics across domains including: 
  • research funding and grant attribution
  • NCI/CCSG reporting tables
  • publications and publication reporting workflows
  • membership and program alignment
  • pilot/internal funding outcomes and return-on-investment reporting
  • shared resource utilization metrics
• Coordinate with operational leaders and subject matter experts to support consistent metric definitions, reporting standards, and governance practices
• Support implementation and maintenance of standard operating procedures (SOPs), technical documentation, and recurring reporting processes
• Contribute to development of scalable reporting methodologies that reduce reliance on one-time manual data assembly

Systems Coordination and Business Process Support (10%):

• Serve as a liaison between cancer center operational stakeholders, HITS, and institutional technical/data teams regarding analytics workflows, reporting priorities, and business requirements
• Assist with optimization of operational workflows related to data intake, transformation, validation, reporting, and dashboard production
• Support implementation and operationalization of reporting tools, analytics platforms, and integrated reporting processes
• Collaborate with operational owners across publications, membership, pilot funding, grants administration, shared resources, and related functional areas to support coordinated reporting activities and data governance efforts

Special Projects and Emerging Reporting Needs (5%)

• Bachelor's degree in data analytics, informatics, business intelligence, statistics, health administration, computer science, or related field, or equivalent combination of education and experience
• 3-5 years of relevant analytics, reporting, business intelligence, or data management experience
• Demonstrated proficiency with SQL querying, relational datasets, reusable data transformation workflows, and structured reporting methodologies
• Experience supporting/developing reporting workflows, validation processes, data transformation pipelines, and technical/process documentation
• Experience with business intelligence and visualization platforms such as Tableau, Power BI, Envisio, or similar tools
• Demonstrated aptitude for learning complex reporting logic and business processes
• Strong analytical and communication skills with the ability to work collaboratively across technical and operational teams
• Demonstrated ability to work collaboratively with technical and operational stakeholders while managing multiple projects

• Experience in academic medicine, research administration, cancer center operations, healthcare analytics, or higher education analytics environments
• Familiarity with NIH reporting structures, research administration reporting, or regulated reporting environments
• Experience working with institutional data systems, enterprise analytics platforms, and dashboard-driven reporting initiatives
• Experience with data governance, reporting standardization, SOP development, or analytics process improvement initiatives
• Familiarity with publication reporting workflows, grant and funding datasets, operational performance metrics, or related research administration data domains
• Experience supporting integration and reporting workflows across platforms such as Advarra EVAL or similar analytics/reporting systems
• Familiarity with oncology, cancer center, or biomedical research terminology and reporting concepts

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

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.

Rogel Cancer Center

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 any time after the minimum posting period has ended.

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.