Salesforce Data Architect

Halvik; Vienna (VA); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with company matching

Paid federal holidays and PTO

Tuition Assistance

Job summary

Halvik is seeking a senior Salesforce developer and data architect to support the Department of Commerce – Federal Grants Programs. The role blends Salesforce data modeling, MuleSoft integrations, and Data 360 expertise to deliver end-to-end data lifecycle solutions.

The ideal candidate will lead migrations, build semantic models, and implement declarative automation with Flows, while writing Apex when necessary and ensuring compliance with security clearances.

Qualifications

• Bachelor's degree and professional Salesforce development experience required.
• MuleSoft Anypoint Platform experience with API design, DataWeave, and CloudHub/Runtimes required.
• Hands-on Data 360 configuration and semantic modeling on delivered projects required.

Responsibilities

• Salesforce Data Modeling & Architecture: design, extend, and optimize Salesforce data models including custom objects, relationships, and data storage patterns.
• Data Migration: lead end-to-end data migration activities, profiling, mapping, ETL, and phased migrations with validation.
• MuleSoft Integration Development: build API-led integrations with MuleSoft, DataWeave transformations, CloudHub configurations, and robust error handling.
• Data 360 & Semantic Layer: configure Data 360 to build semantic models, define metrics, and enable analytics integration with CRM Analytics and Tableau Next.
• Salesforce Application Development: declarative-first automation with Flows and Orchestrations, plus Apex, LWC, and SOQL/SOSL for reporting/UI.
• Data Quality & Governance: ensure data quality for reporting and compliance, create data profiling and mapping docs, post-migration reconciliation.

Skills

Salesforce development

Data architecture

MuleSoft integration

Data 360

Apex

LWC

Flows

SOQL

ETL

Data modeling

Semantic layer

SQL

Git/GitHub

JIRA

VS Code with Salesforce Extensions

Education

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

Salesforce Platform Developer I

Additional relevant certification (e.g., Platform Developer II, Data Architect, Integration Architect, MuleSoft Developer, or OmniStudio Developer)

Tools

Git/GitHub

JIRA

VS Code with Salesforce Extensions

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