Job ID :
Company :
DC Government
Location :
Type :
Duration :
12 months
Status :
Openings :
Posted :
20 Nov 2012
Job Seekers, Please send resumes to
Short Description:


PeopleSoft Data Analyst for the DCRB Data Modernization Program


Complete Description:

HCM ApSo team is seeking PeopleSoft Functional SME for the DCRB Data Modernization Program.


PeopleSoft HCM is the current District wide HCM platform and provides a web-enabled, integrated platform for the District's HR/Payroll needs.


The objective of this project is to reclaim service and fiscal history for current or separated members of the retirement system comprised of Firefighters, Police Officers, and Teachers by using current and yet to be developed tools in the District’s PeopleSoft system.


Historical data available from legacy systems, paper personnel files, and scanned documents will be loaded into the current PeopleSoft environment where it will then be analyzed and corrected via an OCTO approved portal.


For DCRB’s continued use, OCTO will provide DCRB a read only copy of the PeopleSoft production environment that will be refreshed on a nightly basis. This will allow DCRB to begin querying and analyzing data to improve data quality.


DCRB will be the project manager partnering with OCTO, and will start working on a high-level project plan, stakeholder expectations, resource and cost estimation, and funding details.


The following are a number of requirements and tasks that the contractor must perform as the PeopleSoft Data Analyst as a part of the scope of work:


General Purpose

Provide expertise to acquire, manage, manipulate, and analyze HR Benefits, Payroll, and Retirement related data and report results.


•             Analyze reports of missing data, data duplicates, or other errors to help conduct Root Cause Analysis on HR and Payroll data;

•             Analyze available scanned and paper files from HR and Payroll departments to determine whether they can be used as sources of missing data;

•             Identify problematic areas and conduct research to determine the best course of action to correct the data;

•             Analyze and solve issues with current and planned systems as they relate to the integration and management of HR and Payroll historical data;

•             Analyze errors in existing data to provide ongoing appropriate data cleansing project communications and regularly produced status reports;

•             Monitor for timely and accurate completion of select HR and Payroll data elements;

•             Help identify, analyze, and interpret trends or patterns in complex data sets

•             Acquire and abstract necessary data from existing internal or external data sources

•             Help develop and implement data collection systems (such as data portals) and other strategies that optimize efficiency and data quality

•             Perform data entry, either manually or using scanning technology, when needed or required

•             In collaboration with others, help interpret data and develop recommendations based on findings

•             Help develop graphs, reports, and presentations of project results

•             Perform basic statistical analyses for projects and reports

•             Generate routine and ad hoc reports



Functional/Data analyst experience

Required 8 Years 3 - Expert


Technical expertise regarding data models and database design

Required 3 Years 3 - Expert


Proficient in MS Word, Excel, Access, and PowerPoint

Required 8 Years 3 - Expert


Experience in analyzing large datasets

Required 3 Years 2 - Proficient


Familiarity with PeopleSoft HCM solution

Required 2 Years 2 - Proficient


Experience with state, local or federal government HR practices

Required 4 Years 2 - Proficient


SDLC experience

Required 8 Years 2 - Proficient


Project Management experience

Required 3 Years 2 - Proficient


Overall IT experience

Required 8 Years 3 - Expert


Requirements Gathering and Business Metrics Development

Required 3 Years 3 - Expert


Bachelor's in Information Management, Engineering or related fields



Question 1

If requested, will candidate be able to come for an in-person interview?


Question 2

Does the candidate have a Bachelor's in Information Management, Engineering or related field?