Salesforce Data Architect

Orion Global Solutions, LLC; United States; Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health coverage

Paid time off

Wellness programs

Volunteer opportunities

Career development support

Vibrant, supportive culture

Job summary

Orion Global Solutions is seeking a Salesforce Data Architect to design and govern enterprise-grade data architectures across Salesforce ecosystems. You will collaborate with solution architects, developers, and stakeholders to translate business needs into robust data models and integration strategies for analytics and AI readiness.

The role emphasizes data quality, governance, and secure, scalable architectures across Sales, Service, ERP integrations, and external data sources.

Qualifications

• 5+ years of experience with Salesforce, including 3+ years in data-focused roles such as Data Architect or Senior Data Specialist.
• Strong expertise in Salesforce object modeling, schema design, security model, and data access controls, governor limits.
• Proven experience with data migration strategies and tools, and supporting multi-system, enterprise-level environments.
• Hands‑on experience with Salesforce integrations using REST and SOAP APIs.
• Experience with ETL and middleware tools such as MuleSoft, Boomi, Talend, or Informatica.
• Advanced SQL and data analysis skills.
• Experience handling large data volumes.
• Knowledge of data modeling tools (ERWin, Lucidchart).
• Strong communication and problem-solving capabilities, with professional written and spoken fluency.

Responsibilities

• Design and own Salesforce data models across core clouds (Sales, Service, Financial Services, Consumer Goods).
• Define object models, relationships, field strategy, and data lifecycle management.
• Ensure scalability, performance, and alignment with Salesforce best practices.
• Lead data governance, naming conventions, and standards.
• Architect and oversee data migrations from legacy systems (ERP, CRM, custom databases).
• Define strategies for data synchronization, deduplication, and master data management.
• Establish and enforce data quality frameworks (validation, deduplication, enrichment).
• Partner with stakeholders on data ownership, stewardship, and compliance.
• Support regulatory and security requirements (PII, GDPR, role-based access).
• Design data structures optimized for Salesforce reporting, dashboards, and analytics.
• Enable downstream use cases for Einstein, AI, and advanced analytics.
• Support Data Cloud and Customer 360 initiatives where applicable.

Skills

Salesforce data modeling

Schema design

Security model & access controls

Governor limits

Data migration strategies

Enterprise integration

REST APIs

SOAP APIs

ETL tools

MuleSoft

Boomi

Talend

Informatica

SQL

Data analysis

Large data volumes

ERWin

Lucidchart

Communication skills

Problem solving

Salesforce Data Cloud

Education

Salesforce Data Architect certification

Salesforce Integration Architect certification

Platform App Builder certification

Experience with Data Cloud

Tools

REST APIs

SOAP APIs

Job description

Who We Are

At Orion Global Solutions, we’re not your typical tech consultancy. As a Salesforce Summit Partner (the highest tier!) and one of the fastest-growing Salesforce partners in the New York Metro area, we bring innovation, speed, and genuine collaboration to every client interaction. But what truly sets us apart? Our people-first culture. We foster an environment where curiosity is encouraged, growth is inevitable, and every voice is heard. At Orion, you’re not just part of a company—you’re part of something exciting, impactful, and real.

The Role

We are seeking an experienced Salesforce Data Architect to design, govern, andoptimizeenterprise-grade data architectures across Salesforce platforms. This role is critical to ensuring data quality, scalability, security, and analytics readiness across complex Salesforce ecosystems, including integrations with ERP, marketing, and external data sources.

You will partner closely with Solution Architects, Developers, and Client Stakeholders to translate business requirements into robust data models and integration strategies that support reporting, automation, AI readiness, and long-term platform health.

What You’ll Be Doing

Data Architecture & Design

• Design and ownSalesforce data modelsacross core clouds (Sales, Service,Financial Services, Consumer Goods)

• Defineobject models, relationships, field strategy, and data lifecycle management

• Ensure scalability, performance, and alignment with Salesforce best practices

• Leaddata governance, naming conventions, and standards

Data Migration & Integration

• Architect and overseedata migrationsfrom legacy systems (ERP, CRM, custom databases)

• Define strategies fordata synchronization, deduplication, and master data management

Data Quality & Governance

• Establish and enforcedata quality frameworks(validation, deduplication, enrichment)

• Partner with stakeholders ondata ownership, stewardship, and compliance

• Support regulatory and security requirements (PII, GDPR, role-based access)

Analytics, Reporting & AI Readiness

• Design data structuresoptimizedforSalesforce reporting, dashboards, and analytics

• Enable downstream use cases forEinstein, AI, and advanced analytics

• Support Data Cloud and Customer 360 initiatives where applicable

What You Bring

• 5+ years of experience working with Salesforce platforms, including 3+ years in a data-focused role such as Data Architect or Senior Data Specialist

• StrongexpertiseinSalesforce object modeling, schema design, security model, and data access controls, governor limits.

• Proven experience with data migration strategies and tools, as well as supporting multi-system, enterprise-level environments

• Hands‑on experience with Salesforce integrations using REST and SOAP APIs

• Experience with ETL and middleware tools such as MuleSoft, Boomi, Talend, or Informatica

• Advanced SQL and data analysis skills

• Experiencehandling large data volumes.

• Knowledge of data modeling tools (ERWin,Lucidchart, etc.)

• Strong communicationand problem-solving capabilities, with professional written and spoke

Preferred Qualifications

• Salesforce certifications such as Data Architect, Integration Architect, Platform App Builder, or equivalent

• Experience with Salesforce Data Cloud

• Consulting or professional services background

• Experience integrating Salesforce with ERP platforms (NetSuite, Oracle, SAP, or similar)

• Exposure to AI, analytics, or advanced data initiatives within the Salesforce ecosystem

Why You’ll Love Working Here

We take care of our people. Our benefits are designed to help you live well—inside and outside of work:

• Competitive health coverage (medical, dental, vision)

• Generous paid time off

• Wellness programs and work-life flexibility

• Community involvement + volunteer opportunities

• Employee recognition and career development support

• A vibrant, supportive culture where we work hard, learn constantly, and celebrate often

Let’s Make an Impact Together

If you’re passionate about delivering exceptional client experiences, leading dynamic teams, and being part of a company that values innovation and heart—you’ll feel right at home at Orion.