SW – NH HHS – Salesforce PSS Developer w/Data Migration Exp

Job Description

IMPORTANT – READ FULLY:

1 -Candidates MUST have experience working as a developer with Salesforce’s dedicated data model: Public Sector Solutions. This does not mean your candidate has worked with Salesforce in the public sector- they must have specifically with the actual Salesforce Public Sector Solutions (PSS) dedicated data model. This specific role requires specific experience implementing the Licensing, Permitting, and Inspections PSS data models and end-to-end data migration from legacy systems into Salesforce in their development role. If candidates have not worked in development with these specific PSS data models and have the data migration experience required, DO NOT SUBMIT THEM – they will not be considered for the role.
2 -Position can be fully remote- selected resources must be located within the contingent United States and must remain within the contingent United States for all work while in this role. Candidates must be able to work on the client’s Eastern Time Zone business hours.
3 – Position will have a 37.5-hour work week, NOT a 40-hour workweek.

4 -Any education, degrees, and certifications listed on the resume MUST contain a valid degree/certification details, INCLUDING the date the certification/degree was acquired or candidates will not be considered.

5 – Professional references required upon submittal -When submitting your candidate, include a Word document that includes contact info for THREE professional references for your candidate – upload this in the same section on the Reference tab as you upload the Resume and RTR. These references must be supervisory references from past employment, and at least one of the three must be a supervisor from employment where the candidate worked in a role similar to what is being requested for this position. References must include the full name, phone number, and email address for the reference AND must note where, when, and how the reference worked with the submitted candidate. If you do not include the required references at time of submittal OR we find the references provided have been falsified, your candidate will be removed from consideration.

JOB DETAILS / RESPONSIBILITIES:

• Create integrations using Salesforce APIs to integrate with other
systems used in the State, including legacy systems. This role will focus heavily on licensing, permitting, and inspections PSS (Public Sector Solutions) data model expertise.

• Creates tables, data models, dimension models utilizing Informatica ETL
tools.

• Produce estimates of time and resources required to perform various
tasks as part of a team. Reviews estimates for accuracy and completeness
composed by other team members.

• Work as directed by DoIT management to meet DoIT coding standards and
best practices and should be familiar with test-driven development and “no
code, low code, custom” maxim.

• Collaborate with Salesforce administrators on release cycles to deploy
new functionality and updates to existing applications, objects, and code.

• Data migration Specialty to include Assess source systems: Profile
legacy data, schemas, volumes, quality issues, and integration points.

• Define migration approach: Choose ETL/ELT methods, waves
(accounts/contacts → opportunities → cases → activities), full vs. incremental
loads, and cutover strategy

• Estimation & risk planning: Size effort, identify blockers
(duplicates, missing keys, orphan records), and prepare mitigation plans.

• Map legacy entities to Salesforce objects (Standard &
Custom), including Master-Detail vs. Lookup relationships, External IDs & Natural
Keys, Record Types, Business Processes, and picklist value harmonization

• Define transformation rules: Normalize addresses, standardize
phone/email, units, time zones, and product catalogs.

• Handle hierarchy & referential integrity: Parent account
trees, contact-account links, case relationships.

• Stage & transform data in landing zones; implement dedupe
logic and survivorship rules.

• Profile & remediate missing values, invalid formats,
inconsistent reference data, apply dedupe rules using Matching Rules/Duplicate
Rules; implement fuzzy matching when needed.

• Config as code to store mappings, transformations, validation
queries, and runbooks in repo.

• Performance testing to include dry runs with realistic volumes to
validate timing and resource utilization.

• Orchestrate final loads, post-load fixes, and index updates

•Validation of rules automation to ensure migrated data won’t break
triggers, flows, validations.

• Utilize existing migration pipelines with tools like Data Loader
/ Data Import Wizard

• Must be comfortable taking appropriate steps to protect PHI/PII/PCI.

Skills and technologies:

• 6-8 years’ Experience designing and implementing Licensing, Permitting, & Inspections data model solutions using Salesforce Public Sector Solutions, including
application intake, approvals, inspections, and compliance workflows.

• 5-8 years’ experience Hands-on expertise with Omnistudio (Omniscripts, Dataraptor,
Integration Procedures) to build scalable, user-friendly digital experiences
and automate complex business processes

• 4 years’ end-to-end data migration (mapping, transformation, load, validation) migrating data from legacy systems to Salesforce

• 4 years’ experience configuring complex sharing models leveraging combinations of the following: sharing sets, sharing rules, roles, queues, public groups, case teams, and/or territories.

• 4 years’ experience working with Salesforce Public Sector Solutions application intake, approvals, inspection, and compliance workflows
• 5-8 years of experience with
APEX, SOQL, Creating Workflows, SDLC, Agile SCRUM.

Additional Preferred Experience:
• 4 years’ experience bulk data loading via Data Loader / CLI Data Loader
• 4 years’ experience profiling legacy data (SQL queries, profiling tools) and Data cleansing, normalization, dedupe methodologies
• 4 years’ experience executing migration runbooks in production.

• Highly Preferred experience: Copado, SAFe Agile

• Preferred certifications: Certified Salesforce Developer and Certified
Salesforce Administrator