What You'll Do

The EPM Solutions Architect's primary focus is production administration of the EPM 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 designing and administering enterprise-level reporting solutions, integrating cloud-hosted reporting applications, data warehouse and critical organization business processes. 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 will propose changes in process, policy, standards, application, and data model design to peers and leadership. In addition, this position will partner with key stakeholders and leadership in requirement gathering and solution design as well as work with vendor technical teams, enterprise architecture, application, and infrastructure teams, to deliver enterprise reporting solutions.

In performing the role, the EPM Solutions Architect will need to possess strong technical knowledge and experience with relational database models, SQL and multiple Oracle technologies including Oracle Cloud EPM and Analytics applications. This role will require a strong understanding of finance, accounting, and health care business practices.

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*

Technical Programming and Application Administration of Production Systems - 50%

? Primary Responsibility for full application life cycle of all productions systems and datasets for the for Multiple Oracle Enterprise Performance Management (EPM) Cloud Applications Secondary responsibility for full application life cycle of all productions systems and datasets for Finance BI (Oracle Cloud Analytics application used for decision support across Michigan Medicine Finance)

? Administration of Integration of new and modified ETL processes to other Financial System processes with a focus on accuracy, efficiency, and automation

? Function as technical back-up for production Solutions Architect teammates

Documentation, Validation and Governance - 40%

Prepares and conducts comprehensive testing and validations procedures related to the annual budget collection
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
Work closely with appropriate stakeholders to develop the technical solutions related to the monthly and annual financial reporting and annual budget collection
Maintenance and periodic scheduled testing of full application disaster recovery across all production systems
Create and maintain Data Governance documentation including but not limited to:

Ad Hoc - 10%

Required Qualifications*

BA/BS degree
1-5 years of experience and detailed knowledge of SQL - Intermediate
5-7 years of experience and detailed knowledge of SQL - Senior
1-5 years of technical administration experience in Oracle Enterprise Performance Management Cloud Applications - Intermediate
5-7 years of technical administration experience in Oracle Enterprise Performance Management Cloud Applications - Senior

Desired Qualifications*

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
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

Underfill Statement

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

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.

Background Screening

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.

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

U-M EEO/AA Statement

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

Job Detail

Job Opening ID

246648

Working Title

EPM Solutions Architect (Sr / Inter)

Job Title

Solution Architect Senior

Work Location

Michigan Medicine - Ann Arbor

Ann Arbor, MI

Full/Part Time

Full-Time

Regular/Temporary

Regular

FLSA Status

Exempt

Organizational Group

Exec Vp Med Affairs

Department

MM Financial Srvcs

Posting Begin/End Date

3/21/2024 - 5/20/2024

Career Interest

Information Technology

University of Michigan

New Jobs

EPM Solutions Architect (Sr / Inter)