POSITION SUMMARY:
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.
DUTIES and RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
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.
QUALIFICATIONS:The requirements listed below are representative of the knowledge, skill, and/or ability required.
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.
EDUCATION and/or EXPERIENCE REQUIREMENTS:
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.
CERTIFICATION REQUIREMENTS:
None Required.
SUPERVISORY RESPONSIBILITIES:
No direct supervisory responsibilities.
PHYSICAL DEMANDS:
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.
WORKING ENVIRONMENT:
The work environment characteristics are representative of those an employee encounters while performing the essential functions of the job.
ADDITIONAL INFORMATION:
None.