Salesforce Technical Architect / Lead

Duties and Responsibilities to be performed by the consultant

• Serve as the State's Salesforce technical expert and architect for the Rent Regulation System Modernization (RRSM) project, representing ITS and HCR technical

interests with the implementation vendor.

• Define the Salesforce technical standards (coding, configuration, naming, security, and deployment) that the vendor must follow and the State team will inherit.
• Review the vendor's architecture, data model, security model, and integration designs for quality, scalability, and long-term supportability, and recommend

PRD Number PRD-152

Request Date 10/1/2026

Designated Work L ocation

38-40 State St, Bldg. Hampton Plaza - 82Q, Albany, NY, 12257

Anticipated Duration of the E ngagement

36

Number of C andidate Response Forms Vendors can Submit

1

Job L ocation

Albany Job Location

• Review the vendor's architecture, data model, security model, and integration designs for quality, scalability, and long-term supportability, and recommend

acceptance or rejection to State management.

• Review the vendor's code, configuration, and deployments against State standards, and identify defects, technical debt, and design risks before they're accepted.
• Verify that the vendor's designs and deliverables trace back to documented business requirements, including all case types and rent calculation rules.
• Review the vendor's large data volume strategy (indexing, query performance, data archiving, and record retention) for decades of building, apartment, and rent

history data.

• Independently validate the vendor's data migration from the legacy rent regulation system, including data mapping, record counts, reconciliation, and data quality.
• Review the vendor's integration with the agency's OpenText Content Server document management system, including how existing documents and scanned images

are linked to new Salesforce case, registration, building, and apartment records, how access is secured, and how retention rules are applied. Make sure links to existing

documents survive the change from legacy identifiers to new ones.

• Define and run parallel-run and reconciliation testing that compares Salesforce results to legacy system outputs for registrations, legal rent calculations, and case

processing.

• Work with the agency's legacy system staff to capture and document business rules, data structures, and interfaces from the legacy rent regulation system.
• Design and build the data warehouse models and ETL processes that bring Salesforce and legacy data into the agency's data warehouse, and support data feeds to

other State and City agencies.

• Design master data for the core business entities (buildings, apartments, owners, and other parties) and make sure the vendor's Salesforce data model aligns with it.
• Analyze the agency's existing .NET applications, document their business rules and data for the vendor's replacement work, and maintain and integrate them until

they're retired.

• Develop hands-on proofs of concept and State-owned components to test vendor approaches and estimates.

Help build the State's Salesforce support team

define the skills needed, mentor and train State developers, and involve them in vendor work so they're ready to take

over.

• Plan and manage the transition of support from the vendor to the State, making sure source code, environments, administrative access, documentation, and support

procedures are handed over before the contract ends.

• Take part in vendor sprint reviews and design sessions with business analysts, project managers, and program staff.

Mandatory Qualifications

Level II- More than seven (7) years of experience working on complex projects with 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 36 months before the Staff Augmentation Tier II submission date

60 months developing ETL (extract, transform, load) processes for an enterprise data warehouse

Desirable Qualifications

36 months as the client-side (customer or agency) technical lead or architect overseeing a vendor's or systems integrator's Salesforce implementation, including

reviewing designs and code and verifying deliverables.

60 months migrating data from legacy or mainframe systems into Salesforce or other modern platforms, including data mapping, cleansing, and reconciliation.

36 months designing Salesforce solutions for large data volumes (more than 10 million records in a single object), including query performance and data archiving

strategies.

60 months designing and implementing master data management solutions, including matching, de-duplication, and survivorship rules.

60 months developing and maintaining applications using Microsoft .NET (C# or VB.NET), including ASP.NET web applications.

36 months integrating Salesforce or other enterprise applications with an enterprise content management system (e.g., OpenText Content Server, OpenText Extended

ECM, Documentum, FileNet, SharePoint).