Salesforce technical architect (system integration engineer, level ii)

This is a remote position.

ATS+Partners is seeking a senior Salesforce Technical Architect for a fully remote, 36-month engagement supporting a New York State agency's Salesforce modernization program. The consultant will serve as the State's technical lead and architect, representing the agency's interests with the implementation vendor.

Responsibilities:

• Define Salesforce technical standards for coding, configuration, naming, security, and deployment
• Review the vendor's architecture, data model, security model, integrations, code, and deployments, and recommend acceptance or rejection
• Review the large data volume strategy, including indexing, query performance, archiving, and record retention
• Independently validate the data migration from the legacy system, including mapping, record counts, reconciliation, and data quality
• Review the integration with an OpenText Content Server document management system
• Define and run parallel-run and reconciliation testing against legacy system outputs
• Design and build data warehouse models and ETL processes, and support data feeds to other agencies
• Design master data for core business entities and align the vendor's data model to it
• Analyze, maintain, and integrate existing .NET applications until they are retired
• Build proofs of concept, mentor State developers, and plan the transition of support from the vendor to the State

Requirements

Mandatory qualifications:

• More than 7 years of experience on complex projects, including 2 or more years in a leadership role as a System Integration Engineer
• 84 months of hands-on Salesforce development using Apex, including at least 12 months within the last 36 months
• 60 months developing ETL processes for an enterprise data warehouse

Desirable qualifications:

• 36 months as a client-side technical lead or architect overseeing a vendor's Salesforce implementation, including design and code reviews
• 60 months migrating data from legacy or mainframe systems into Salesforce or other modern platforms
• 36 months designing Salesforce solutions for large data volumes (more than 10 million records in a single object)
• 60 months designing master data management solutions, including matching, de-duplication, and survivorship rules
• 60 months developing applications in Microsoft .NET (C# or VB.NET), including ASP.NET
• 36 months integrating enterprise applications with a content management system such as OpenText, Documentum, FileNet, or SharePoint