Michigan Medicine · 17 hours ago

Financial BI Specialist

Ann Arbor, MI

Full-time

Remote

Mid, Senior Level

5+ years exp

Maximize your interview chances

EducationHealth Care

Actively Hiring

Insider Connection @Michigan Medicine

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Support clinical healthcare and research activities through business intelligence data analysis, database marketing, data mining, dashboard creation, and data management.

Deliver reports, dashboards and write advanced SQL queries.

Design and support automated workflows to extract, structure, and store data.

Develop descriptive and predictive models and perform analysis 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.

Function as a pre- and post-award specialist compiling statistical, financial, accounting, or auditing reports and tables pertaining to such matters as journal entries, vouchers, and standard transactions such as expenditures for materials, equipment, support staff, and travel.

Advise faculty on long-term financial viability for multiple research grants and contracts from various sources with differing project end dates.

Assist faculty in preparation of award change requests, budget reallocations, and other U-M-required or sponsor-required reports, as directed.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Business Intelligence ReportingFinancial AnalysisPre-Post-Award ExperienceSQLSAP Crystal ReportsTableauPythonRSPSSFinancial ModelingData ManagementResearch Proposal PreparationBudget ReallocationsChange Management

Required

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 the budget and forecast spending

Experience assisting with research grant pre-award data management, research proposal preparation and budgeting, and post-award budget changes, extensions, and renewals