Data Product Engineer

CMT Services, Inc.; Washington (District of Columbia); Híbrido; USD 90 000 - 130 000; Tempo integral

Resumo da oferta

CMT Services, Inc. seeks a Data Product Engineer to support USDA initiatives from a remote base with periodic on-site attendance in Washington, DC.

You will build dashboards, APIs, and analytic data products, translating business requirements into scalable data solutions across the full lifecycle. The ideal candidate has 3–5 years of experience in HCM data and analytics, including data migration, data governance, and Databricks Lakehouse.

Qualificações

• 3 to 5 years of progressive professional experience supporting HCM data and analytics solutions.
• Experience developing and maintaining dashboards, APIs, and analytical data products for HCM data.
• Experience translating business requirements into scalable data solutions, including migration, integration, and analytics.

Responsabilidades

• Develop data solutions, dashboards, APIs, and analytics products.
• Plan and coordinate data migrations with crosswalks and mappings.
• Ensure data quality, cleansing, and standards compliance.
• Manage metadata, governance, lineage, and authoritative sources.
• Design and test APIs, integrations, ICDs, and ETL/ELT pipelines.
• Conduct business analysis, readiness and UAT support.
• Support Databricks Lakehouse architecture, security, and data models.
• Provide knowledge transfer through training and documentation.

Conhecimentos

HCM analytics

Data dashboards

APIs

Data governance

ETL/ELT pipelines

Formação académica

Bachelor’s degree in computer science, Information Systems, Information Technology, Computer Engineering

Ferramentas

Databricks Lakehouse

ETL/ELT tools

Descrição da oferta de emprego

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 supportthe missions and strategic business goals of our clients.

PositionTitle: 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.