Financial Modeling & Planning Systems Senior Professional

Financial Modeling & Planning Systems Senior Professional

University of Colorado Anschutz Medical Campus

Department: Budget, Planning and Campus Strategy

Job Title: Financial Modeling & Planning Systems Senior Professional

Position #: 00844169 - Requisition #: 39546

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 Chancellor's Office by designing and delivering scalable Anaplan planning models. This position leads the development and support of complex, multi-dimensional 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 cross-functional initiatives and executive-level 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 Anaplan-related 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 Anaplan-certified, 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 multi-dimensional 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 campus-wide models, including All Funds Budgeting, Salary Setting, Mid-Year Salary Setting, Tuition Revenue, and Administration models.
• Translate existing solutions, spreadsheets, and complex business problems into scalable, maintainable Anaplan multi-dimensional models.
• Conduct comprehensive testing, validation, and troubleshooting to identify and resolve model issues and ensure accuracy and usability.
• Apply Anaplan best practices related to sparse vs. dense dimensional design to balance flexibility, performance, and long-term maintainability.
• Monitor Anaplan product updates and enhancements, incorporating new functionality into existing models where appropriate and 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 strategic objectives.

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 Medicine's key mission areas, supporting executive and stakeholder decision-making.
• Analyze business and technical requirements and implement assigned development tasks using appropriate tools and technologies.
• Utilize Python or similar tools to support data preparation, automation, and efficiency improvements as appropriate.

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.

Qualifications:

Minimum Qualifications:

• Bachelor's 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 bachelor's degree on a year-for-year 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 (Master's or Doctorate) in a field directly related to the work assignment may be substituted for experience on a year-for-year basis.
• Experience using SQL and business intelligence / analytics tools (e.g., Power BI, Tableau, or similar).

Preferred Qualifications:

• Master's 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 multi-dimensional 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... [abbreviated for brevity, full list in text]

How to Apply: For full consideration, please submit the following document(s): 1. A letter of interest... 2. Curriculum vitae / Resume 3. Three to five professional references...

Questions should be directed to: Sean McBride, Sean.M.McBride@cuanschutz.edu

Screening of Applications Begins: April 17, 2026

Anticipated Pay Range: $70,889 - $90,171