Lead Financial Modeling & BI Analyst

About the role

The University of Colorado Anschutz Department: Budget, Planning and Campus Strategy seeks a Lead Financial Modeling & BI Analyst to represent 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.

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, this includes devising innovative and creative ways of building Anaplan business models that integrate different data sources together in meaningful ways to support financial planning, forecasting, and reporting processes.
• 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, incorporating new features into existing models as appropriate.
• Deep understanding and troubleshooting of ETL processes, data flow, and dependencies.
• Ability to validate to ensure data quality.
• Write and optimize SQL queries across enterprise data platforms, including Oracle, MS SQL Server, and Snowflake, involving large relational joins, analytical functions (e.g., window functions, CTEs, subqueries), and performance tuning.
• Present data that includes quantitative and qualitative information about the organization’s key mission areas and assist senior leadership in interpreting and using the data to influence changes to operations, processes, and/or programs.
• Analyze requirements and technical specifications and implement assigned development tasks using various web technologies.
• Liaise with other campus units, working collaboratively with campus teams to develop sustainable systems, mechanisms, and procedures for tracking institutional data toward strategic goals.
• Consult on strategic decisions to best utilize or adapt current systems when embarking on change management efforts.

Qualifications

• Bachelor’s degree from an accredited institution in Computer Science, Information Technology, Business Administration, Mathematics, Statistics, Library Science, or Data Science.
• 4-6 years of professional, relevant Business Data Analytics, Financial Planning, or EPM administration experience, which includes two years of experience with Anaplan modeling and developing.
• Master’s degree and/or equivalent experience in a relevant subject area, such as Computer Science, Information Technology, Business Administration, Mathematics, Statistics, Library Science, or Data Science.

Skills

• Working knowledge in Financial Planning & Analysis and Human Resources.
• Familiarity with best practices for data integrity, analysis, visualization, and security.
• Strong understanding of data structures, relationships and data manipulation.
• Ability to be self-sufficient understanding and documenting business requirements then translating them into a technology solution.
• Highly motivated problem solver that is a tenacious learner, intellectually curious, and excited about learning new technologies.
• Strong business analytical skills and a strong aptitude for multi-dimensional modeling tools.
• Advanced analytical and research skills, as demonstrated by the ability to develop, assess, and blend information from a wide variety of data sources.
• Demonstrated ability to work as part of a team in a collaborative environment, build consensus and promote the exchange of information.
• Ability to understand the basic workings of databases and data flow.
• Creative problem-solver with a passion for identifying needs and proposing solutions.
• Ability to manage workload autonomously, work with many constituents, juggle multiple competing tasks, and set priorities to achieve results.
• Ability to work under tight/changing deadlines.
• Ability to learn new software and systems quickly and independently.
• Strong verbal, written communication, and presentation skills.

Benefits

• Multiple medical plan options.
• Multiple dental plan options.
• Disability, life, and vision insurance.
• Retirement 401(a) Plan with employer contribution of 10% of gross pay.
• Accrued vacation, sick, and holiday days.
• Reduced-rate RTD bus and light rail service.

Pay

The starting salary range (or hiring range) for this position has been established as $89,092 - $119,383.

Schedule

This position is currently eligible for a hybrid work environment coming to campus 3 days a week or more depending on business requirements. A work schedule which consists of on campus and as-needed for in-person meetings may be implemented at some point.