This position is located in the Executive Office of the President, Office of Administration, Office of the Chief Administrative Officer, HR Systems and Processing Division. The incumbent will serve as an Analytics Manager, overseeing and maintaining internal database files, tables, codes, backup files, integrity, and security. The incumbent will also install, implement, modify, and upgrade software and applications to meet changing business and technology.
Summary
This position is located in the Executive Office of the President, Office of Administration, Office of the Chief Administrative Officer, HR Systems and Processing Division. The incumbent will serve as an Analytics Manager, overseeing and maintaining internal database files, tables, codes, backup files, integrity, and security. The incumbent will also install, implement, modify, and upgrade software and applications to meet changing business and technology.
Current Permanent Federal Employees in the Competitive Service, CTAP/ICTAP/RPL, VEOA Eligible and Reinstatement Eligible; OPM Interchange Agreement; or Miscellaneous Authorities not Regulated by US Office of Personal Management.
As a Human Resources Specialist (Information Systems), GS-0201-13, your typical work assignments may include the following:
Serves as Human Resources Information Specialist, performing the functions and duties as an Analytics Manager.
Analyzes and manages complex HR automated information systems, including but not limited to Department of Defense (DOD) Defense Civilian Personnel Data System (DCPDS), Defense Civilian Payroll System (DCPS) and the Department of Navy's Standard Labor Data Collection and Distribution Application (SLDCADA).
Coordinates all HR systems specific report design and development requirements with Information Technology staff to ensure optimum performance of all HR information systems.
Recommends and initiates system changes to automate EOP-wide reporting requirements.
Develops reports using Business Objects, Crystal reports, data warehouse, Oracle OBIEE, Data migration and mapping, Extract Transform and Load (ETL) technologies, and other ERP/cloud reporting products.
Serves as a primary point of contact for various reports requests from various components of EOP, Audit related requests, and to leadership to make informed decision.
Develops and implements information security protocols and ensures overall compliance of HR information systems with all information security laws, rules, regulations, policies, and procedures.
Selective Service registration if a male born after December 31, 1959.
Subject to pre-employment and random drug tests.
Direct Deposit is required.
RELOCATION EXPENSES WILL NOT BE PAID
Suitability for Federal employment
May be required to successfully complete a probationary period
Only experience and education obtained by the closing date of this announcement will be considered.
Status candidates must meet time-in-grade requirements (52 weeks at the next lower grade level).
Qualifications
MINIMUM QUALIFICATION REQUIREMENTS: All applicants must meet the qualification requirements outlined below to be considered minimally qualified for this position. The qualification requirements are in accordance with the OPM Qualification Standards.
ALL QUALIFICATIONS MUST BE MET BY THE CLOSING DATE OF THIS ANNOUNCEMENT.
TIME-IN-GRADE REQUIREMENTS: Applicants possess one full year (52 weeks) of specialized experience at or equivalent to the next lower grade level or pay band in Federal service or equivalent experience in the private or public sector.
SPECIALIZED EXPERIENCE: Applicants must have a minimum of one full year (52 weeks) of specialized experience at a level of difficulty and responsibility comparable to the GS-12 or comparable pay band in the Federal service or equivalent experience in the private sector. You must possess experience in at least two of the following four areas:
1) Providing guidance, technical and troubleshooting support to end users regarding human resources (HR) information systems and reporting tools related to personnel, payroll, Time & Attendance, and benefits processing using two or more of the following: Defense Civilian Personnel Data System (DCPDS), Defense Civilian Payroll System (DCPS), Standard Labor Data Collection and Distribution Application (SLDCADA), Structured Query Language (SQL), Business Objects, and/or Jira;
2) Performing HR information systems review through developing quality control criteria, error control criteria, profile reports, and other system queries to ensure accuracy, control, and reliability of data;
3) Developing system queries to extract data for reporting from a relational database management system 5 (RDBMS);
4) Using coding and computer programming knowledge in SQL, and other programming languages, such as Microsoft Excel or other analytic tools, to automate processes.
Experience refers to paid and unpaid experience, including volunteer work done through National Service program (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
The following experiences are highly desirable:
Expertise in database management system like Oracle SQL Server and MS Access.
Knowledge and understanding of SLDCADA, a T&A system database and its integration with other downstream payroll and HR systems.
Ability to understand, analyze and solve data and integration issues with Oracle financial system, DCPS payroll system, and DCPDS HR system.
Well-versed in building and running custom queries in Business Objects and Cognos and Power Builder to support various agency needs.
Thorough understanding of Federal HR system and EOP specific data and processing rules.
Possession of Security Plus certification.
Education
Substitution of education may not be used in lieu of specialized experience for this grade level.
Additional information
A tentative offer of employment will be rescinded if the selectee fails to meet the pre-employment requirements.
Veterans Employment Opportunity Act (VEOA): To be eligible for a VEOA appointment under Merit Promotion procedures, you must be a preference eligible or a Veteran separated after 3 years or more of continuous active service performed under honorable conditions.
Active Duty Military Members MAY apply under this announcement due to the Veterans Opportunity to Work (VOW) Act. You must submit a certification of expected discharge or release from active duty under honorable conditions along with your application for Federal employment. A certification is a document from the armed forces that certifies the service member is expected to be discharged or released from active duty service in the armed forces under honorable conditions not later than 120 days from the date of application. If selected, appointment eligibility requirements must be met prior to the effective date of appointment.
Interagency Career Transition Assistance Programs & Career Transition Assistance Programs: These programs apply to employees who have been involuntarily separated from a Federal service position within the competitive service or Federal service employees whose positions have been deemed surplus or no longer needed. To receive selection priority for this position, you must: (1) meet CTAP or ICTAP eligibility criteria; (2) be rated well-qualified for the position with a score of 85 or above; and, (3) submit the appropriate documentation to support your CTAP or ICTAP eligibility. For more information visit: http://www.opm.gov/rif/employee_guides/career_transition.asp. For more information about ICTAP eligibility please review the following link: https://www.usajobs.gov/Help/working-in-government/unique-hiring-paths/federal-employees/ictap/
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
How you will be evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
Once the announcement has closed, your resume and supporting documentation will be used to determine if you meet the qualifications listed on this announcement. If you are minimally qualified, your resume and supporting documentation will be compared to your responses on the assessment questionnaire to determine your level of experience. If you rate yourself higher than is supported by your application package, your responses may be adjusted and/or you may be excluded from consideration for this position. If you are found to be among the top qualified candidates, you will be referred to the selecting official for employment consideration.
Your resume must include detailed information as it relates to the responsibilities and specialized experience for this position. Evidence of copying and pasting directly from the vacancy announcement without clearly documenting supplemental information to describe your experience will result in an ineligible rating. This will prevent you from receiving further consideration.
Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics):
Data Management, HR Information Systems, and Oral Communication
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
To apply for this position, you must submit a complete Application Package which includes:
1. Your résumé showing work schedule, hours worked per week, dates of employment and duties performed
2. Other supporting documents:
Cover Letter, optional
College transcript(s), if the position has an education requirement or if you are utilizing education as part of your qualifications.
Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service). Please do not submit an Award SF-50 as it does not identify all the required information needed for eligibility verification.
Most recent Performance Appraisal, if applicable
DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities. DD-214 must be a Member 4 or Service 2 copy which reflects the type of discharge/character of service.
Noncompetitive appointment authority documentation, if applicable
Career Transition Assistant Program/Interagency Career Transition Assistance Program Documentation, if applicable (e.g. Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must submit a complete Application Package which includes:
1. Your resume must thoroughly describe how your skills and experiences align to the criteria defined in the "Qualifications" section of this announcement and it must support your responses to the assessment questionnaire. We cannot assume you have performed the necessary experience required for this position regardless of your employment history, titles of positions held, series, grade, or academic career. To ensure all of the essential information is in your resume, we encourage you to use the USAJOBS online Resume Builder.
If you choose to use your own resume, curriculum vitae, or any other written form you choose, then you must ensure it contains all of the required information and you organize it so we can associate the following information for each experience/position:
Job title
Name of employer
Beginning and ending dates of employment (month/day/year format)
Hours worked per week. We will assume full-time unless otherwise stated. We will prorate part-time employment in crediting experience.
Detailed description of job duties for each job held, accomplishments, related skills, and responsibilities to include any supervisory/managerial responsibilities and number of staff supervised (if applicable)
Your resume must show the series and grade or equivalent for all federal positions you have held (if a federal position).
2. A complete Assessment Questionnaire
3. Other supporting documents to be submitted with application:
DD214: Veterans' Preference Documentation, if applicable, a DD-214 Member 4 copy, which shows type of discharge. If still active, provide an official Statement of Service. Any other documentation such as VA letter documenting disability, SF-15, and any other required supporting documentation based your veterans' preference claim.
SF-50: Federal applicants must submit an SF-50 (Notification of Personnel Action) that shows your most recent Promotion, Within Rate Increase (WRI/WGI), or Appointment/Conversion (if applying as a current or former Federal Employee) showing you are/were in the competitive service and the highest grade or promotion potential held. Do not use Award actions. If you are an EOP employee you may obtain a copy of your SF-50 from OPF or eOPF. If you have separated from Federal Government employment, you may obtain a copy of your SF-50 via: National Personnel Records Center, Annex, 1411 Boulder Boulevard, Valmeyer, IL, 62295; FAX (618) 935-3014; Email rm.communications@nara.gov; or visit the https://www.archives.gov/personnel-records-center/new-nprc.
Peace Corps volunteers must submit a copy of your "Description of Service (DOS)" in lieu of the SF-50. If you do not have one you should email the Peace Corps Office of Volunteer and PSC Financial Services at certify@peacecorps.gov.
If you are currently serving in a pay banded position, please include a copy of your pay band chart with your application.
College transcripts (if the position has a positive education requirement, or you are qualifying on the basis of education).
Office of Administration
725 17th Street
Washington, DC 20503
US
Next steps
Once your online application is submitted you will receive a confirmation notification by email. Your application will be evaluated by the Human Resources Office to determine your eligibility for the position. After the evaluation is complete, you will receive another notification regarding the status of your application.
After a tentative job offer, we will conduct a security background investigation and drug screening. If the drug screening is negative and security background is cleared, then a formal job offer will be extended to candidate.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
To apply for this position, you must submit a complete Application Package which includes:
1. Your résumé showing work schedule, hours worked per week, dates of employment and duties performed
2. Other supporting documents:
Cover Letter, optional
College transcript(s), if the position has an education requirement or if you are utilizing education as part of your qualifications.
Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service). Please do not submit an Award SF-50 as it does not identify all the required information needed for eligibility verification.
Most recent Performance Appraisal, if applicable
DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities. DD-214 must be a Member 4 or Service 2 copy which reflects the type of discharge/character of service.
Noncompetitive appointment authority documentation, if applicable
Career Transition Assistant Program/Interagency Career Transition Assistance Program Documentation, if applicable (e.g. Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must submit a complete Application Package which includes:
1. Your resume must thoroughly describe how your skills and experiences align to the criteria defined in the "Qualifications" section of this announcement and it must support your responses to the assessment questionnaire. We cannot assume you have performed the necessary experience required for this position regardless of your employment history, titles of positions held, series, grade, or academic career. To ensure all of the essential information is in your resume, we encourage you to use the USAJOBS online Resume Builder.
If you choose to use your own resume, curriculum vitae, or any other written form you choose, then you must ensure it contains all of the required information and you organize it so we can associate the following information for each experience/position:
Job title
Name of employer
Beginning and ending dates of employment (month/day/year format)
Hours worked per week. We will assume full-time unless otherwise stated. We will prorate part-time employment in crediting experience.
Detailed description of job duties for each job held, accomplishments, related skills, and responsibilities to include any supervisory/managerial responsibilities and number of staff supervised (if applicable)
Your resume must show the series and grade or equivalent for all federal positions you have held (if a federal position).
2. A complete Assessment Questionnaire
3. Other supporting documents to be submitted with application:
DD214: Veterans' Preference Documentation, if applicable, a DD-214 Member 4 copy, which shows type of discharge. If still active, provide an official Statement of Service. Any other documentation such as VA letter documenting disability, SF-15, and any other required supporting documentation based your veterans' preference claim.
SF-50: Federal applicants must submit an SF-50 (Notification of Personnel Action) that shows your most recent Promotion, Within Rate Increase (WRI/WGI), or Appointment/Conversion (if applying as a current or former Federal Employee) showing you are/were in the competitive service and the highest grade or promotion potential held. Do not use Award actions. If you are an EOP employee you may obtain a copy of your SF-50 from OPF or eOPF. If you have separated from Federal Government employment, you may obtain a copy of your SF-50 via: National Personnel Records Center, Annex, 1411 Boulder Boulevard, Valmeyer, IL, 62295; FAX (618) 935-3014; Email rm.communications@nara.gov; or visit the https://www.archives.gov/personnel-records-center/new-nprc.
Peace Corps volunteers must submit a copy of your "Description of Service (DOS)" in lieu of the SF-50. If you do not have one you should email the Peace Corps Office of Volunteer and PSC Financial Services at certify@peacecorps.gov.
If you are currently serving in a pay banded position, please include a copy of your pay band chart with your application.
College transcripts (if the position has a positive education requirement, or you are qualifying on the basis of education).
Office of Administration
725 17th Street
Washington, DC 20503
US
Next steps
Once your online application is submitted you will receive a confirmation notification by email. Your application will be evaluated by the Human Resources Office to determine your eligibility for the position. After the evaluation is complete, you will receive another notification regarding the status of your application.
After a tentative job offer, we will conduct a security background investigation and drug screening. If the drug screening is negative and security background is cleared, then a formal job offer will be extended to candidate.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
