] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → DATA INTEGRATION SPECIALIST II, EMPLOYEE AND RETIREE SERVICE CENTER

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

Data Integration Specialist II, Employee and Retiree Service Center

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: Data Integration SpecII CODE: 5005 SQ/OQ: Optimal Qualified
WORKING TITLE: Data Integration Specialist II, Employee and Retiree Service Center GRADE: 25 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: Under direction of the Director of Employee and Retiree Service Center (ERSC), assists the director in overseeing the daily technical activities of the unit. Ensures broad access to accurate and timely information using a fully integrated suite of business applications that include the Human Resources Information System (HRIS), and the Lifeworks Retirement System. Leads technical innovation projects utilizing standard project management techniques such as identification of requirements, planning, management, process improvement, administration, and staffing. Leads the technical support of daily operations of ERSC in the areas including but not limited to payroll, benefits, retirement, and absence management. Develops and delivers unified training of department users. Oversees, develops, and documents system specifications and related process improvements. Oversees software enhancement planning and implementation and/or full scale upgrade of existing systems develops and develops test scripts to simulate live operations. Position is the system administrator for (Lawson benefits module and Life Works) and the technical operation support for the benefits and retirement systems including vendor communications, system set-up, carrier/system interfaces, and resolution of issues.
MINIMUM QUALIFICATION STANDARDS
KNOWLEDGE, SKILLS, AND ABILITIES: Thorough knowledge of Lawson (V10 or higher) in Human Resource, Payroll, Absence Management and benefits. Knowledge of retirement management systems. Considerable knowledge of the organization, functions and operations of Montgomery County Public Schools, or a similarly complex organization. Thorough understanding of employee benefit, retirement, human resources, and payroll policies and functions. Knowledge of technical applications and solutions that will assist the ERSC in daily operations. Demonstrated ability to train, coach, supervise and lead other team members. Can effectively plan and set priorities. Ability to manage several complex projects simultaneously while working under pressure to meet deadlines. Energetic and self-motivated work in quick paced environment. Ability to learn new software and processes as they become available. Ability to plan and manage multiple tasks in a timely manner. Excellent communication and interpersonal skills. 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 from an accredited college or university in computer science, technology, information management systems, or related field is required. Five or more years experience working in the Lawson environment using Crystal Reports, Kronos, MS Access, Oracle Discoverer or any other reporting software required. 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 preferred. Other applicable training and experience, which provide the knowledge, abilities, and skills necessary to perform effectively in the position, will be considered. Extensive experience in human resources, benefits, retirement, or payroll highly desirable.
CERTIFICATE AND LICENSE REQUIREMENTS: None
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) None
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Bachelor's degree from an accredited college or university in computer science, technology, information management systems, or related field is required. Five or more years experience working in the Lawson environment using Crystal Reports, Kronos, MS Access, Oracle Discoverer or any other reporting software required. 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 preferred. Other applicable training and experience, which provide the knowledge, abilities, and skills necessary to perform effectively in the position, will be considered. Extensive experience in human resources, benefits, retirement, or payroll highly desirable.
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.)

Leads the technical administration and operations of the payroll, benefits and retirement systems including daily monitoring, trouble shooting, ad-hoc report creation, new implementations, and upgrades including directing the work of members of the technical team.

Collaborates with the Senior Specialist, Benefits, maintains and updates the annual setups and rates needed for annual benefits open
enrollment.

Leads the annual 1095-c reporting process.

Collaborates with the Senior Specialist, Retirement, in developing and entering pension rates into the HRIS after reading and interpreting the Aon Annual Review and Actuarial Valuation of the Employee Retirement and Pension Systems to accurately document the rate tables.

Collaborates with the Senior Specialist, Payroll, in testing, enhancing and troubleshooting the payroll, absence management and time reporting systems.

Responsible for the implementation and on-going operations of document imaging (Fortis) within ERSC.

Serves as a project manager, responsible for the planning, execution, and implementation of new application segments/components.
Ensures project schedules are developed, timelines are met, and implementation is completed in a manner that supports project goals and objectives.

Compiles data from PC databases to create reports, graphs, and charts related to Government Accounting Standards Board (GASB), Office of Legislative Oversight, Audit requests, AON census requests, or other benefit/retirement related functions.

Provides programming and software support to ERSC staff.

Works closely with staff from the Office of the Chief Technology Officer in the development and maintenance of system enhancements and represents functional users in clear definition of problems, requirements, and needs.

Supervises the execution of the monthly interface files necessary to maintain benefit and retirement data with benefit vendors, agencies, and internal MCPS systems.

Designs, develops, and modifies, various ERSC databases and data files including directing the work of other members of the technical team, as requested.

Assists the director in the supervision of the ERSC technology team, and the Data Integration Specialist I (benefits/retirement) positions.

Develops appropriate test scripts to simulate a live environment and maintains a catalog of all developed test scripts.

Observes and evaluates daily operations to identify and address training and process improvement opportunities. Responsible for meeting facilitation, documentation, development of feasible solutions, and problem resolution related to process improvement and data integrity following effective meeting guidelines.

Develops and delivers technical training programs of various formats for ERSC staff and departmental users including preparation of training materials.

Provides direction to the Data Integration Specialist I related to benefits/retirement and work force reporting in support of budget process, labor contract negotiations, mandated requirements and other information requests.
.
Assists the director with workforce reporting requests and surveys.

Prepares workforce information reports using Oracle Discoverer, Excel, Access, and other appropriate software packages during high peak workforce reporting requests.

Maintains expert knowledge in Microsoft Office, SQL, Oracle Discoverer, the Human Resource Information System (HRIS), Lifeworks (LW), and Fortis as well as future technical installations.

Maintains system tables and other system set up requirements including but not limited to the annual upgrade of benefit and pension rates, active and retiree benefit plan enhancements/modifications, etc. to ensure deadlines are met.

Assists in the administrative support to Call Center staff, Transaction and Functional Specialists.

Assists the director, in collaboration with functional specialists, in the development and periodic reviews of process and procedure manuals for various functional units in ERSC and provides updates where appropriate.

Participates in meetings to plan, test, and implement changes to the Lawson HRIS system as-needed.

Serves as a member of the ERSC Web and the HRIS functional ownership teams.

Performs related duties consistent with the scope and intent of the position.

Class Established: 7/2011
Date(s) Revised: 5/2015, 10/2017
Last Reviewed:

This description may be changed at any time.