Data Management Engineer

Job Family

Data Science & Analysis

Up to 10%

Active Top Secret SCI with Polygraph

• Facilitate the incremental migration of existing Agency Human Capital Management (HCM) data from the PeopleSoft HCM system to the new Cloud HCM environment.
• Develop and support modifications/extensions to the project's source data extraction, source data error identification, and source data transformation processes.
• Support loading data, monitoring progress, and reporting errors.
• Support, compile, and summarize identified data issues and proposed fixes to the client for review and decision on resolution.
• Correct data ingest/validation issues.
• Take a structured approach to decompose, identify, and define data handling solutions to meet role based access control (RBAC) and attribute based access control (ABAC) requirements through a variety of tools and techniques.
• Address client data tagging and Enterprise Data Header (EDH) requirements enabling the existing data model to be extended to capture information such as classification, sensitivity tags, and controls at the element level.
• Use the Cloud HCM data disposal tool to perform data deletion and purging.
• Support data governance using the Cloud HCM single authority data source to the element level and controls.
• Provide a publicly accessible data dictionary with element level conformal definitions that are continuously maintained; providing and capturing all additional client required elements during implementation.
• Move historical data from the legacy HCM system to a Database as a Service (DBaaS) Virtual Machine (VM) instance.
• Use Cloud HCM to manage data quality by leveraging build edits and a rules engine for data entry to control data as it is entered, and through workflows.
• Implement Mass Personnel Action Processing (PAR) corrections using automated methods to correct data.
• Provides support to client Master Data Management (MDM) initiatives through data models, data controls, integration capabilities.

• ACTIVE and CURRENT TOP SECRET (TS)/SCI federal security clearance with FULLSCOPE (FS) Polygraph.
• FOURTEEN (14) years’ experience as an engineer in programs and contracts of similar scope, type, and complexity.
• Bachelor’s degree in a technical discipline from an accredited college or university is required.
• FIVE (5) years of additional experience on projects with similar processes may be substituted for a bachelor’s degree.
• Technical flexibility to work with on-premises and cloud-based tools and applications.

• Active Security + CE or equivalent/alternate IAT Level II or III certification.
• Functional experience in Peoplesoft HRMS 9.2.
• Technical experience in PeopleTools, including, but not limited to, developing & supporting Application Engines, PeopleCode, Data Mover, and Peoplesoft integration tools.
• Technical experience in Oracle RDBMS development, preferably SQL, PL/SQL.
• In lieu of PeopleSoft/HCM experience, a motivated self-starter who is willing to learn Oracle SaaS applications.

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

• Medical, Rx, Dental & Vision Insurance.
• Personal and Family Sick Time & Company Paid Holidays.
• Position may be eligible for a discretionary variable incentive bonus.
• Parental Leave and Adoption Assistance.
• 401(k) Retirement Plan.
• Basic Life & Supplemental Life.
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts.
• Short-Term & Long-Term Disability.
• Student Loan PayDown.
• Tuition Reimbursement, Personal Development & Learning Opportunities.
• Skills Development & Certifications.
• Employee Referral Program.
• Corporate Sponsored Events & Community Outreach.
• Emergency Back-Up Childcare Program.
• Mobility Stipend.

Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.