Salesforce Data Architect

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, and optimize enterprise-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 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

Data Migration & Integration

Architect and oversee data migrations from legacy systems (ERP, CRM, custom databases)

Define strategies for data synchronization, deduplication, and master data management

Data Quality & Governance

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)

Analytics, Reporting & AI Readiness

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

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

Strong expertise in Salesforce 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

Experience handling large data volumes.

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

Strong communication and 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.