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: Business Intelligence 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 Business Intelligence (BI) Engineer will support the USDA’s Enterprise Human Capital Modernization & Transformation initiative. In this role, you will design, build, and maintain enterprise-level dashboards, robust data models, and reporting layers. You will serve as the technical bridge between Human Capital stakeholders and the data environment—translating complex operational needs into scalable, high-performing BI products while upholding strict data quality, governance, and architectural standards.
Key Responsibilities:
-
Core Deliverables: Dashboards, reporting, data quality metrics, analytics, governance reporting.
-
Data Quality & Cleansing: Data quality assessments, dashboards, cleanup campaigns, standards compliance.
-
Data Governance & Metadata Management: Metadata standards, stewardship, lineage, authoritative data sources.
-
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.
Required Qualifications:
-
Years of Experience: 5+ years of progressive professional experience in business intelligence, data engineering, data modeling, or analytics roles.
-
BI Product Development: Experience developing and maintaining dashboards, data models, reporting layers, and scalable BI products supporting stakeholder reporting and analytical requirements.
-
Data Quality Dashboards: Experience building data quality dashboards supporting legacy HCM data cleanup monitoring and agency-driven cleanup campaigns.<