Data Product Engineer: HCM Dashboards & APIs

CMT Services; Washington (District of Columbia); Hybrid; USD 95,000 - 150,000; Full time

Job summary

CMT Services, a small business supporting federal agencies, is seeking a Data Product Engineer to support USDA's Enterprise Human Capital Modernization initiative. You will develop dashboards, APIs, and analytical data products translating business needs into scalable data solutions.

The role covers data migration, governance, metadata, and integration, with responsibilities from requirements through testing and deployment.

Qualifications

• 3 to 5 years of progressive experience supporting HCM data and analytics solutions.
• Experience developing and maintaining dashboards, APIs, and analytical data products.
• Translating business and data requirements into scalable, secure data solutions.
• Experience supporting data migration, integration, and analytics.
• Experience with USDA Databricks Lakehouse governance and data exchange.
• Experience with common HCM data models, metadata and lineage.
• Experience managing data products through full lifecycle.

Responsibilities

• Core Deliverables: Data solutions, dashboards, requirements implementation, integration support, quality monitoring, analytics products.
• Data Migration Planning & Coordination: Migration strategy, plans, timelines, crosswalks, mapping rules, trial migrations, reconciliation.
• Data Quality & Cleansing: Data quality assessments, dashboards, cleanup campaigns, standards compliance.
• Data Governance & Metadata Management: Metadata standards, stewardship, lineage, authoritative data sources.
• Systems Integration Engineering: APIs, integrations, interface design, ICDs, ETL/ELT pipelines, interface remediation, integration testing.
• Business & Functional Analysis: Requirements gathering, readiness assessment, risk analysis, UAT support, business process development.
• Testing & Validation: Test cases, reconciliation scripts, UAT coordination, data verification.
• Databricks Lakehouse Support: Lakehouse architecture, security design, common data model, migration framework, reporting and analytics.
• Knowledge Transfer: Training, SOPs, workshops, shadowing sessions, documentation, repository management.

Skills

3 to 5 years experience

HCM data products

Data solutions

Data migration

Databricks lakehouse

HCM data models

Data product lifecycle

Education

Bachelor’s degree in CS/IS/IT/CE

Tools

Databricks

Job description

CMT Services, a small business supporting federal agencies, is seeking a Data Product Engineer to support USDA's Enterprise Human Capital Modernization initiative. You will develop dashboards, APIs, and analytical data products translating business needs into scalable data solutions.

The role covers data migration, governance, metadata, and integration, with responsibilities from requirements through testing and deployment.