Analyze, design, code, test, and implement Salesforce Public Sector Solutions application code
Develop integrations using Salesforce APIs to connect Salesforce with State and legacy systems
Design and implement Licensing, Permitting, and Inspections (LPI) solutions using Salesforce PSS data models
Collaborate with Salesforce administrators on release cycles and deployments
Follow DoIT coding standards and best practices, including test-driven development and low-code/no-code principles
Produce estimates for development tasks and review peers estimates for accuracy and completeness
Create data models, tables, and dimension models using Informatica ETL tools
Lead and execute end-to-end data migrations from legacy systems into Salesforce
Assess source systems, including data volume, quality, schemas, and integration points
Define migration approaches, including ETL/ELT methods, migration waves, incremental vs. full loads, and cutover strategies
Map legacy data to Salesforce standard and custom objects, record types, relationships, and external IDs
Define and implement data transformation rules, normalization standards, and deduplication logic
Ensure hierarchy and referential integrity across accounts, contacts, cases, and related records
Conduct dry runs and performance testing with realistic data volumes
Orchestrate final data loads, post-load remediation, and index updates
Validate automations to ensure migrated data does not break triggers, flows, or validation rules
Use tools such as Data Loader and Data Import Wizard for migration execution
Ensure protection of PHI, PII, and PCI data throughout development and migration activities
6 8 years of experience designing and implementing Salesforce Public Sector Solutions, specifically Licensing, Permitting, and Inspections data models
5 8 years of hands-on experience with OmniStudio (OmniScripts, DataRaptors, Integration Procedures)
4+ years of end-to-end data migration experience from legacy systems to Salesforce
4+ years of experience configuring complex Salesforce sharing models
Strong experience integrating Salesforce with external and legacy systems using APIs
Ability to work independently while collaborating within a development team
Experience estimating work, managing risks, and identifying blockers
Ability to work Eastern Time Zone business hours
All education, degrees, and certifications must include completion dates