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. 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 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. 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.