Business Intelligence Engineer

CMT Services Inc•Washington DC, DC

4d•Hybrid

About The Position

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.

Requirements

5+ years of progressive professional experience in business intelligence, data engineering, data modeling, or analytics roles.
Experience developing and maintaining dashboards, data models, reporting layers, and scalable BI products supporting stakeholder reporting and analytical requirements.
Experience building data quality dashboards supporting legacy HCM data cleanup monitoring and agency-driven cleanup campaigns.
Experience translating Human Capital stakeholder requirements into reporting and analytical data products while maintaining data quality and governance.
Experience supporting governed HCM data for reporting and analytics within the USDA Databricks Lakehouse.
Experience working with data models, authoritative sources, metadata, lineage, governance attributes, and data-quality requirements supporting reporting and analytics.
Experience aligning BI products with Human Capital Data governance and metadata-management requirements, including USDA and OPM governance expectations.
Bachelor’s degree in Computer Science, Information Systems, Information Technology, or Computer Engineering.

Responsibilities

Design, build, and maintain enterprise-level dashboards, robust data models, and reporting layers.
Serve as the technical bridge between Human Capital stakeholders and the data environment.
Translate complex operational needs into scalable, high-performing BI products.
Uphold strict data quality, governance, and architectural standards.
Develop and maintain dashboards, reporting, data quality metrics, analytics, and governance reporting.
Perform data quality assessments, create dashboards, conduct cleanup campaigns, and ensure standards compliance.
Implement metadata standards, stewardship, lineage, and identify authoritative data sources.
Develop test cases, reconciliation scripts, coordinate UAT, and perform data verification.
Support Databricks Lakehouse architecture, security design, common data model, and migration framework.
Provide reporting and analytics support for the Databricks Lakehouse.