Job Title Senior Business Intelligence Analyst

Location Upper Marlboro, MD, US

Organization Name Budget and Management Services

Department Description

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.

Brief Description

This is an ASASP Unit III Table 900 position Grade 30

Salary Range: $76,214 - $147,851

Closing Date: December 2, 2022

Detailed Description

DUTIES & 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.

Job Requirements

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.

Additional Details

Direct Deposit is expected as a condition of new hire employment.

As a condition of employment, all applicants for employment must be qualified to work in the United States without sponsorship by PGCPS. If you are not work-authorized and would require PGCPS to sponsor you for a work visa you will not be considered for employment.

How To Apply

To submit an application online select apply.

Please provide three (3) current professional references on resume.

Please complete ALL sections and provide applicable details to ensure full consideration. If you need assistance with submitting your application online, please contact the HR Employee Services Center at 301-780-2191.

Appropriate accommodations for individuals with disabilities are available upon request.

Minimum Salary

Maximum Salary

Currency USD

Shift Work Preferences
Certified Teacher?
Certification Subject Areas

Amount of Travel

Work At Home

Skills

Skill Minimum Level Maximum Level Desirability
No results found.