Business Financial Planning Analyst

The University of Colorado Anschutz Medical Campus is a public education, clinical, and research facility serving 4,500 students and is a world-class medical destination at the forefront of life-changing science, medicine, and healthcare. The Business Financial Planning Analyst will lead analytics and drive data-driven decision-making across the School of Medicine, utilizing exceptional analytical skills and financial acumen to inform business strategy.

Responsibilities:

• Work in partnership with the School of Medicine Finance team and our Data teams. (Application Development teams on business services technology solutions)
• This role is expected to develop and foster strong relationships and collaborations within and across the School of Medicine Office of the Dean’s Offices – which includes Business Affairs, Information Services, Human Resources, Faculty Affairs, Research Affairs, Clinical Affairs, Shared Services teams – as well as AMC Central Services Offices and School of Medicine department administrators
• This is a dynamic and deadline-driven position, demanding an agile leader with the ability to prioritize, make recommendations, and independently make decisions when appropriate
• Forecasting (short- and long-term), variance analysis, long-range strategic financial planning, space plans/allocations, departmental financial performance, and overall School of Medicine progress toward financial goals
• Utilize analytical techniques to interpret key findings from business data and translate these insights into proposals/plans that will support school and campus initiatives and outcomes
• Leverage exception reporting, allowing for targeted focus on the resolution of variances and/or incorrect data entry
• Stay current with industry trends and advancements in business analytics, incorporating new technologies and methodologies as appropriate
• Collaborate with the SOM Finance Team on the completion and submission of School of Medicine Dean’s Office Auxiliary Budgets and serve as a resource and subject matter expert, providing support to departments
• Collaborate with the development of the monthly financial analysis and review for the School of Medicine’s Shared Services programs
• Develop and maintain reporting, dissemination, data automation systems, dashboards, and performance metrics that support key business decisions and relieve administrators of one-off, disparate, and inconsistent reporting
• Understand the end-to-end flow of the existing data tools across the School of Medicine - where the data originates, challenges with the source data, and how we addressed those issues
• Make decisions on the data needed, how the data are presented, how they are related, interpret the requirements/needs, and stand behind what is built when socializing the information
• Communicate complex technical concepts to non-technical stakeholders, fostering a data-driven decision-making culture throughout the school
• Support the various annual survey efforts – including the collection, collating, and analyzing, and accurately submitting data in preparation of annual national and University surveys, which are submitted to the School’s accreditation agencies and professional organizations (i.e., LCME, AAMC, MGMA, Sullivan Cotter, US News and World Reports, etc.)
• This description is a summary only and describes the general level of work being performed; it is not intended to be all-inclusive. The duties of this position may change from time to time and/or based on business need. We reserve the right to add or delete duties and responsibilities at the discretion of the supervisor and/or hiring authority

Requirements:

• A bachelor's degree in healthcare administration, business administration, finance, accounting, public administration, or a directly related field from an accredited institution
• Three (3) years of experience utilizing data from multiple databases and reporting systems, structuring it to meet reporting needs and inform business decisions
• Three (3) years of experience using a variety of analytics techniques to contribute to an organization's strategic initiatives, projects, and business outcomes
• A combination of education and related technical/paraprofessional experience may be substituted for the bachelor's degree on a year-for-year basis
• Applicants must meet minimum qualifications at the time of hire
• A master's degree in information technology, information systems, business administration, finance, accounting, healthcare administration, public administration, or a directly related field from an accredited institution
• Five (5) years of experience leading and managing business analytics functions
• Business Analytics experience in an academic medical institution
• Experience utilizing Power Query & Power BI, DAX
• Experience using Excel, e.g., Pivot Tables and VLOOKUP, etc