] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → DATA INTEGRATION SPECIALIST III, BUDGET UNIT

Sorted by job title: A - C | D - H | I - Q | R - Z

Data Integration Specialist III, Budget Unit

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: Data Integration SpecIII CODE: 5006 SQ/OQ: Optimal Qualified
WORKING TITLE: Data Integration Specialist III, Budget Unit GRADE: 27 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: Under direction of the supervisor of the Budget Unit, oversees the daily technical activities of the unit as it relates to the new Oracle Cloud Budget Application and its interfaces. Position is responsible for monitoring, tracking and analyzing the functionality and effectiveness of the Budget Application (and its interfaces) and implementing appropriate upgrades and improvements to ensure optimal and continuous technical support to the Budget Unit in its daily operations, as well as providing pertinent information and status reports to unit/supervisor on all technical matters. Responsible for training, overseeing and supervising team members and their work as it relates to the utilization of the Budget Application, technology used in daily operations of the unit and associated projects. Ensures broad access to accurate and timely information using a fully integrated suite of business applications, including Oracle Cloud Budget Application System, ERP Financials and Lawson, as well as ensures integrity of data during all phases of integration and introduction of new systems/software. Work of this class requires the incumbent to independently analyze complex technical issues and provide swift resolutions, as well as quickly learn and oversee the integration/interfacing of new systems/software to ensure uninterrupted work of the unit. Leads technical innovation projects utilizing standard project management techniques such as identification of requirements, planning, management, process improvement, administration, and staffing; and leads the technical support of daily operations of the Budget Unit in areas including but not limited to budget development, financial monitoring, salary simulation and position loads. Oversees, develops, and documents system specifications and related process improvements Oversees software enhancement planning and implementation and/or full-scale upgrade of existing systems and develops test scripts to simulate live operations. Position is the system administrator for Oracle Cloud MCPS Budget Application and leads the maintenance of user access, hierarchies updates, and the technical operation support for the system, which requires vendor communications, liaising with contractors, system set-up, carrier/system interfaces, system upgrades and resolution of issues.
MINIMUM QUALIFICATION STANDARDS
KNOWLEDGE, SKILLS, AND ABILITIES: Thorough knowledge of Lawson (V10 or higher), Crystal Reports, Kronos, MS Access, Oracle Discoverer. Knowledge of Oracle Cloud ERP, Budget Application and ability to quickly become a technical expert on Oracle Budget Application, as well as learn new software and processes as they become available. Thorough knowledge of technical functions, set-up, interfacing and maintenance of applications/software and proven ability to successfully identify and resolve technical issues. Considerable knowledge of the organization, functions and operations of Montgomery County Public Schools, or a similarly complex organization. Knowledge of technical applications and solutions that will assist the Budget Unit in daily operations. Must have a basic knowledge of budget processes and be able to quickly learn all MCPS budget processes and the unit¿s needs to successfully integrate and utilize new software, identify and resolve deficiencies and clearly communicate this information to the unit and vendors. Must be highly skilled in technical, innovative problem-solving. Demonstrated ability to train, coach, supervise and lead other team members. Ability to prioritize and manage several complex projects simultaneously while working under pressure to meet deadlines. Energetic and self-motivated work in quick paced environment. Excellent communication, both written and oral, and interpersonal skills are essential. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).
EDUCATION, TRAINING, AND EXPERIENCE: Bachelor's degree required. College course work in computer related fields. Three to five years of progressively more responsible experience in user support and technology administration. Other combinations of applicable education, training, and experience equivalent to a Bachelor's degree, which provides the knowledge, skills, and abilities necessary to perform effectively in the position, may be considered.. Experienced in successfully overseeing the implementation of new software/applications and providing ongoing support, technical expertise and problem-solving with the integration of new software/applications and changing systems. Five or more years of experience working in the Oracle environment, Lawson environment using Crystal Reports, Kronos, MS Access, Oracle Discoverer or any other reporting software required. Experience/knowledge of Hyperion budgeting tool highly desirable. Experience using programming languages, tools, and database management software including Microsoft Office (MS Access, MS Excel, and PowerPoint), HTML, SQL, Visio. Project and team management/leadership skills and experience required. Experience in creating specific reporting criteria, executing reports and evaluating data for integrity and accuracy. Some experience in human resources, budgeting, financial and payroll systems required, extensive experience highly desirable.. Other applicable training and experience, which provide the knowledge, abilities, and skills necessary to perform effectively in the position, will be considered.
CERTIFICATE AND LICENSE REQUIREMENTS: Microsoft Certified Architect Program preferred.
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) Required to work at a computer workstation for sustained periods of time.
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Ability to work non-compensated overtime, especially during peak periods and when urgent work requirements exist.
OVERTIME ELIGIBLE: No

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

