Salesforce Technical Architect (System Integration Engineer, Level II)

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

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