Director of Data Architecture

Neocol•Chicago, IL

8d•Remote

About The Position

Neocol partners with the world's most innovative subscription businesses to solve complex, high-impact challenges and unlock scalable growth. As a leading Salesforce Summit Partner, we bring deep expertise in Agentforce Revenue Management and the broader Salesforce ecosystem to help customers transform how they sell, service, and scale. What sets Neocol apart is not just our technical depth, but how we work. We've built proven playbooks, accelerators, and delivery models that empower teams to move quickly, confidently, and with purpose — always with a focus on meaningful outcomes. At Neocol, you'll join a team that values expertise, curiosity, and ownership — and gives you the opportunity to make a measurable impact in the subscription economy. As the Director of the Data Architecture team, you will directly engage with customers with the goal of migrating customer data from a source system to Salesforce CRM. This data will typically include a combination of CPQ (Configure Price Quote), Billing, Sales, and Service Cloud information. You will lead a team of Data Migration Architects and Consultants while also performing individual contributions to external projects. You will work with Microsoft SQL Server, DBAmp, and various other tools to extract, transform, and load data from the source system into Salesforce.

Requirements

6+ years of data migration experience
4+ years of management experience
Background and experience in successfully completing Salesforce data migrations
Understanding of Salesforce object architecture and its operation
Project experience with Salesforce CPQ, Salesforce Sales Cloud, and Salesforce Service Cloud
Salesforce Administrator, App Builder, and Platform Developer I certifications
Experience performing multiple data migrations to Salesforce from various platforms (Salesforce to Salesforce, Zuora, NetSuite, Intacct, HubSpot, ZenDesk, or generic systems)
Experience with Microsoft SQL Server and T-SQL scripting
Ability to develop SQL scripts including understanding of Inner and Outer Joins, Common Table Expressions (CTEs), aliases, use of functions
Ability to follow best practices for T-SQL development
Ability to resolve logical problems and issues in fast-paced environments
Self-starter with ability to work well within a team environment
Collaborative approach, working together as a team to drive value in every interaction and implementation
Creative problem-solving in the way we solution with customers and work with teammates
Commitment to trust, operating in a fun, open, and ethical environment
Results-focused mindset with ownership of critical metrics
Passionate about what you do, why you do it, and the impact it has on customers, employees, and partners

Nice To Haves

Use and familiarity with Github, JIRA, and LucidChart
Familiarity with extracting and importing data to SQL from CSV, Excel, JSON, or other file formats
Familiarity with any other ETL or iPaaS tool
Familiarity with Salesforce Billing
Salesforce CPQ and Platform Developer II certifications
Billing Badge, Advanced Billing Specialist Badge
Experience with DBAmp and Dataloader

Responsibilities

Participate in customer workshops to discuss data migration processes and gather requirements
Create of data migration plans, including timelines and milestones, to ensure successful project completion
Create field mappings, maintain user stories and Jira tickets, develop migration scripts, execute migrations to test and production environments, and troubleshoot/resolve issues
Perform detailed reviews of customer data, verifying data integrity and identifying possible errors
Participate in multiple engagements simultaneously, ensuring deadlines and quality standards are 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
Participate in regular check-in meetings with customers and project teams to provide status updates and address roadblocks
Provide clear and detailed documentation of deployment steps, migration processes, test load results, and recommended testing areas
Collaborate closely with Neocol project teams to ensure overall solutions include data migration considerations