About the role
ABOUT US
CMT Services Inc. is a dynamic and small business supporting Federal, State, and Local government agencies. As an SBA-certified HUBZone, Woman Owned Small Business (WOSB), we deliver quality, professional services to support the missions and strategic business goals of our clients.
Position Title
Data Product Engineer
Location
U.S. Department of Agriculture
1400 Independence Ave., SW
Washington, DC 20250
Period of Performance
Start Date: One 1-year base period plus 1-year option periods
Place of Performance
Remote (Mostly Remote – needs to be able to attend meetings at USDA in DC)
Position Summary: The Data Product Engineer will support the USDA’s Enterprise Human Capital Modernization & Transformation initiative. In this role, the Data Product Engineer develops and maintains dashboards, APIs, and analytical data products. Translates business requirements into scalable, secure data solutions with full lifecycle management.
Key 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
Required Qualifications
Years of Experience
3 to 5 years of progressive professional experience supporting HCM data and analytics solutions.
HCM Data Products
Experience developing and maintaining dashboards, APIs, and analytical data products supporting Human Capital data requirements.
Data Solutions
Experience translating business and data requirements into scalable and secure data solutions, including requirements supporting data migration, system integration, reporting, analytics, and downstream data consumption.
Data Migration
: Experience supporting data discovery, source-to-target mappings, transformation logic, validation criteria, and data flow/pipeline requirements associated with HCM data migration.
Databricks Lakehouse
Experience supporting the USDA Databricks Lakehouse as a governed repository for HCM reporting and analytics and as an integration platform for secure data exchange and interoperability with related systems.
HCM Data Models
Experience supporting common HCM data models, including data definitions, authoritative sources, relationships, metadata, lineage, governance attributes, and alignment with reporting, integration, migration, and analytics requirements.
Data Product Lifecycle
Experience managing data products through their full lifecycle, including development, integration, validation, maintenance, and enhancement.
Education
Bachelor’s degree in computer science, Information Systems, Information Technology, Computer Engineering.
Join Our Team
At CMT Services , we believe that extraordinary results come from empowering exceptional people. If you're ready to lead innovative projects, solve complex challenges, and contribute to meaningful infrastructure development while advancing your career in a supportive, collaborative environment, we want to hear from you.
Disclaimer
By submitting your resume for this job posting, you authorize CMT Services, Inc. to forward your resume to all applicable internal and external managers, agencies, and recruitment personnel for review and consideration to hire.