Solution Architect Senior

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. The team delivers enterprise-level reporting and business intelligence systems, manages high-visibility projects, guides data stewardship, and supports institutional enterprise objectives.

Responsibilities

• Technical Programming and Application Administration of Strategic Initiatives and Development (50%)
• Design and maintenance of data models within our relational data warehouse
• Develops data modeling and is responsible for data acquisition, access analysis and design, archiving, recovery, and load strategy design and implementation
• Application administration and configuration to support all strategic initiatives and development for the following Michigan Medicine Financial Systems cloud-hosted applications:
• Finance BI (Oracle Cloud Analytics application used for decision support across Michigan Medicine Finance)
• Multiple Oracle Enterprise Performance Management (EPM) Cloud Applications
• Designing enterprise-level reporting solutions that integrate our cloud-hosted reporting applications and data warehouse
• Maintaining and improving upon a reporting landscape design that is complex and varied in nature
• Integrating new and modified ETL processes with other Financial System processes with a focus on accuracy, efficiency, and automation
• Possesses and applies a broad knowledge of principles, practices, and procedures of Financial Systems data sets
• Research and maintain knowledge of current application releases and emerging technological capabilities with a focus on cloud-hosted solutions in order to provide optimal business solutions
• Work with vendor technical teams, internal enterprise architecture, and application infrastructure teams to resolve technical issues and understand systems dependencies and compatibility
• Research and address system vulnerabilities
• Documentation, Validation, and Governance (15%)
• Prepares and conducts comprehensive testing and validation procedures
• Oversight of documentation, training, compliance, and handover to the production team for implementation
• Participate in the administration of business and project plans related to development initiatives
• Advisory and Strategic Development (25%)
• Propose changes in process, policy, standards, application, and data model design to peers and leadership
• Problem solving and troubleshooting within a complex, varied, and evolving technical landscape
• Identify and evaluate industry trends and advise leadership on the impact on our environment
• Work proactively to assess risks or changes affecting our environment and determine appropriate action plans to manage changes
• Utilize agile methodologies to define project scope and schedule while focusing on regular and timely delivery of value
• Ad Hoc (10%)
• 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

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)

Desired Qualifications

• Clarity Certification or Proficiency
• Experience working with Financial and Clinical Healthcare data
• Experience working with health care billing and reimbursement data
• 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
• 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

Why Join Michigan Medicine?

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.