Salesforce Data Architect

NeuraFlash, Part of Accenture

11h•Hybrid

About The Position

As a Data Architect – Salesforce CRM Solutions, you will lead the strategy, design, and execution of complex data architecture and migration initiatives that support Salesforce CRM implementations across Sales, Service, and Experience Cloud. You will serve as a strategic advisor and hands-on expert in migrating and integrating customer, sales, and support data while ensuring the highest standards of data quality, governance, and stewardship. You will collaborate with business stakeholders, technical architects, and delivery teams to deliver scalable, secure, and clean data solutions aligned with Salesforce best practices and enterprise transformation goals.

Requirements

5+ years of experience in data architecture and CRM data migrations, with a strong focus on Salesforce platforms
Deep understanding of Salesforce data models across Sales Cloud, Service Cloud, Experience Cloud, and custom apps
Experience with tools such as Informatica Cloud, Informatica MDM, DBAmp, Dataloader, or similar ETL/data integration tools
Strong SQL skills for data analysis, cleansing, and transformation (joins, window functions, data profiling)
Proven experience with deduplication, data cleansing, and improving data quality at scale
Demonstrated knowledge of MDM frameworks, data stewardship, and governance best practices

Nice To Haves

Experience integrating Salesforce with ERP, marketing, and support platforms (e.g., SAP, NetSuite, Marketo, Zendesk)
Experience with Salesforce Data Cloud, MuleSoft, or custom API-based integrations
Familiarity with Agile project methodologies and tools like Jira, Confluence, and Git
Salesforce certifications: Admin, Data Architecture & Management Designer, Integration Architecture Designer
Background in RevOps, enterprise CRM strategy, or customer 360 initiatives

Responsibilities

Design and lead data migration plans covering core Salesforce entities such as accounts, contacts, leads, opportunities, activities, cases, and custom objects.
Develop scalable data migration frameworks that support phased, delta, and full-load approaches across Salesforce environments.
Drive alignment of legacy data models to Salesforce architecture, considering business rules, relationships, and multi-org/multi-currency configurations.
Define canonical data models and develop field-level mapping and transformation logic from source systems to Salesforce.
Collaborate with MDM teams to establish golden record definitions and implement identity resolution strategies across systems.
Implement governance controls, data stewardship policies, and compliance mechanisms (e.g., GDPR, CCPA) to ensure trusted and compliant data usage.
Ensure data lineage and integrity across the CRM ecosystem by working closely with enterprise architects and data owners.
Conduct comprehensive data profiling, identify duplicates, incomplete records, and inconsistent values across datasets.
Lead deduplication efforts using tools such as Informatica Cloud Data Quality, DemandTools, or custom scripts.
Design rules and processes for data cleansing, normalization, and enrichment to ensure completeness and accuracy of migrated and integrated data.
Establish data quality KPIs and continuously monitor and report on data integrity across the Salesforce platform.
Develop and execute ETL processes using tools such as Informatica (Cloud and MDM), DBAmp, Pentaho, Dataloader, or SQL-based frameworks.
Manage iterative data loads into Salesforce sandboxes and production environments, validating against source system records and business rules.
Deliver thorough documentation, test plans, and support materials to enable stakeholder adoption and long-term maintenance.
Facilitate workshops with business stakeholders to define data requirements, risks, and success metrics.
Work closely with Salesforce Solution Architects, Admins, Developers, RevOps, and QA teams to ensure data supports end-to-end business processes.
Standardize data practices by contributing to internal playbooks, templates, accelerators, and knowledge sharing initiatives.