Job Summary

We are seeking a highly analytical professional with strong problem-solving skills and an interest in financial systems, planning, and data analytics. The University will provide a structured development path that includes Anaplan training, certification support, mentorship, and exposure to enterprise planning initiatives.

The Financial Modeling & BI Analyst 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.

Key Responsibilities

Financial Model Building (Anaplan) - 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.

Data Analytics & Engineering - 20%

• Write and optimize SQL queries across enterprise data platforms, including Oracle, MS SQL Server, and Snowflake.
• Troubleshoot and support ETL processes, data flows, and system dependencies.

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.