(The duties listed are typical examples of the work performed by this job classification. This is not an exhaustive statement of duties, responsibilities or requirements and does not limit the assignment of additional related duties for the position. Not all duties assigned are included, nor are all duties listed performed in every office or every day.)
1. Leads the technical administration and operations of the Oracle Cloud Budget Application system including daily monitoring, trouble shooting, ad-hoc report creation, new implementations, and upgrades including directing the work of contractors.
2. Leads and oversees to completion, the integration, interfacing and continual successful operation of new software and applications.
3. As a technical expert and lead, identifies deficiencies in the operation of existing and new software/applications and clearly communicates to the unit and vendors the needs and optimal resolution for these deficiencies. Responsible for overseeing and ensuring successful execution of resolutions.
4. Serves as technical expert to resolve system issues quickly and support all unit staff with technical concerns and issues. Communicates to supervisor/unit concerns, resolutions and relevant technical issues to ensure unit awareness of pertinent situations and information.
5. Responsible for writing and rewriting criteria for reports over multiple applications/software, based on desired results; run and deliver reports; and ensure data integrity.
6. Serves as technical lead and collaborates with the team leader and budget specialists, maintains and updates the annual setups for the budget submission process.
7. Serves as technical lead and collaborates with the team leader and budget specialists, to oversee the load of the data from the Cloud ERP system and Lawson systems for budget preparation, financial monitoring, salary simulation, building/food service loads, and central office loads.
8. Serves as a project manager, responsible for the planning, execution, and implementation of new application segments/components, such as identifying gaps in the new Budget Application and works with the contractor to troubleshoot and resolve the gaps. Responsible for ensuring gaps are resolved.
9. Serves as technical lead and collaborates with the team leader, budget specialists and contractors in testing, enhancing and troubleshooting the MCPS Budget Application system and the interfaces with the ERP Financials System and Lawson.
10. Ensures project schedules are developed, timelines are met, and implementation is completed in a manner that supports project goals and objectives. This includes tracking and supporting progress of other team members.
11. Serves as a technical expert and resource and provides programming and software support to Budget Unit staff.
12. Works closely with staff from the Office of Technology Innovations in the development and maintenance of system enhancements and represents functional users in clear definition of problems, requirements, and needs. Responsible for ensuring complete, timely and successful implementation of all upgrades.
13. Supervises the execution of the annual/bi-annual/monthly interface files necessary to maintain budget development, financial monitoring, salary simulation, and internal MCPS systems.
14. Designs, develops, modifies and implements, various Budget databases and data files, as requested.
15. Develops and executes appropriate test scripts to simulate a live environment and maintains a catalog of all developed test scripts.
16. Observes and evaluates daily operations to identify process improvement and learning opportunities and initiates improvements and staff training as appropriate.
17. Responsible for meeting facilitation (following effective meeting guidelines), documentation, development of feasible solutions, and problem resolution related to process improvement and data integrity and leads the implementation of changes/improvements as appropriate.
18. Develops and delivers technical training programs of various formats for Budget Unit staff and departmental users including preparation of training materials.
19. Assists with reporting requests from BOE, superintendent of schools, executive staff, county council, and other stakeholders, as directed by the supervisor. Prepares budgetary information reports using Smart View, Excel, Access, and other appropriate software packages during high peak workforce reporting requests.
20. Maintains expert knowledge in Microsoft Office, SQL, Oracle Budget Application, and ERP reporting as well as future technical installations.
21. Maintains system tables and other system set up requirements including but not limited to the annual updates related to budgetary and benefit rates, etc. to ensure deadlines are met.
22. As the technical expert, assists in the administrative support to Help Desk tickets from MCPS Budget Application end users.
23. Assists the supervisor and team leader, in collaboration with budget specialists, in the development and periodic reviews of process and procedure manuals for various functional units in the Budget Unit and provides updates where appropriate.
24. Participates in meetings to plan, test, and implement changes to the ERP and Budget Application system as-needed.
25. Serves as a member of the Budget Unit functional ownership teams.
26. Performs related duties consistent with the scope and intent of the position.

Class Established: 9/2021
Date(s) Revised:
Last Reviewed:

This description may be changed at any time.