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, DevOps & 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 MuleSoft 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

Core Responsibilities

• 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 - MuleSoft Anypoint: Design, build, and maintain API-led integrations using MuleSoft 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 sprint (240 annually).

Minimum Requirements

• Education: Bachelor's degree in Computer Science, Information Systems, Data Science, or related field.
• Experience: Minimum 5 years of professional experience in data architecture, data integration, and/or data migration, including at least 2 years working with Salesforce data models.
• MuleSoft Proficiency: Hands-on experience with MuleSoft Anypoint Platform including API design (RAML/OAS), Mule flows, DataWeave transformations, CloudHub deployment, and API-led connectivity patterns (System, Process, Experience APIs).
• Data Architecture: Experience designing relational databases, dimensional data models, and data warehouse architectures. Proficiency with ETL/ELT processes, data profiling, and data quality frameworks.
• Salesforce Data Model: Strong understanding of Salesforce standard and custom objects, relationships, field types, record types, and data storage architecture. Experience with Salesforce Data Loader, bulk API, and metadata API.
• Integration Tools: Proficiency with REST/SOAP APIs, JSON/XML data formats, and enterprise integration patterns. Experience with at least one integration monitoring/APM tool.
• Tools: Proficiency with SQL, Git/GitHub, JIRA, VS Code, and data visualization tools (Tableau, Salesforce Reports, or equivalent).
• Compliance: Must be eligible for Public Trust (Tier 2 / MBI) security clearance. U.S. citizenship or permanent residency required.

Preferred Expertise

• MuleSoft Certified Developer or MuleSoft Certified Integration Architect.
• Salesforce Data Architect certification or Salesforce Platform Developer I.
• Experience with Salesforce Public Sector Solutions (PSS) Grants Management data model.
• Familiarity with federal grants lifecycle data flows - pre-award applications, post-award monitoring, semi-annual reporting, closeout reconciliation.
• Experience with FedRAMP-compliant integration architectures and NIST 800-53 data controls.
• Knowledge of Grants.gov and SAM.gov integration specifications and data formats.
• Experience with OwnBackup or similar Salesforce data protection and recovery tools.
• Prior experience on federal government Salesforce contracts (DOC, DOT, DOE, or similar agencies).
• SAFe or Scrum team experience in a multi-team delivery environment.

Halvik offers a competitive full benefits package including:

Company-supported medical, dental, vision, life, STD, and LTD insurance

Benefits include 11 federal holidays and PTO

Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.

401(k) with company matching

Flexible Spending Accounts for commuter, medical, and dependent care expenses

Tuition Assistance

Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Halvik's pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.