Production Financial Systems Analyst 

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.

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

The Financial Systems Analyst's primary focus is on the production administration of the solutions the team manages and all underlying data sources and processes to support it. 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 requires 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 of current and emerging technologies to solve business problems, particularly with a focus on cloud-hosted solutions. Actively participating in 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. 

The Production Financial Systems Analyst must possess strong finance, accounting, and health care business practices knowledges. This role will require a strong technical understanding of relational database models, SQL and multiple Oracle technologies including Oracle Cloud Analytics and Cloud EPM applications.

Role and Responsibilities:

Monthly Production Validations & Change Management Process - 40%

• Ensure data quality and consistency throughout all production applications:
  • Finance BI (Oracle Cloud Analytics application used for decision support across Michigan Medicine Finance)
  • Multiple Oracle Enterprise Performance Management (EPM) Cloud Applications.
• Change Management monthly processing of hierarchies and statistics in all applications.
• Analyze request for adherence to our ?one version of the truth? philosophy, as well as impact to application and technical processes. 
• Partner with requestor on monthly hierarchy changes. Coordinating with the requester to complete request documentation
• Implement changes in Test environment and migrate changes to production.
• Communicate monthly changes to requestor and stakeholders and Financial Systems team.
• Tie out various financial systems datasets back to PeopleSoft (source system) and other source systems monthly in Test and Production environments for all applications.
• Monthly Unit of Service (UOS) static and metrics validations
• Manage all Test and Production data tie outs for monthly and annual processing in all applications.
• Manage all monthly report delivery solutions including maintaining distribution, automation, and development of enhancements.
• 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
• Work with Solutions Architects on monthly and annual tie out processing and implement new processes to improve efficiency and accuracy.
• Possesses and applies a broad knowledge of principles, practices, and procedures of Financial Systems data sets. 
• Collaborate with Vendor technical teams, internal enterprise architecture, and application infrastructure teams to resolve technical issues and understand systems dependencies and compatibility.
• Function as back-up for production Financial Systems Analyst teammates to support monthend, quarter-end and annual reporting tasks.

Documentation, Validation and Governance - 40%

• Prepares and conducts comprehensive testing and validation procedures.
• Continuously review month-end, quarter-end, and year-end validation processes, ensuring completeness, accuracy, and efficiency.
• Full integration of new processes into documentation and training 
• Managing the inventory of system documentation and instructions utilizing searchable dynamic solutions
• Maintaining training and end-user documentation
• 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:
  • Data Dictionaries
  • Data/Process flow diagrams
  • 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.
• Items may include but are not limited to:
  • Conducting peer and end-user training
  • Support special projects within Financial Systems as well as Michigan Medicine Finance
  • Support compliance efforts across organization.
  • Assist with other projects as required to contribute to efficiency and effectiveness of the work.
  • Helpdesk and end-user support
  • Coach and mentor junior staff.

• BA/BS degree
• 1-5 years of financial systems, data analytics or financial analysis experience - Intermediate level
• 5-7 years of financial systems, data analytics or financial analysis experience - Senior level

• 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 position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

Is this Job Right for You?

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 healthcare analytics, including financials, revenue reporting, patient care statistics, etc.
• Pay attention to detail and do not let anything fall through the cracks.
• Thrive while working in both team and individual settings.
• Are adaptable to changing conditions and maintain an elevated level of focus/energy.
• Feel confident offering support and expressing ideas to leadership.

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.

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.

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.

About University of Michigan - Ann Arbor

A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.

Connections working at University of Michigan - Ann Arbor