Salesforce Data Architect

Salesforce Data ArchitectCanada, United States, RemoteAt 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 RoleWe 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.Data Architecture & DesignDesign and own Salesforce data models across core clouds (Sales, Service, Financial Services, Consumer Goods)Define object models, relationships, field strategy, and data lifecycle managementEnsure scalability, performance, and alignment with Salesforce best practicesLead data governance, naming conventions, and standardsData Migration & IntegrationArchitect and oversee data migrations from legacy systems (ERP, CRM, custom databases)Define strategies for data synchronization, deduplication, and master data managementData Quality & GovernanceEstablish and enforce data quality frameworks (validation, deduplication, enrichment)Partner with stakeholders on data ownership, stewardship, and complianceSupport regulatory and security requirements (PII, GDPR, role-based access)Analytics, Reporting & AI ReadinessDesign data structures optimized for Salesforce reporting, dashboards, and analyticsEnable downstream use cases for Einstein, AI, and advanced analyticsSupport Data Cloud and Customer 360 initiatives where applicableWhat You Bring5+ years of experience working with Salesforce platforms, including 3+ years in a data-focused role such as Data Architect or Senior Data SpecialistStrong 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 environmentsHands-on experience with Salesforce integrations using REST and SOAP APIsExperience with ETL and middleware tools such as MuleSoft, Boomi, Talend, or InformaticaAdvanced SQL and data analysis skillsExperience handling large data volumes.Knowledge of data modeling tools (ERWin, Lucidchart, etc.)Strong communication and problem-solving capabilities, with professional written and spokenPreferred QualificationsSalesforce certifications such as Data Architect, Integration Architect, Platform App Builder, or equivalentExperience with Salesforce Data CloudConsulting or professional services backgroundExperience integrating Salesforce with ERP platforms (NetSuite, Oracle, SAP, or similar)Exposure to AI, analytics, or advanced data initiatives within the Salesforce ecosystemWhy You'll Love Working HereWe 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 offWellness programs and work-life flexibilityCommunity involvement + volunteer opportunitiesEmployee recognition and career development supportA vibrant, supportive culture where we work hard, learn constantly, and celebrate oftenLet's Make an Impact TogetherIf 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.