Salesforce Data Architect

Orion Global Solutions; Toronto; On-site; CAD 95,000 - 125,000; Full time

Benefits offered by this job

Competitive health coverage

Generous paid time off

Wellness programs

Community involvement opportunities

Career development support

Job summary

A leading tech consultancy in Toronto is seeking a Salesforce Data Architect to design and govern enterprise-grade data architectures across Salesforce platforms. This role requires deep expertise in data modeling, migration strategies, and working collaboratively with solution architects and stakeholders. Ideal candidates will have over five years of Salesforce experience, strong SQL skills, and the ability to ensure data quality and scalability. The position promises a supportive culture and comprehensive benefits.

Qualifications

• 5+ years of experience in Salesforce platforms, with 3+ years in a data-focused role.
• Strong expertise in Salesforce object modeling and schema design.
• Experience with data migration strategies and multi-system environments.

Responsibilities

• Design and own Salesforce data models across core clouds.
• Architect and oversee data migrations from legacy systems.
• Establish and enforce data quality frameworks.

Skills

Salesforce object modeling

Data migration strategies

Advanced SQL

Data governance

Communication skills

Education

Salesforce certifications (Data Architect, Integration Architect)

Tools

MuleSoft

Boomi

Talend

Informatica

ERWin

Lucidchart

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, 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 spoken skills

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.

Ready to grow with us? Apply now. Let's build something great together.