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

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.

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

• 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

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.  We work in a hybrid office with an expectation of at least (2) two days in-person.

The University of Michigan is an equal employment opportunity employer.