Business Systems Analyst Sr

About the role

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.

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 the request for adherence to our one version of the truth philosophy, as well as the impact on application and technical processes.
  • Partner with the requestor on monthly hierarchy changes. Coordinating with the requester to complete the request documentation.
  • Implement changes in the test environment and migrate changes to production.
  • Communicate monthly changes to the requestor, stakeholders, and the 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.

• 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 periodically scheduled testing of the 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 the organization.
  • Assist with other projects as required to contribute to the efficiency and effectiveness of the work.
  • Helpdesk and end-user support
  • Coach and mentor junior staff.

Requirements

• Required Qualifications

  • BA/BS degree
  • 1+ years of financial systems, data analytics, or financial analysis experience, at the Associate level
  • 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
  • 7+ years of financial systems, data analytics, or financial analysis experience, Lead level

• Desired Qualifications

  • Detailed knowledge and understanding of SQL.
  • Experience with data modeling and relational databases.
  • Demonstrated creative critical thinking skills.
  • Able 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.

Benefits

• Excellent medical, dental and vision coverage effective on your very first day
• 2:1 Match on retirement savings

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

Background Screening

The University of Michigan 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.

Application Deadline

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 any time after the minimum posting period has ended.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.