Salesforce Technical Architect - 8+ Yrs Exp

Duties and Responsibilities

• 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 Salesforce technical standards, including coding, configuration, naming, security, and deployment standards 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 acceptance or rejection to State management.
• Review the vendor's code, configuration, and deployments against State standards, identifying defects, technical debt, and design risks before acceptance.
• Verify that the vendor's designs and deliverables align with documented business requirements, including all case types and rent calculation rules.
• Review the vendor's large data volume strategy, including 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, ensuring existing documents and scanned images are linked to new Salesforce case, registration, building, and apartment records, with appropriate access security and retention rules. Ensure document links survive the transition from legacy identifiers to new identifiers.
• Define and execute parallel-run and reconciliation testing to compare Salesforce results with 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 data warehouse models and ETL processes to 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 core business entities, including buildings, apartments, owners, and other parties, and ensure 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 are 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 by defining required skills, mentoring and training State developers, and involving them in vendor work to prepare them for the takeover.
• Plan and manage the transition of support from the vendor to the State, ensuring source code, environments, administrative access, documentation, and support procedures are handed over before the contract ends.
• Participate in vendor sprint reviews and design sessions with business analysts, project managers, and program staff.

Mandatory Qualifications

• Experience working on complex projects, with 2 or more years in a leadership role as a System Integration Engineer.
• Hands-on Salesforce development experience using Apex, including at least 12 months within the 36 months before the Staff Augmentation Tier II submission date.
• Experience developing ETL (Extract, Transform, Load) processes for an enterprise data warehouse.

Desirable Qualifications

• Experience as a 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.
• Experience migrating data from legacy or mainframe systems into Salesforce or other modern platforms, including data mapping, cleansing, and reconciliation.
• Experience designing Salesforce solutions for large data volumes (more than 10 million records in a single object), including query performance and data archiving strategies.
• Experience designing and implementing master data management solutions, including matching, de-duplication, and survivorship rules.
• Experience developing and maintaining applications using Microsoft .NET (C# or VB.NET), including ASP.NET web applications.
• Experience integrating Salesforce or other enterprise applications with an enterprise content management system (e.g., OpenText Content Server, OpenText Extended ECM, Documentum, FileNet, SharePoint).