Senior Data Migration Architect

Summary

Join Neocol as a Senior Data Migration Architect and directly engage with clients to migrate their data from various source systems to Salesforce CRM. You will conduct workshops, define migration scopes, create detailed plans, and execute migrations using tools like Microsoft SQL Server and others. Responsibilities include developing migration scripts, troubleshooting issues, ensuring data integrity, and managing projects from start to finish. You will collaborate with project teams and maintain strong customer relationships. Success requires 5+ years of data migration experience, Salesforce expertise, and specific certifications. Neocol offers a fully remote work environment and a comprehensive benefits package.

Requirements

• 5+ years of data migration experience
• A background and experience in successfully completing Salesforce data migrations
• An understanding of Salesforce object architecture and its operation is crucial
• Project experience with Salesforce CPQ, Salesforce Billing, Salesforce Sales Cloud and Salesforce Service Cloud
• Salesforce CPQ and Platform Developer II Certifications
• Experience in performing multiple data migrations to Salesforce from various other platforms, to include Salesforce to Salesforce, Zuora, Netsuite, Intacct, Hub Spot, ZenDesk, or generic systems
• Experience with Microsoft SQL Server, Python, or Pentaho Data Integration
• Must possess the ability to develop SQL Scripts to include an understanding of Inner and Outer Joins, Common Table Expressions (CTEs), aliases, use of functions
• Ability to resolve logical problems and issues in fast paced environments
• Demonstrated ability to be a self-starter and work well within a team environment

Responsibilities

• Conduct workshops with customers regarding data migration processes and gather requirements
• Define and refine data migration scope on projects, addressing any variances along the way
• Create data migration plans, inclusive of timelines and milestones, in conjunction with customers and project teams to lead to successful closeout of projects based on data requirements
• Create field mapping, maintain user stories and Jira tickets, develop migration scripts, execute migration to test and production environments, and troubleshoot/resolve issues
• Perform detailed review of data from customers, verifying integrity of data, as well as looking for possible errors
• Participate in multiple engagements simultaneously while ensuring deadlines and quality are being met
• Seek efficiencies and standardization in data migration processes
• Manage complex migration projects from beginning to end
• Create a positive customer experience by building strong customer relationships
• Conduct regular check-in meetings with customers/project teams to provide status updates, address roadblocks and issues, and ensure overall projects remain on track for the data migration portion of projects
• Provide clear and detailed documentation of deployment steps, migration processes, test load results and recommended areas for testing
• Collaborate closely with project teams at Neocol to ensure overall solutions include data migration considerations

Preferred Qualifications

• Use and familiarity of Github, JIRA, and LucidChart are a plus
• Familiarity with extracting and importing data to SQL from CSV, Excel, JSON, or other file formats is helpful
• Salesforce Administration, App Builder, and Platform Developer I Certifications
• Billing Badge, Advanced Billing Specialist Badge
• Experience with DBAmp and Dataloader a plus

Benefits

• Fully remote workforce ensures that you have the tools you need to successfully perform your job and create a proper balance of work and personal life
• Employer match 401(k) plan
• Medical, vision & dental benefit offerings
• Adoption Assistance Program
• Flexible PTO
• Mobile & Internet reimbursement
• Certification Bonus Program