University Of Michigan - Ann Arbor, MI
posted about 2 months ago
Full-time - Mid Level
Remote - Ann Arbor, MI
Educational Services
About the position
The Financial BI Specialist at the University of Michigan plays a crucial role in supporting clinical healthcare and research activities through advanced business intelligence data analysis. This position involves creating dashboards, managing data, and delivering insightful reports to aid in decision-making processes. The specialist will also advise faculty on financial viability for research grants and contracts, ensuring compliance with various reporting requirements.
Responsibilities
- Support clinical healthcare and research activities through business intelligence data analysis.
- Deliver reports and dashboards, and write advanced SQL queries.
- Design and support automated workflows to extract, structure, and store data.
- Develop descriptive and predictive models to support planning and decision making.
- Collect and maintain key performance indicator data.
- Collaborate to identify technology-based process improvements and lead change management efforts.
- Compile statistical, financial, accounting, or auditing reports and tables for pre- and post-award activities.
- Advise faculty on long-term financial viability for multiple research grants and contracts.
- Assist faculty in preparation of award change requests, budget reallocations, and other required reports.
Requirements
- Bachelor's degree in Finance, Data Science, Economics, Statistics, or related field.
- 5 years of business intelligence reporting, financial analysis, and pre- and post-award experience.
- Experience using SAP Crystal Reports, Tableau, SQL, Python, R, and SPSS.
- Experience managing pre-award submissions and creating financial models to monitor budgets and forecast spending.
- Experience assisting with research grant pre-award data management, research proposal preparation, and budgeting.
Benefits
- Up to 100% remote work option within Michigan.
