Sr. Data Architect

Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500+ professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special.

Halvik is seeking a Senior Data Architect with strong data integration and data migration expertise to join Team 4 (Integration, Data, Dev Ops & Support) in support of the National Telecommunications and Information Administration (NTIA) Grants Portal (NGP). The NGP is a Salesforce-based platform administering $48.2 billion in federal broadband grants under the Infrastructure Investment and Jobs Act (IIJA), including BEAD ($42.45B), Digital Equity, Middle Mile, and Tribal Broadband Connectivity programs.

The platform is in an active post-award operational phase with immediate emphasis on supporting grantee compliance review across existing broadband programs. The incumbent team has identified compliance monitoring, data quality, and reporting integrity as the primary near-term priorities before new grant program deployments begin. This role will be instrumental in ensuring the data layer that supports compliance review - grantee reporting submissions, semi-annual performance data, financial reconciliation, and cross-system validation - is accurate, timely, and auditable.

The Senior Data Architect will design and maintain data integration pipelines using Mule Soft Anypoint Platform to connect NGP with internal NTIA enterprise systems (financial, HR, identity management) and external federal platforms (Grants.gov, SAM.gov, grantee portal APIs). The role also encompasses data migration strategy and execution - profiling source systems, creating field-level mappings to Salesforce objects, developing ETL jobs, and executing phased migration sprints with iterative validation to preserve the integrity of NTIA's grant portfolio data.

• Grantee Compliance Data Support: Ensure the data layer supporting grantee compliance review is accurate and complete. This includes validating data flows for semi-annual reporting (BEAD, Digital Equity, Middle Mile), financial reconciliation data, Environmental and Historic Preservation submissions, and risk assessment inputs used by Federal Program Officers.
• Data Integration - Mule Soft Anypoint: Design, build, and maintain API-led integrations using Mule Soft Anypoint Platform to connect NGP with internal NTIA systems (financial, HR, identity management, enterprise content management) and external systems (Grants.gov application packages, SAM.gov entity validation, grantee portal APIs). Follow FedRAMP-compliant integration patterns with encryption in transit and at rest.
• Data Migration Strategy & Execution: Lead data migration activities including source system inventory, volume assessment, data profiling, field-level mapping to Salesforce objects, ETL job development with cleansing rules, and phased migration sprints. Execute iterative validation cycles across Dev, UAT, and Production environments with record count reconciliation and business process verification.
• Data Architecture & Modeling: Design and maintain relational and dimensional data models supporting NGP's grant lifecycle. Develop data warehousing blueprints, evaluate data reusability for compliance analytics, and structure metadata for faster access and better management of grant program data across BEAD, Digital Equity, Middle Mile, and Tribal Broadband.
• Data Quality & Governance: Establish and enforce data quality standards, validation checkpoints, and data governance protocols. Profile source data for quality issues, implement automated data quality checks within integration pipelines, and produce Data Profiling Reports and Data Mapping Specifications as contract deliverables.
• Integration Monitoring & Operations: Build and maintain real-time integration monitoring dashboards and automated alerting. Implement error handling with retry mechanisms and incident escalation procedures. Monitor API volumes, optimize caching strategies, and maintain 99.5% integration uptime per contract performance standards.
• Post-Migration Support: Provide post-migration data reconciliation, ongoing quality monitoring, and legacy data access per NTIA retention policies. Resolve critical data issues within 30 days post-migration per contract requirements.
• Cross-System Compliance Reporting: Support cross-system data validation to ensure grantee compliance data reported in NGP aligns with data in Grants.gov, SAM.gov, and NTIA's replacement grants office solution (GEMS/eRA). Identify and remediate data discrepancies that could impact compliance determinations.
• Agile Participation: Participate in sprint planning, daily stand-ups, sprint reviews, and retrospectives within the SAFe Scrum of Scrums framework. Contribute an estimated 15 story points per…