Business Intelligence Engineer

About the role

CMT Services, Inc., an SBA-certified HUBZone and WOSB, supports Federal, State and Local government agencies. It is recruiting a Business Intelligence Engineer to support the USDA's Enterprise Human Capital Modernization and Transformation initiative. The engineer designs, builds and maintains enterprise dashboards, data models and reporting layers, acting as the technical bridge between Human Capital stakeholders and the data environment. The position is mostly remote but requires attending meetings at the USDA in Washington, DC.

Key responsibilities

• Build dashboards, reporting, data quality metrics, analytics and governance reporting
• Data quality: assessments, dashboards, cleanup campaigns and standards compliance
• Data governance and metadata management: standards, stewardship, lineage and authoritative data sources
• Testing and validation: test cases, reconciliation scripts, UAT coordination and data verification
• Databricks lakehouse support: architecture, security design, common data model, migration framework and reporting and analytics

Required profile

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