Data Product Engineer - Human Capital Analytics

About the role

CMT Services, Inc., an SBA-certified HUBZone and WOSB, supports federal, state and local government agencies. It is recruiting a Data Product Engineer to support the USDA's Enterprise Human Capital Modernization and Transformation initiative. The engineer develops and maintains dashboards, APIs and analytical data products, turning business requirements into scalable, secure data solutions with full lifecycle management. The position is mostly remote but requires attending meetings at the USDA in Washington, DC.

Key responsibilities

• Data migration planning and coordination: strategy, plans, timelines, crosswalks, mapping rules, trial migrations and reconciliation.
• Data quality and cleansing: assessments, dashboards, cleanup campaigns and standards compliance.
• Data governance and metadata management: standards, stewardship, lineage and authoritative data sources.
• Systems integration engineering: APIs, integrations, interface design, ICDs, ETL/ELT pipelines, interface remediation and integration testing.
• Business and functional analysis: requirements gathering, readiness and risk analysis, UAT support and business process development.
• Testing and validation: test cases, reconciliation scripts, UAT coordination and data verification.
• Databricks Lakehouse support: lakehouse architecture, security design, common data model, migration framework and reporting and analytics.
• Knowledge transfer: training, SOPs, workshops, shadowing sessions, documentation and repository management.

Required profile

• 3 to 5 years of progressive professional experience supporting HCM data and analytics solutions.
• Bachelor's degree in computer science, information systems, information technology or computer engineering.

Required skills

• Experience developing and maintaining dashboards, APIs and analytical data products for human capital data.
• Translating business and data requirements into scalable, secure data solutions, including data migration, system integration, reporting, analytics and downstream consumption.
• Supporting data discovery, source-to-target mappings, transformation logic, validation criteria and data flows for HCM data migration.
• Supporting the USDA Databricks Lakehouse as a governed repository for HCM reporting and analytics and as an integration platform.
• Common HCM data models, including data definitions, authoritative sources, relationships, metadata, lineage and governance attributes.
• Managing data products through development, integration, validation, maintenance and enhancement.