HCM Data Architecture and Integration Associate Director

Guidehouse; Arlington (VA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical Insurance

401(k) Retirement Plan

Discretionary bonus

Tuition Reimbursement

Mobility Stipend

Job summary

Guidehouse is seeking an experienced Data Architect to lead the design, governance, migration, and integration of enterprise HCM data solutions. This role will serve as the technical authority for data architecture across a large-scale HCM transformation, ensuring data integrity, interoperability, governance, and scalability from legacy environments to modern cloud-based platforms.

The ideal candidate combines deep expertise in data architecture, migration strategy, integration design, and data

Qualifications

• Must be able to OBTAIN and MAINTAIN a Federal Public Trust security clearance.
• Bachelor's degree in a related field (see above).
• 8+ years of experience in data architecture, data engineering, enterprise integration, data management, or system modernization.
• Experience designing data architectures for complex enterprise applications, HCM platforms, HRIS solutions, or ERP programs.
• Experience with data modeling (conceptual, logical, physical).
• Experience with data discovery, profiling, source-to-target mapping, data conversion, ETL, quality controls, migration validation.
• Experience designing API, middleware, batch, file-based, and real-time integration patterns.
• Experience defining metadata, lineage, data ownership, stewardship, access, security, and quality standards.
• Experience translating business processes and reporting needs into data models and designs.
• Experience reviewing technical designs and guiding data engineers and analysts.
• Experience supporting federal government clients or complex public-sector organizations.

Responsibilities

• Lead design and evolution of enterprise HCM data architecture and models.
• Define data standards, canonical models, integration patterns, and architecture principles.
• Translate HR requirements into scalable data solutions for reporting and analytics.
• Create and maintain architecture documentation, data flows, and design artifacts.
• Lead data migration strategy, including discovery, profiling, cleansing, transformation, mapping, and validation.
• Define migration architectures, cutover strategies, rollback plans, and post-migration support.
• Establish data governance frameworks with ownership, stewardship, and metadata management.
• Develop data quality monitoring capabilities and governance controls.
• Design and review integrations between HCM platforms and enterprise systems.
• Collaborate with enterprise architecture, cybersecurity, cloud, and platform teams.
• Lead architecture workshops, provide mentorship, and present recommendations to client leadership.

Skills

Data architecture

Migration strategy

Data governance

Interoperability

Stakeholder collaboration

Leadership

Cloud platforms

API integration

Education

Bachelor's degree in Computer Science, Information Systems, Data Architecture, Engineering, Data Management, or related field

Master’s degree in Computer Science, Data Architecture, Information Systems, Engineering, Data Management, or related discipline

Tools

Databricks

Microsoft Azure

AWS

Snowflake

Data catalogs

Job description

What You Will Do

We are seeking an experienced

Job Family

Data Science Consulting

Travel Required

Up to 25%

Clearance Required

Ability to Obtain Public Trust

What You Will Do

We are seeking an experienced Data Architect to lead the design, governance, migration, and integration of enterprise Human Capital Management (HCM) data solutions. This role will serve as the technical authority for data architecture across a large-scale HCM transformation, ensuring data integrity, interoperability, governance, and scalability from legacy environments to modern cloud-based platforms. The ideal candidate combines deep expertise in data architecture, migration strategy, integration design, and data governance with the ability to collaborate across business, technical, and executive stakeholders to deliver successful enterprise transformation outcomes.

Key Responsibilities

Data Architecture & Strategy

• Lead the design and evolution of enterprise HCM data architecture, including current, transition, and future-state models.
• Define data standards, canonical data models, integration patterns, and architecture principles across employee, organizational, workforce, learning, and related HR domains.
• Translate HR business requirements into scalable data solutions that support reporting, analytics, and operational processes.
• Create and maintain architecture documentation, data flows, technical standards, and design artifacts.

Data Migration & Transformation

• Lead data migration strategy for HCM modernization initiatives, including data discovery, profiling, cleansing, transformation, mapping, validation, and reconciliation.
• Define migration architectures, conversion rules, cutover strategies, rollback plans, and post-migration support processes.
• Identify data quality issues, legacy system risks, and remediation approaches to ensure successful transformation and implementation.

Data Governance & Quality

• Establish data governance frameworks, including ownership, stewardship, metadata management, lineage, security, and quality standards.
• Develop business glossaries, data dictionaries, governance controls, and data quality monitoring capabilities.
• Ensure compliance with organizational policies and support long-term sustainment of governance processes.

Integration & Technical Leadership

• Design and review integrations between HCM platforms and enterprise systems, including payroll, finance, recruiting, learning, identity management, and reporting solutions.
• Evaluate integration performance, security, scalability, monitoring, and operational support requirements.
• Collaborate with enterprise architecture, cybersecurity, cloud, and platform teams to deliver secure and reliable solutions.

Leadership & Stakeholder Engagement

• Lead architecture workshops, technical reviews, and cross-functional decision forums.
• Provide guidance and mentorship to architects, engineers, analysts, and implementation teams.
• Present technical recommendations to client leadership and support program delivery, business development, recruiting, and thought leadership initiatives.

What You Will Need

• Must be able to OBTAIN and MAINTAIN a Federal Public Trust security clearance.
• Bachelor's degree in Computer Science, Information Systems, Data Architecture, Engineering, Data Management, or a related field.
• EIGHT (8) or more years of experience in data architecture, data engineering, enterprise integration, data management, or system modernization.
• Experience designing data architectures for complex enterprise applications, HCM platforms, HRIS solutions, or ERP programs.
• Demonstrated experience with conceptual, logical, and physical data modeling.
• Experience with data discovery, profiling, source-to-target mapping, data conversion, ETL, quality controls, reconciliation, and migration validation.
• Experience designing API, middleware, batch, file-based, and real-time integration patterns.
• Experience defining metadata, lineage, data ownership, stewardship, access, security, and quality standards.
• Experience translating business processes, policies, and reporting needs into data models, architecture requirements, and technical designs.
• Experience reviewing technical designs and providing direction to data engineers, analysts, developers, and integration specialists.
• Experience supporting federal government clients or complex public-sector organizations.

What Would Be Nice To Have

• Master’s degree in Computer Science, Data Architecture, Information Systems, Engineering, Data Management, or a related discipline.
• Strong understanding of relational databases, data warehouses, cloud data platforms, and enterprise-integration concepts.
• Strong technical writing, facilitation, presentation, consulting, and stakeholder-management skills.
• Experience supporting federal HCM, HRIT, ERP, shared-services, or enterprise HR modernization programs.
• Experience supporting federal transportation, infrastructure, logistics, or another complex and distributed operating environment.
• Experience with Workday, SAP SuccessFactors, Oracle HCM, PeopleSoft, or another enterprise HCM platform.
• Experience integrating HCM platforms with payroll, finance, identity management, security, learning, benefits, recruiting, timekeeping, or reporting systems.
• Experience with Databricks, Microsoft Azure, AWS, Snowflake, or comparable cloud and data platforms.
• Experience with data catalogs, metadata management, lineage, MDM, or DataOps tools.
• Understanding of federal cybersecurity, privacy, records management, identity management, and data-interoperability requirements.
• Familiarity with Agile, hybrid, and waterfall implementation approaches.
• Certified Data Management Professional, TOGAF, cloud architect, data platform, or HCM platform certification.
• Experience managing technical teams and developing junior staff.

What We Offer

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.

Benefits Include

• 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

About Guidehouse

Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities 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 [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail]. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse.

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.