Salesforce Data Architect

Tetra Tech; Vienna (VA); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision, life, STD, &

401(k) with company matching

Tuition Assistance

Paid federal holidays and PTO

Job summary

Halvik Corp is seeking a senior Salesforce/data specialist to design data models, lead large-scale migrations, and implement MuleSoft integrations. The role focuses on Data 360 semantics, API-led architectures, and analytics enablement across federal platforms.

Candidates should demonstrate deep Salesforce development, data architecture, and hands-on Data 360 configuration, with security clearance eligibility and a strong background in enterprise-grade integration.

Qualifications

• Bachelor's degree in CS/IS/DS or related field.
• Minimum 5 years Salesforce development (Flows, Apex, LWC, SOQL) with at least 2 years in data architecture or large-scale data migration.
• MuleSoft Anypoint Platform experience including API design (RAML/OAS), DataWeave, and CloudHub/Runtime Fabric deployment.
• Hands-on experience with Salesforce Data 360 (semantic models, metrics, data pipelines).
• Salesforce Platform Developer I and at least one additional relevant certification (e.g., Platform Developer II, Data Architect, Integration Architect, MuleSoft Developer, or OmniStudio).
• Eligibility for Public Trust clearance; U.S. citizenship or permanent residency.

Responsibilities

• Design, extend, and optimize Salesforce data models for compliance reporting, analytics, and downstream integration.
• Lead end-to-end data migration: inventory, profiling, mapping, ETL, and phased validation.
• Build and maintain MuleSoft API-led integrations with System, Process, and Experience APIs; implement DataWeave transformations and CloudHub deployments.
• Configure Salesforce Data 360 semantic models and define business metrics and calculated fields.
• Develop declarative automation (Flows) and Apex where needed; build Lightning Web Components and SOQL/SOSL for reporting/UI.
• Ensure data quality and governance with automated validation checks and post-migration reconciliation.

Skills

Salesforce development

Data architecture

MuleSoft integration

Data 360

Apex

LWC

Flows

SOQL/SOSL

SQL

GitHub

JIRA

VS Code with Salesforce Extensions

Data Loader / ETL patterns

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, or related field

Tools

JIRA

VS Code with Salesforce Extensions

ETL tool

Job description

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!

Position Overview

Halvik is seeking a senior individual contributor with a rare combination of Salesforce development depth, data architecture skills, MuleSoft integration experience, and hands-on Data 360 expertise. This role supports Dept. of Commerce – Federal Grants Programs. The role requires someone who builds: designing Salesforce data models, writing migration scripts, configuring MuleSoft integrations, and standing up Data 360 semantic models. The ideal candidate has spent years as a Salesforce developer (Apex, LWC, Flows) and has evolved into data-centric work: object model design, large-scale data migration, integration architecture, and analytics enablement through Data 360. We need someone who can think across the full data lifecycle from source system profiling through Salesforce object modeling to semantic layer definition - and who can personally execute each step.

Core Responsibilities

• Salesforce Data Modeling & Architecture: Design, extend, and optimize Salesforce data models including custom objects, relationships (master-detail, lookup, junction), record types, field configurations, and data storage patterns. Ensure model decisions support compliance reporting, analytics, and downstream integration. Develop data warehousing blueprints and evaluate data reusability for additional analyses.
• Data Migration: Lead end-to-end data migration activities: source system inventory and profiling, field-level mapping to Salesforce objects, ETL job development with cleansing and transformation rules, and phased migration sprints with iterative validation. Maintain legacy data access per agency retention policies.
• MuleSoft Integration Development: Build and maintain API-led integrations using MuleSoft Anypoint Platform. Implement System, Process, and Experience API layers connecting Salesforce with internal agency systems and external federal platforms. Write DataWeave transformations, configure CloudHub deployments, and implement error handling with retry mechanisms and automated alerting.
• Data 360 & Semantic Layer: Configure and extend Salesforce Data 360 to build semantic models that enable natural-language querying and analytics. Define data relationships, business metrics, and calculated fields within the semantic layer. Support integration between Data 360, CRM Analytics, and Tableau Next.
• Salesforce Application Development: Comfortable with declarative-first approach - build and maintain complex Flows and Flow Orchestrations as the primary automation mechanism, alongside Apex classes and triggers where custom code is warranted. Develop Lightning Web Components and SOQL/SOSL queries to support reporting and UI requirements.
• Data Quality & Governance: Own data quality for reporting and compliance data pipelines. Implement automated validation checks within integration flows and migration scripts. Produce Data Profiling Reports, Data Mapping Specifications, and post-migration reconciliation deliverables.

Minimum Requirements

• Education: Bachelor's degree in Computer Science, Information Systems, Data Science, or related field.
• Experience: Minimum 5 years of professional Salesforce development experience (Flows, Apex, LWC, SOQL), with at least 2 years focused on data architecture, data modeling, or large-scale data migration within Salesforce.
• MuleSoft (Required): Prior project experience with MuleSoft Anypoint Platform including API design (RAML/OAS), Mule flows, DataWeave transformations, and CloudHub or Runtime Fabric deployment. Must demonstrate integration work delivered on a real engagement, not just training or certification.
• Data 360 (Required): Hands-on project experience with Salesforce Data 360 (formerly Tableau CRM Data Prep or Data Cloud components). Must have configured semantic models, defined business metrics, or built data pipelines within Data 360 on a delivered project.
• Salesforce Data Model Expertise: Deep understanding of Salesforce standard and custom objects, relationships, field types, record types, data storage limits, and data architecture best practices. Experience with Salesforce Data Loader, Bulk API, Metadata API, and data import/export patterns.
• Certifications (Required): Salesforce Platform Developer I. At minimum one additional relevant certification (e.g., Platform Developer II, Data Architect, Integration Architect, MuleSoft Developer, or OmniStudio Developer).
• Tools: Proficiency with SQL, Git/GitHub, JIRA, VS Code with Salesforce Extensions, and at least one data profiling or ETL tool.
• Compliance: Must be eligible for Public Trust (Tier 2 / MBI) security clearance. U.S. citizenship or permanent residency required.

Preferred Expertise

• Salesforce Data Architect or Integration Architect certification.
• MuleSoft Certified Developer or MuleSoft Certified Integration Architect.
• Experience with Salesforce Public Sector Solutions (PSS) Grants Management data model.
• OmniStudio experience (DataRaptors, Integration Procedures) for data orchestration within Salesforce.
• Experience with CRM Analytics (formerly Einstein Analytics) or Tableau Next.
• Agentforce or Einstein AI experience - grounding data pipelines, retrieval-augmented generation, or AI data preparation.
• FedRAMP compliance experience or prior work on federal government Salesforce contracts.

Privacy Policy – Halvik Corp

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'spay 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.