Salesforce Technical Architect, Data Migration

Summary

Join NeuraFlash as a Data Architect – Salesforce CRM Solutions and lead the strategy, design, and execution of complex data architecture and migration initiatives supporting Salesforce CRM implementations. Serve as a strategic advisor and hands-on expert in migrating and integrating customer, sales, and support data, ensuring high data quality, governance, and stewardship. Collaborate with stakeholders, architects, and delivery teams to deliver scalable, secure, and clean data solutions aligned with Salesforce best practices. Conduct data profiling, identify data issues, and lead deduplication efforts. Develop and execute ETL processes using various tools. Facilitate workshops and work closely with cross-functional teams. Standardize data practices through knowledge sharing. NeuraFlash offers remote and in-person work options, travel opportunities, flexible hours, a collaborative environment, and opportunities for celebration.

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

Responsibilities

• Salesforce CRM Data Strategy & Migration
• 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
• Data Architecture, MDM & Governance
• 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
• Deduplication, Data Cleanliness & Quality Assurance
• 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
• Execution & Enablement
• 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
• Stakeholder & Cross-Functional Collaboration
• 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

Preferred Qualifications

• 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

Benefits

• Remote & In-Person: Whether you work out of our HQ in Massachusetts, one of our regional hubs, or you're one of over half of our NeuraFlash Family who work remotely, we’re focused on keeping everyone connected and unified as one team
• Travel: Get ready to pack your bags and hit the road! For certain roles, travel is an exciting part of the job, with an anticipated travel commitment of up to 25%. So, if you have a passion for adventure and don't mind a little jet-setting, this opportunity could be your ticket to exploring new places while making a positive impact on clients
• Flexibility: Do you have to take the dog to the vet, pick up the kids from school, or the in-laws from the airport? We know that a perfect 9-5 isn’t possible. So you have to jump out to do any of those, no problem! We build a culture of trust and understanding. We value good work not the hours in which you get it done
• Collaboration: You have a voice here! If you work with a team of smart people like we do, it’s a no-brainer to take suggestions and feedback on how to keep NeuraFlash thriving. Our executive team holds town halls & company meetings where they address any suggestions or questions asked, no matter how big or small
• Celebrate Often: We take our work seriously, but we don’t take ourselves too seriously. Whether it is an arm wrestling contest, costume party, or ugly holiday sweaters our teams love to have fun. And while we work hard, we don’t forget to slow down and celebrate the big things and the small things together