Business Financial Planning Analyst

University of Colorado•Hybrid, CO

166d•$78,810 - $100,247•Hybrid

About The Position

The School of Medicine Office of the Dean is seeking a highly-skilled and strategic Business Financial Planning Analyst to lead our analytics and drive data-driven decision-making across the school and campus. The ideal candidate will possess a deep understanding of business processes, exceptional analytical skills, and a proven track record of leveraging data to inform and guide business strategy. This leadership role requires a combination of technical expertise, business acumen, strategy planning capabilities, and strong communication skills to effectively collaborate with cross-functional teams. The ideal candidate possesses expert-level financial acumen and has practical experience in fund accounting and financial analysis. This experience will serve as the basis for leading the financial planning and analytics of the Office of the Dean and driving data-based decision-making. The main effort will be to continue to build upon the current data systems and work to lead efforts to identify areas to leverage pre-existing, vetted data, and future data points – yet to be identified - to enhance business and financial operations across the School of Medicine in partnership with Sr. Leaders within the School of Medicine Dean’s Office. This role will work closely with our IT partners within the School of Medicine and within the Anschutz Medical Campus. If you love to learn, need to understand what and why, and are fascinated by the interconnected complexity of one of the largest schools of medicine in the country, then this is the place for you.

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.
Applicants must meet minimum qualifications at the time of hire.

Nice To Haves

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.
Advanced proficiency with data visualization tools (e.g., Tableau, Power BI).
Working knowledge of data mining principles: predictive analytics, mapping, collecting data from multiple data systems on premises and cloud-based data sources.
Strong SQL skills and ability to perform effective querying involving multiple tables and subqueries.
Ability to communicate effectively, both in writing and orally.
Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.
Outstanding customer service skills.
Understanding of a broad range of information technologies and their applicability to the business process, while recognizing shortcomings of existing technologies in determining best available solutions.
Ability to provide strategic project management in coordinating and organizing resources, establishing priorities, and ensuring the project is completed satisfactorily and in a timely manner.
Ability to learn and support new systems and applications.
Ability to provide technical training to end users, including being able to communicate technical information in a manner that non-technical personnel can understand.
Blend of technical expertise, business acumen, strategic planning capabilities, and strong communication skills to effectively collaborate with cross-functional teams.
Extensive knowledge and expertise in budgeting, financing, and accounting within a higher education setting.
Proven organizational and analytic skills throughout a complex and matrixed organization.
Advanced analytical abilities and skills to address significant issues and demonstrate judgment to resolve complex problems.

Responsibilities

Work in partnership with the School of Medicine Finance team and our Data teams. (Application Development teams on business services technology solutions).
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.
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.