Under the direction of the Supervising Budget Analyst, the Senior Business Intelligence Analyst will perform highly responsible duties in the planning and preparation of the annual budget, and in the analysis and control of the annual budget. The incumbent of this position will oversee all aspects of the administration of the district’s budget planning and resource allocation system, including the responsibilities associated with an identity domain manager and budget planning administrator. The Senior Business Intelligence Analyst will provide senior analytical work in the preparation and management of the annual budget, regular forecast cycles, revenue forecasting and reconciliations, as well as lead in complex budgetary and management analysis projects and will be responsible for the maintenance of systems and processes in support of these objectives.
Implements and administers the budget planning and resource allocation system; assumes the role of the Identity Domain Manager and administrator in both production and non-production environments;
Prepares budget planning system for all budget cycles, monthly actuals and year-end actuals including setting up scenarios, versions and data copies; extracts budget, financial and non-financial data from source systems to the budget planning system and from the budget planning system to Oracle Enterprise Business Suite and back to source systems;
Assists with the management of the financial forecast processes, as well as providing monthly financial analyses, reporting and variance analysis; develops, maintains and updates existing financial and personnel reports from Oracle Enterprise Business Suite and budget planning and resource allocation system;
Administers and maintains the budget planning and resource allocation system security for all users, including user roles and dimension security; responsible for the maintenance related to security for all users;
Serves as the point of contact for the vendor and addressing vendor communications, as well as the point of contact for users in troubleshooting production issues; responsible for monitoring and the timely close of all service requests, and performs data analysis and independent research to resolve issues;
Performs testing for the budget planning and resource allocation system production issues, monthly updates, upgrades, functionality enhancements and new implementation; conducts User Acceptance testing for functionality enhancements as required;
Integrates and validates data from source systems (i.e., Oracle, School Max, Data Warehouse) to the budget planning and resource allocation system; monitors the automated daily back up of the system and restores system from a backup as needed;
Assists with developing, updating and maintaining system documentation and training materials; conducts training for new users, as well as training for existing users on new functionality;
Maintains data mapping tables, metadata and tree/hierarchy updates, and performs data validations to ensure accuracy of data and mapping; creates, maintains and updates business rules, calculation scripts, web and smart forms in EPBCS;
Participates in the development and maintenance of business models for budgeting and forecasting; oversees a variety of technical work in the preparation and review of budgets and forecasts for all departments and assists with ad hoc and routine financial tasks and budgetary reports;
Works with the Supervising Budget Analyst and other key personnel in the identification of school system budgetary needs and methods of fulfilling such needs;
Provides data reflecting financial standing, including current, historical and budget-to-actual information; responsible for internal and external (county, state and federal) reporting that is completed by Budget and Management Services; and
Performs other duties as assigned.
Demonstrated experience with data analysis, data modeling, data discovery and data mapping;
Knowledge of Oracle Enterprise Resource Planning (ERP) and Enterprise Planning and Budget Cloud Service (EPBCS); experience with system enhancements, reporting and integration of systems;
Knowledge of project management and large scale system implementation;
Experience supporting and working with cross-functional teams;
Considerable knowledge of governmental budgeting methods, and the operational relationships between the budgeting, accounting and data processing functions;
Must possess excellent attention to detail and strong analytical and organizational skills;
Ability to develop, implement and maintain a highly complex reporting system for budgetary data and participate in the collection and analysis of information as it relates to budgetary planning; and
Must possess good interpersonal and communication skills to clearly and concisely communicate with all levels of personnel in the organization.
Bachelor’s degree from an accredited college or university in business, finance or a related field required. A minimum of five (5) years of increasingly responsible work experience with data analytics and/or business intelligence or serving as a budget application database administrator.
None Required.
No direct supervisory responsibilities.
The physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to stand, talk, hear, walk, sit, and use fingers, tools or controls. The employee is occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl. Specific vision abilities required by this job include close vision such as to read handwritten or typed material, the ability to adjust focus, and depth perception. While performing the duties of this job, the employee may occasionally push or lift up to 25 lbs.
The work environment characteristics are representative of those an employee encounters while performing the essential functions of the job.
None.
