Financial Modeling & Planning Systems Senior Professional

Job Summary:

The Financial Modeling & Planning Systems Senior Professional role serves as a professional partner to the Budget Planning and Campus Strategy department the School of Medicine (SOM) and the Executive Vice Chancellors Office by designing and delivering scalable Anaplan planning models. This position leads the development and support of complex multidimensional models that integrate data from Oracle PeopleSoft clinical providers and other enterprise systems to enable informed planning policy decisions and operational improvements. Working closely with the Director of Business Optimization & Insights the role also supports recurring and ad hoc analytical requests related to crossfunctional initiatives and executivelevel priorities.

This position supports Anaplan operations for the School of Medicine and serves as a key contributor within the Anaplan Center of Excellence (CoE). The role assists in the development of workflows coordinates and leads Anaplanrelated initiatives and oversees data collaboration across the School of Medicine and the broader institution. Responsibilities include ensuring adherence to established governance compliance standards and Anaplan best practices in support of enterprise transformation efforts.

This role acts as an Anaplan model builder with primary responsibility for independently managing School of Medicine Anaplan models including (but not limited to) FTE Effort Reporting GAP Analysis Funds Flow Reconciliation Commitments structured around financial drivers scenarios and organizational hierarchies. The position is accountable for the ongoing accuracy scalability and usability of these models.

To be successful in this role the incumbent must rapidly develop a deep understanding of data structures and source systems across campus and clinical environments; build strong relationships with campus and clinical partners; and support those partners in evaluating requirements processes and procedures related to effective data collection and management. Anaplan is the primary enterprise platform supported by this role. If the incumbent is not currently Anaplancertified a formal certification path will be provided with the expectation of achieving Anaplan Solution Architect certification within the first year of employment.

Key Responsibilities

Anaplan Model Builder - 80%

• Design build and maintain multidimensional financial models in Anaplan incorporating time versions scenarios and organizational hierarchies.

• Recommend and implement improvements to processes and workflows to ensure data integrity model performance and readiness prior to publishing Anaplan models for the School of Medicine.

• Serve as the primary point of contact for School of Medicine Anaplan model requests and ongoing support including FTE Effort Reporting GAP Analysis Funds Flow Reconciliation and Commitments.

• Act as an Anaplan model builder for campuswide models including All Funds Budgeting Salary Setting MidYear Salary Setting Tuition Revenue and Administration models.

• Translate existing solutions spreadsheets and complex business problems into scalable maintainable Anaplan multidimensional models.

• Conduct comprehensive testing validation and troubleshooting toidentifyand resolve model issues and ensure accuracy and usability.

• Apply Anaplan best practices related to sparse vs. dense dimensional design to balance flexibility performance and longterm maintainability.

• Monitor Anaplan product updates and enhancements incorporating new functionality into existing models whereappropriateand beneficial.

• Collaborate with campus units and the Director of Business Optimization & Insights to develop sustainable systems governance mechanisms and procedures for tracking institutional data in support of strategicobjectives.

Data Analytics & Engineering 20%

• Write and optimize complex SQL queries across enterprise data platforms including Oracle MS SQL Server and Snowflake involving large relational joins analytical functions (e.g. window functions CTEs subqueries) and performance tuning.

• Troubleshoot and support ETL processes data flows and system dependencies ensuring reliability and consistency across source systems.

• Validate and reconcile data to ensure data quality accuracy and alignment with financial and operational models.

• Present and visualize quantitative and qualitative data related to the School of Medicines key mission areas supporting executive and stakeholder decisionmaking.

• Analyze business and technical requirements and implement assigned development tasks usingappropriate toolsand technologies.

• Utilize Python or similar tools to support data preparation automation and efficiency improvements asappropriate.

This description is a summary only and describes the general level of work beingperformedit is not intended to be all-inclusive. The duties of this position may change from time to time and/or based on businessneed. We reserve the right to add ordeleteduties and responsibilities at the discretion of the supervisor and/or hiring authority.

Work Location:

Hybrid This position is currently eligible for hybrid work environment coming to campus 3 days a week or more depending on business requirements. A work schedule which consists of on campus and as-needed for in-person meetings may be implemented at some point.

Why Join Us:

At our institutionyoullhave the opportunity to make a meaningful impact byshapingthe systems and insights that drive critical financial and strategic decisions across a world-class academic and healthcare environment. This role offers a unique blend of technology data and finance allowing you to work on complex high-visibility initiatives while collaborating with diverse stakeholders across campus and clinical part of a forward-thinking team committed to innovation continuous improvement and professional growthincluding support for Anaplan certification and development. If you are intellectually curious motivated to solve challenging problems and eager to build scalable solutions that influence real-world outcomes this is an exceptional opportunity to grow your career.

Why work for the University

