Financial Systems Analyst Senior - Ann Arbor, United States - University of Michigan

Description

What You'll Do

All the relevant skills, qualifications and experience that a successful applicant will need are listed in the following description.

The Production Financial Systems Analyst Senior primary focus is production administration of the solutions for the Michigan Medicine financial reporting and annual budget process. The team manages and all underlying data sources and processes supporting these systems. The role is responsible for providing timely, accessible, and accurate data according to the Finance department defined timelines.

This role is responsible for managing and administering the enterprise-level reporting solutions, integrating cloud-hosted reporting applications, data warehouse and critical organization business processes. This position utilizes a thorough understanding of accounting and finance principles to deliver financial systems solutions that drive value and decision making across the institution. This position is responsible for analyzing and translating business, information, and technical requirements into enterprise-level reporting solutions. This role is responsible for researching and maintaining knowledge in current and emerging technologies to solve business problems with a focus on cloud-hosted solutions. Problem solving and developing integrated solutions within a complex, varied, and evolving technical landscape will be an essential part of this position. This role serves as a liaison between end users, stakeholders, and the solutions architects to propose changes in process, policy, standards, application and end user experience to peers and leadership. In addition, this position will partner with key stakeholders and leadership in requirement gathering and data analysis as well as work with team solutions architects to deliver enterprise reporting solutions.

In performing the role, the Production Financial Systems Analyst will need to possess strong finance, accounting, and health care business practices knowledges. This role will require a strong technical understanding pf relational database models, SQL and multiple Oracle technologies including Oracle Cloud Analytics and Cloud EPM applications.

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.

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.

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

BA/BS degree

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

• 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

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.

Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.

The University of Michigan is an equal opportunity/affirmative action employer.