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 Lead Financial Modeling & BI Analyst position represents an exciting opportunity to develop Anaplan models and consulting support to the Budget, Planning, and Campus Strategy department, and additional ad hoc requests from the Executive Vice Chancellor's Office. The position will act as an Anaplan subject matter expert and will focus on creating and supporting complex models that incorporate data from Oracle PeopleSoft HCM and FIN. These insights will inform planning, policy decisions, and operational improvements. This position will also respond to recurring and ad hoc requests for information about projects overseen by the offices mentioned above.

Key Responsibilities

• Develop processes and workflows to ensure data and performance quality prior to publishing Anaplan models.
• Act as a campus-wide subject matter expert for Anaplan Business Modeling.
• Manage 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.
• Deep understanding and troubleshooting of ETL processes, data flow, and dependencies.
• Write and optimize SQL queries across enterprise data platforms.
• Present data that includes quantitative and qualitative information about the organization's key mission areas.
• Analyze requirements and technical specifications and implement assigned development tasks using various web technologies.
• Liaise with other campus units.
• Consult on strategic decisions to best utilize or adapt current systems when embarking on change management efforts.