Business Systems Analyst Sr
Job Summary
The Michigan Medicine Financial Systems team provides leadership, oversight, and technical support for financial products, applications, and datasets used by the Finance Organization of Michigan Medicine.
Responsibilities
Monthly Production Validations & Change Management Process
Coordinating with the requester to complete the request documentation
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
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
Collaborate with Vendor technical teams, internal enterprise architecture, and application infrastructure teams to resolve technical issues and understand systems dependencies and compatibility
Function as a back-up for production Financial Systems Analyst teammates to support month-end, quarter-end and annual reporting tasks
Documentation, Validation, and Governance
Prepares and conducts comprehensive testing and validation procedures
Full integration of new processes into documentation and training
Maintain training and end-user documentation
Create and maintain Data Governance documentation, including but not limited to: Data Dictionaries, Data/Process flow diagrams, Data Model Fact Matrices
Ad Hoc 20%
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
Detail 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
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