BI Analyst Intermediate

BI Analyst Intermediate University of Michigan - 4.3 Ann Arbor, MI Job Details Full-time $65,000 a year 1 day ago Qualifications Google Workspace Data reporting Database design Productivity software Excel data analysis Full Job Description 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 - 40% 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 - 30% 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 - 30% 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. Required Qualifications• Bachelor's degree in a relevant field, or an equivalent combination of education and experience 2-5 years of experience with database software, including database design, implementation, maintenance, and reporting Experience managing investigative case management platforms 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 Skills You Have Other beneficial knowledge and skills to have for this role include: Proficiency with Microsoft Power BI Project management experience Knowledge of University business and operations Experience working in higher education 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 the work modes. This position works in-person two (2) days per week or as needed. U-M EEO Statement The University of Michigan is an equal employment opportunity employer. Job Opening

ID 277699

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 5/15/2026 - 5/22/2026 Salary $65,000.00 - Career Interest Administration Information Technology Legal & Government Relations Social Work