Financial Systems Analyst Senior

University of Michigan

Ann Arbor, MI

ID: 7230512
Posted: March 21, 2024
Application Deadline: Open Until Filled

Job Description

Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

Who We Are
The Michigan Medicine Financial Systems team provides the leadership, oversight, and technical support for the suite of financial products, applications and datasets used by the Finance Organization of Michigan Medicine for financial reporting, planning, analytics, and decision making. The team is responsible for delivering on-time enterprise-level reporting and business intelligence systems, managing concurrent high visibility projects to support new initiatives, guiding data stewardship, and informing and supporting institutional enterprise objectives.

Production team focuses on administration and end user support to deliver on-time production systems, providing high data quality and exceptional business value to our stakeholders. Responsibilities include all aspects of administering enterprise level reporting solutions.

Responsibilities*
Budget and Annual Change Management Processes - 40%

Partner with finance stakeholders on annual hierarchy, statistics, and budget process updates
Manage full end to end technical support of annual budget process including but not limited to collecting stakeholder requests and coordinating technical solutions, documentation, and end user training
Analyze request for adherence to our "one version of the truth" philosophy, as well as impact to application and technical processes
Understand the impact of the requested change on business and technical processes, and ensure that key stakeholders have been informed and in agreement
Serve as a functional backup for implementing and reviewing hierarchy and statistical changes, noting affected application and dependencies
Report and Query Building for internal and external customers using tools such as Oracle BI Publisher, Oracle Analytics Cloud and Data Visualizer and Narrative Reporting
Documentation, Validation and Governance - 40%

Prepares and conducts comprehensive testing and validations procedures related to the annual budget collection and annual reporting updates
Full integration of new processes into documentation and training
Continuously review annual budget validation processes, ensuring completeness, accuracy, and efficiency
Managing the inventory of system documentation and instructions utilizing searchable dynamic solutions
Maintaining training and end-user documentation
Provide full end user support during the annual budget collection
Maintaining and periodic scheduled testing of full application disaster recovery across all production systems
Create and maintain Data Governance documentation including but not limited to:
o Data Dictionaries

o Data/Process flow diagrams

o Data Model Fact Matrices

Ad Hoc - 20%

Go to person for ad hoc analysis, end user requests to understand data flows, data dependencies and appropriate use and consumption of Finance presented data
Required Qualifications*
BA/BS degree

5-7 years of financial systems, data analytics or financial analysis experience

Desired Qualifications*
Detailed knowledge and understanding of SQL
Experience with data modeling and relational databases
Demonstrated creative critical thinking skills
Ability to assess competing priorities, manage workflow and meet operational deadlines
Must work well independently and as part of a team
Able to demonstrate excellent interpersonal, written, and verbal communication skills
Excellent collaboration and coordination skills for an effective relationship with multiple teams, subject matter experts (SMEs), and customers
Experience with Data Extraction, Transformation, and Loading (ETL)
Experience integrating data from multiple sources
Knowledge and understanding of technical accounting principles
Experience with Oracle Analytics Cloud or similar BI tools
Experience with Oracle Enterprise Performance Management Products
Understanding of common IT business analysis, and/or project management methodologies and best practices
Experience with Oracle Cloud Infrastructure
Experience with Oracle Enterprise Performance Management Cloud applications
Experience with multidimensional DBMS
Experience with query, report writing, and data visualization tools
Clarity Certification or Proficiency
Experience working with Financial and Clinical Healthcare data
Additional Information
This job might be right for you if you?

Strive to work with technology used by top companies and multiple industries
Enjoy creative problem solving and making new discoveries
Have a drive for designing, developing, and recommending innovative approaches, methodologies, and tools
Want to work on an embedded technical team that collaborates directly with our key partners
Have an interest in working with diverse dimensions of health care analytics, including financials, revenue reporting, patient care statistics, etc.