Business Intelligence Engineer

CMT Services, Inc.; Washington (District of Columbia); Remote; USD 90,000 - 130,000; Full time

Job summary

CMT Services, Inc. is recruiting a Business Intelligence Engineer to design, build, and maintain enterprise dashboards and data models for USDA initiatives. You will bridge Human Capital stakeholders and the data environment, ensuring scalable BI products with high data quality and governance.

The role emphasizes collaboration across teams, data quality, and governance while implementing lakehouse architecture and secure reporting. Remote work is available with occasional meetings in DC.

Qualifications

• 5+ years in BI, data engineering or analytics.
• Experience building dashboards and data models.
• Experience with data quality dashboards.
• Ability to translate stakeholder requirements into reports.
• Experience supporting USDA Databricks Lakehouse.
• Experience with data models, metadata, lineage and governance.
• Governance-aligned BI products with data quality in mind.

Responsibilities

• Deliver dashboards, reports and analytics.
• Perform data quality assessments and cleanup.
• Maintain metadata, lineage and governance.
• Develop test cases and support UAT.
• Support Databricks Lakehouse architecture and security.

Skills

BI dashboards

Data modeling

Data governance

Stakeholder comms

Education

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

Tools

Databricks Lakehouse

Job description

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.

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.
• Stakeholder Requirements: Experience translating Human Capital stakeholder requirements into reporting and analytical data products while maintaining data quality and governance.
• USDA Databricks Lakehouse Support: Experience supporting governed HCM data for reporting and analytics within the USDA Databricks Lakehouse. (Note: The Lakehouse serves as USDA's governed repository for HCM reporting and analytics).
• Data Models & Lineage: Experience working with data models, authoritative sources, metadata, lineage, governance attributes, and data-quality requirements supporting reporting and analytics.
• Governance Alignment: Experience aligning BI products with Human Capital Data governance and metadata-management requirements, including USDA and OPM governance expectations.

Education

• Bachelor’s degree in Computer Science, Information Systems, Information Technology, or 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.