• BI Analyst Intermediate

    University of Michigan (Ann Arbor, MI)


    BI Analyst Intermediate

    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 Business Intelligence (BI) Analyst Intermediate supports ECRT in a fast-paced, high-volume office environment by managing, analyzing, and reporting on complex data within a compliance-driven setting. This role designs and delivers accurate and insightful reports, supports business systems and process improvements, and documents sensitive misconduct reports.

     

    Success in this role requires strong analytical skills, a keen attention to detail, and an appreciation for the critical role data plays in supporting decision-making. The ideal candidate is professional, discreet, and comfortable handling sensitive information. They are proactive, adaptable, and thrive both independently and as part of a collaborative team. Excellent organization, reliability, and communication skills, as well as a commitment to continual learning, will further contribute to success in this position.

    Responsibilities*

    Data Analysis and Reporting - 60%

    + Leverage business intelligence software to design, create, export, and present data-driven qualitative and quantitative reports for a range of stakeholders to meet business and compliance needs.

    + Create and maintain data dashboards to inform leadership groups.

    + Respond efficiently to high-volume internal and external vetting requests by accurately interpreting and sharing relevant information.

    + Regularly conduct audits of records to identify and correct gaps and contradictory data relationships to ensure accurate reporting.

    Data Systems Development and Support - 25%

    + Design, model, and build data structures and mapping routines to address evolving data and reporting requirements for the office.

    + Collaborate with all ECRT teams and offices, including ECRT Dearborn, and ECRT Flint, to address diverse data needs.

    + Serve as a resource to database users, by providing system training. Mentor and support colleagues by sharing knowledge and expertise.

    + Maintain up-to-date departmental application and process documentation as systems and workflows evolve.

    Case Triaging & Workflow Analysis - 15%

    + Review, document, and analyze incoming misconduct reports, including those of a sensitive nature, for appropriate assignment to ECRT staff or referral response. Prepare case folders for incoming matters.

    + Evaluate incoming reports to requirements for additional reporting in accordance with standard process, legal, policy, or regulatory mandates.

    + Identify appropriate university or community resources to address concerns outside ECRT's purview, responding in a trauma-informed and empathetic manner.

    RELATED DUTIES

    Performs other related duties as assigned.

     

    Skills You Have

    Additional skills you have that will be beneficial in the role:

    + Proficiency with Microsoft Power BI

    + Project management experience

    + Knowledge of University business and operations

    + Experience working in higher education

    Required Qualifications*

    + Bachelor's degree in a relevant field, or an equivalent combination of education and experience

    + 3-5 years of experience with database software, including database design, implementation, maintenance, and reporting

    + Proven experience handling sensitive and confidential information with discretion

    + Strong attention to detail and accuracy in data management

    + Demonstrated ability to manage high-volume, deadline-driven workloads

    + Proficiency with Excel, Google Workspace, and related tools

    + Excellent communication, organizational, and interpersonal skills

     

    Modes of Work

     

    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 thework modes (https://hr.umich.edu/working-u-m/my-employment/ways-we-work-resource-center/ways-we-work-implementation-group/modes-work) . We work in a hybrid office with an expectation of at least (2) two days in-person.

     

    U-M EEO Statement

     

    The University of Michigan is an equal employment opportunity employer.

     

    Job Detail

     

    Job Opening ID

     

    270055

     

    Working Title

     

    BI Analyst Intermediate

     

    Job Title

     

    BI Analyst Intermediate

     

    Work Location

     

    Ann Arbor Campus

     

    Ann Arbor, MI

     

    Modes of Work

     

    Hybrid

     

    Full/Part Time

     

    Full-Time

     

    Regular/Temporary

     

    Regular

     

    FLSA Status

     

    Exempt

     

    Organizational Group

     

    President Office

     

    Department

     

    Intake and Support

     

    Posting Begin/End Date

     

    10/21/2025 - 11/11/2025

     

    Salary

     

    $65,000.00 -

     

    Career Interest

     

    Administration