Salesforce Technical Architect (System Integration Engineer, Level II)

Advance Talent Solutions Incorporated; United States; Remote; USD 152,000 - 248,000; Full time

Job summary

ATS+Partners is seeking a senior Salesforce Technical Architect to lead a complex, remote 36‑month modernization program for a New York State agency. You will set technical standards, review vendor work, validate migrations, and architect data strategies across OpenText integrations and large data volumes.

You will mentor State developers, design data models, and ensure seamless transition of support from the vendor to the State while maintaining security and deployment discipline.

Qualifications

• 7+ years on complex projects with 2+ years in a leadership role as System Integration Engineer.
• 84 months of hands-on Salesforce development using Apex, including 12+ months in last 36 months.
• 60 months developing ETL processes for an enterprise data warehouse.
• 36 months as client-side technical lead or architect overseeing a vendor's Salesforce implementation.
• 60 months migrating data from legacy/mainframe systems into Salesforce or other platforms.
• 36 months designing Salesforce solutions for large data volumes (>10 million records).
• 60 months designing master data management solutions incl. matching, deduplication, survivorship rules.
• 60 months developing applications in Microsoft .NET (C# or VB.NET), incl. ASP.NET.
• 36 months integrating enterprise apps with a content management system such as OpenText/Documentum/FileNet/SharePoint

Responsibilities

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

Skills

Salesforce technical leadership

System Integration Engineer

Data migration

Data modeling

Vendor review & acceptance

Proof of concept

Mentor developers

Parallel-run testing

Tools

Apex

ETL tooling

OpenText Content Server

.NET (C#/VB.NET)

Job description

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

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
• 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