Michigan Medicine Financial Systems - Responsibilities/Duties for Applications Programmer Analyst Intermediate – Strategic Initiatives and Development
Why Join the Michigan Medicine Financial Systems Team?
As an Intermediate Application Programmer, you will be responsible for the technical programming and administration within the Financial Systems’ Development team to deliver solutions that provide excellent business value to our users. In performing the role, you will need to possess strong technical knowledge and experience with relational database models, SQL and multiple Oracle technologies including OBIEE, Hyperion Enterprise Performance Management and Cloud hosted applications. In addition, it is helpful for you to have a understanding of finance, accounting, and health care business practices.
You will be a member of a team that provides the leadership and oversight for the suite of financial products and applications used to support the financial reporting, planning and decision-making of our Finance Organization.
Technical programming and administration of Strategic Initiatives and Development - 40%
Support strategic and development initiatives for the following “Michigan Medicine Financial Systems” applications. This includes development of new datasets and reports, application administration, training, compliance and handover to production team for implementation:
Finance BI& Oracle Database - (Business Intelligence Application used for decision support across Michigan Medicine Finance)
PBCS (Application for Health System Cohort and Financial Budgeting)
EPBCS (Application for Health System Strategic Modeling)
Hyperion Essbase (Multiple Applications for Consolidated Actual Financial and Budget reporting)
Process and Quality Improvement - 30%
Support ongoing process and quality improvement initiatives. This will include both assigned, and self-identified improvement opportunities.
Strategic Development - 20%
Assist in long term planning for our reporting solutions. This will include staying current on industry trends, conduct research and submit recommendations on various technologies, advising leadership, and providing technical specifications for application improvements.
Ad Hoc - 10%
Items may include but are not limited to: Defining system documentation, helpdesk support, providing training, supporting compliance and governance initiatives.
Position is not a sponsored visa.
BA/BS degree in computer science or related field
Experience with data modeling and relational databases
Demonstrated creative problem solving skills
Ability to assess competing priorities, manage workflow and meet operational deadlines
Work well independently and as part of a team.
Strong written, and verbal interpersonal skills.
Strong collaboration and coordination skills for an effective relationship with multiple team and customers
3-5 years of experience in an IT related field.
3-5 years of experience and detailed knowledge of SQL
1-2 years of experience in an IT related field.
1-2 years of experience and detailed knowledge of SQL
Experience working with Financial and Clinical Healthcare data
Data Extraction, Transformation, and Loading (ETL) experience
Experience integrating data from a variety of sources
Knowledge and understanding of technical accounting principles
Oracle Business Intelligence Enterprise Edition (OBIEE) or similar BI tools experience
Understanding of common IT business analysis, and/or project management methodologies and best practices
Experience with Oracle Cloud applications
Experience with Oracle Hyperion Enterprise Performance Management applications
Experience with Essbase multidimensional DBMS
Experience with query, report writing, and data visualization tools.
This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.
The mission of Michigan Medicine is to improve 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. With annual revenues of approximately $3 billion, Michigan Medicine ranks as one of the top academic health centers in the country, and is committed to providing exceptional patient care, facilitating groundbreaking research and developing the next generation of physicians and scientists. Michigan Medicine consists of the Hospitals, Health Centers and Clinics, the University of Michigan Medical School and its Medical Group, and the Michigan Health Corporation.
Health System Finance serves as the central finance group for Michigan Medicine and is comprised of six functional areas: Clinical Financial Planning & Analysis, Enterprise Financial Reporting & Forecasting, Academic Financial Planning & Analysis, Medical School Administration Finance, Reimbursement, and Financial Systems.
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.
Job openings are posted for a minimum of seven calendar days. This job 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.
Internal Number: 168216
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.