We haveAMAZINGbenefits and offerexceptional amounts of holiday vacation and sick leave! The University of Colorado offers an excellent benefits package including:

• Medical: Multiple plan options
• Dental: Multiple plan options
• Additional Insurance: Disability Life Vision
• Retirement 401(a) Plan: Employer contributes 10% of your gross pay
• Paid Time Off: Accruals over the year
• Vacation Days: 22/year (maximum accrual 352 hours)
• Sick Days: 15/year (unlimited maximum accrual)
• Holiday Days: 10/year
• Tuition Benefit: Employees have access to this benefit on all CU campuses
• ECO Pass: Reduced rate RTD Bus and light rail service

There are many additional perks & programs with the CU Advantage.

Qualifications:

Minimum Qualifications:

• Bachelors degree from an accredited institution in Computer Science Data Science Information Technology Business Administration Finance Mathematics Statistics or a related field. Substitution: A combination of education and related technical military or paraprofessional experience may be substituted for a bachelors degree on a yearforyear basis.

• Two (2) years of professional experience in Business Data Analytics Financial Planning & Analysis Enterprise Performance Management (EPM) or a related analytical or systems role. Substitution: An advanced degree (Masters or Doctorate) in a field directly related to the work assignment may be substituted for experience on a yearforyear basis.

• Experience using SQL and business intelligence / analytics tools (e.g. Power BI Tableau or similar).

Applicants must meet minimum qualifications at the time of hire

Conditions of Employment:

• This position is currently eligible for hybrid work environment coming to campus 3 days a week or more depending on business requirements. A work schedule which consists of on campus and as-needed for in-person meetings may be implemented at some point.

• Please be advised that this position is not eligible now or in the future for visa sponsorship.

• If the incumbent is not certified in Anaplan there will be a certification path to become Anaplan Solution Architect certified in the 1^st year of employment.

Preferred Qualifications:

• Masters degree and/or equivalent experience in a relevant discipline such as Data Science Business Analytics Computer Science Information Technology Finance Economics Mathematics or Statistics.

• Experience building multidimensional financial models in a modern enterprise planning platform (e.g. Anaplan or similar).

• Anaplan Model Builder certification.

• Experience supporting Financial Planning & Analysis (FP&A) and/or Human Resources functions.

• Experience using Python or similar scripting tools for data preparation automation or analysis.

Competencies:

• Proven ability to translate complex business questions into structured financial models analyses and decisionready insights.

• Working knowledge in Financial Planning & Analysis and Human Resources.

• Familiarity with best practices for data integrity analysis visualization and security.

• Strong understanding of data structures relationships and data manipulation.

• Ability to be self-sufficient understanding and documenting business requirements then translating them into a technology solution.

• Highly motivated problem solver that is a tenacious learner intellectually curious and excited about learning new technologies.

• Strong business analytical skills and a strong aptitude for multi-dimensional modeling tools

• Proficiency in data analysis and visualization tools like Power BI Tableau SQL and Python.

• Proficiency in statistical concepts and methodologies

• Demonstrated ability to work as part of a team in a collaborative environment build consensus and promote the exchange of information.

• Ability to understand the basic workings of databases and data flow.

• Creative problem-solver with a passion for identifying needs and proposing solutions.

• Ability to manage workload autonomously work with many constituents juggle multiple competing tasks and set priorities to achieve results.

• Ability to work under tight/changing deadlines.

• Ability to learn new software and systems quickly and independently.

• Strong verbal written communication and presentation skills.

How to Apply:

For full consideration please submit the following document(s):

1. A letter of interest describing relevant job experiences as they relate to listed job qualifications and interest in the position

2. Curriculum vitae / Resume

3. Three to five professional references including name address phone number (mobile number if appropriate) and email address

Questions should be directed to: Sean McBride

Screening of Applications Begins:

Applications will be accepted until finalists are identified but preference will be given to complete applications received by April 17 2026. Those who do not apply by this date may or may not be considered.

Anticipated Pay Range:

The starting salary range for this position has been established as $70889 - $90171.

The above salary range represents the Universitys good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation depending on the level.

Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave health plans and retirement contributions that add to your bottom line.

Total Compensation Calculator

Equal Employment Opportunity Statement:

CU is an Equal Opportunity Employer and complies with all applicable federal state and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity and we encourage individuals from all backgrounds to apply including protected veterans and individuals with disabilities.

ADA Statement:

The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act please contact the Human Resources ADA Coordinator at

Background Check Statement:

The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty staff students and visitors. To assist in achieving that goal we conduct background investigations for all prospective employees.

Vaccination Statement:

CU Anschutz strongly encourages vaccination against the COVID-19 virus and othervaccine preventable diseases. If you work visit or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work visit or volunteer addition if you work in certain research areas or perform certain safety sensitive job duties you must enroll in theoccupational health medical surveillance program.