Lead Financial Modeling & BI Analyst

Lead Financial Modeling & BI Analyst – University of Colorado Anschutz

Department:
Budget, Planning and Campus Strategy

Lead financial modeling and BI analyst to develop, maintain, and improve Anaplan models and data analytics solutions for campus financial planning and operations. Act as campus-wide subject‑matter expert and support strategic decision making through data quality, modeling, and reporting.

• Develop processes and workflows to ensure data and performance quality prior to publishing Anaplan models.
• Conceive and build innovative Anaplan business models that integrate multiple data sources for budgeting, forecasting, and reporting.
• Maintain current portfolio of Anaplan models:
  Campus All Funds Budgeting, Salary Setting, Mid‑Year Salary Setting, Tuition Revenue, and Administration models.
• Serve as point person for the School of Medicine FTE Alignment model implementation in partnership with Tru Consulting.
• Translate existing solutions, spreadsheets, and business problems into sophisticated Anaplan multi‑dimensional models.
• Conduct testing and troubleshooting to identify and resolve issues in Anaplan models.
• Stay current with Anaplan updates and enhancements, incorporating new features into existing models as appropriate.
• Troubleshoot ETL processes, data flow, and dependencies to validate data quality.
• Write and optimize SQL queries on Oracle, MS SQL Server, and Snowflake across large relational joins and analytical functions.
• Present quantitative and qualitative data to senior leadership to influence operations, processes, and programs.
• Analyze requirements and implement development tasks using web technologies.
• Collaborate with campus units to develop sustainable systems, mechanisms, and procedures for tracking institutional data.
• Consult on strategic decisions to best utilize or adapt current systems during change management efforts.

Hybrid – campus attendance as required (3+ days per week, subject to business needs).

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

• Bachelor’s degree in Computer Science, Information Technology, Business Administration, Mathematics, Statistics, Library Science, or Data Science.
• 4–6 years of professional experience in Business Data Analytics, Financial Planning, or EPM administration; includes at least two years with Anaplan modeling and development.
• Substitution:
  Education can be substituted for experience on a year‑for‑year basis.
• Substitution:
  Advanced degree (Master’s or Doctorate) may be substituted for experience on a year‑for‑year basis.

• Master’s degree or equivalent experience in a relevant field.
• Certified Anaplan Builder.
• Experience with Oracle People Soft.
• Experience creating solution tools utilizing multiple data sources.

• Financial Planning & Analysis and Human Resources knowledge.
• Best practices for data integrity, analysis, visualization, and security.
• Strong understanding of data structures, relationships, and manipulation.
• Self‑sufficient in translating business requirements into technology solutions.
• Motivated problem solver, intellectually curious, and eager to learn new technologies.
• Strong business analytical skills and aptitude for multi‑dimensional modeling tools.
• Advanced analytical and research skills across diverse data sources.
• Team collaboration, consensus building, and information exchange.
• Understanding of database basics and data flow.
• Creative problem solver with passion for identifying needs and proposing solutions.
• Ability to manage workload autonomously and prioritize tasks under tight deadlines.
• Rapid learning of new software and systems.
• Strong verbal, written, and presentation skills.

• Hybrid work environment; campus attendance 3 days per week or more as business requires.
• No work‑visa sponsorship; applicants must be legally authorized to work in the United States.
• If not certified in Anaplan at hire, certification path to Anaplan Solution Architect available; costs may be covered.

The University of Colorado is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. The University is committed to a workplace where all individuals are treated with respect and dignity, and encourages individuals from all backgrounds to apply.