Note: The job is a remote job and is open to candidates in USA. CMT Services, Inc. is a small business supporting Federal, State, and Local government agencies with professional services aligned to client missions and strategic goals. The Data Product Engineer will support the USDA’s Enterprise Human Capital Modernization & Transformation initiative by developing and maintaining dashboards, APIs, and analytical data products, while translating business requirements into scalable and secure data solutions with full lifecycle management.
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
- * 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
- * Bachelor's degree in computer science, Information Systems, Information Technology, Computer Engineering
Benefits
- Remote (Mostly Remote – needs to be able to attend meetings at USDA in DC)
- Training, SOPs, workshops, shadowing sessions, documentation, repository management
- Supportive, collaborative environment
- Advancing your career
Company Overview