Financial Modeling & Planning Systems Senior Professional

Financial Modeling & Planning Systems Senior Professional

University of Colorado Anschutz Medical Campus

Department: Budget, Planning and Campus Strategy

Position #:  - Requisition #: 39546

Financial Modeling & Planning Systems Senior Professional – 80% Anaplan Model Builder and 20% Data Analytics & Engineering.

• Design, build, and maintain multi‑dimensional financial models in Anaplan, incorporating time, versions, scenarios, and organizational hierarchies.
• Recommend and implement process improvements to ensure data integrity, model performance, and readiness prior to publishing Anaplan models for the School of Medicine.
• Serve as 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.
• Write and optimize complex SQL queries across enterprise data platforms, including Oracle, MS SQL Server, and Snowflake, involving large relational joins, analytical functions, and performance tuning.
• Troubleshoot and support ETL processes, data flows, and system dependencies to ensure 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.

Hybrid – on campus at least 3 days a week or as required.

• Bachelor’s degree in Computer Science, Data Science, Information Technology, Business Administration, Finance, Mathematics, Statistics, or related field. Substitution: A combination of education and related experience may be substituted for a bachelor’s degree, year‑for‑year.
• Two (2) years of professional experience in Business Data Analytics, Financial Planning & Analysis, Enterprise Performance Management (EPM), or related analytical or systems role. Substitution: A master’s or doctorate 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).

• Master’s degree and/or equivalent experience in 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).
• 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.

• Proven ability to translate complex business questions into structured financial models, analyses, and decision‑ready insights.
• Working knowledge in Financial Planning & Analysis and Human Resources.
• Familiarity with best practices for…