Financial Modeling & BI Analyst

Financial Modeling & BI Analyst (Open Rank)

Financial Modeling & BI Analyst responsible for building, maintaining, and supporting multi‑dimensional financial models in Anaplan for the School of Medicine and campus‑wide initiatives, as well as performing data analytics and engineering tasks to support business intelligence and financial planning.

• 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.
• (Principal Level) Operate as a subject matter expert in project management, end‑user requirement gathering, process improvement, and data analysis, modeling and visualization.
• (Principal Level) Influence campus or department decision making, processes and policies by providing expert consultation and data‑substantiated recommendations to leadership and stakeholders.

• Write and optimize SQL queries across enterprise platforms, including Oracle, MS SQL Server, and Snowflake, involving large relational joins, analytical functions (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.
• (Principal Level) Operates as a technical expert; write and optimize more complex SQL queries and ETL processes and flows.
• (Principal Level) Use expertise to provide comprehensive data analysis and translate complex findings into approachable insights for university leadership and stakeholders.

Hybrid – on campus three (3) days a week or more depending on business requirements.

• 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 per year (maximum accrual 352 hours)
• Sick Days: 15 per year (unlimited maximum accrual)
• Holiday Days: 15 per year
• Tuition Benefit:
  Employees have access to this benefit on all CU campuses
• ECO Pass:
  Reduced rate for RTD Bus and light rail service

• Bachelor’s degree from an accredited institution in Computer Science, Data Science, Information Technology, Business…