> Markdown version of [/jobs/ext/263190-bi-analyst-intermediate](https://www.wearedevelopers.com/jobs/ext/263190-bi-analyst-intermediate). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Analyst Intermediate - **Company:** University of Michigan - **Location:** Ann Arbor, MI, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Business Systems, Databases, Data Structures, Data Systems, Database Design, Power BI, Data Analytics, Data Management, Gsuite - **Published:** May 15, 2026 - **Apply:** https://www.jobmonkeyjobs.com/career/27685095/Bi-Analyst-Intermediate-Michigan-Ann-Arbor-1233 ## About the Role * 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 ## Description 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. ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Cyber Sleuth: Finding Hidden Connections in Cyber Data](https://www.wearedevelopers.com/videos/893-cyber-sleuth-finding-hidden-connections-in-cyber-data) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)