Job description

A state government health agency is seeking a highly analytical Data Mapping & Integrity Analyst to support data quality, documentation and modernization of a legacy licensure and regulation system. You will lead field identification and mapping, run SQL-driven data integrity reviews, deliver reporting through ticket requests, and validate source-to-target mapping for the system's modernization. Strong SQL, advanced Excel and clear stakeholder communication are essential. • Identify, validate and document all fields in the legacy licensure system • Analyze field relationships and usage across extracts, correspondence, certificates and API feeds • Maintain a centralized data dictionary and data mapping documentation • Perform recurring SQL-driven data profiling, validation checks and trend analyses • Identify anomalies, track systemic data risks and recommend governance improvements • Collaborate with business units to validate data usage and improve data entry practices • Respond to ServiceNow and help desk tickets for reporting, data pulls and system administration • Write and execute SQL queries and store reports and scripts in the designated repository • Participate in vendor meetings and review source-to-target mapping documents • Support data migration cycles with profiling, validation, issue resolution and testing • Contribute to new system architecture, dashboards, reports and data governance frameworks

Requirements

Must-haves

Identify, validate and document all fields in the legacy licensure system
Analyze field relationships and usage across extracts, correspondence, certificates and API feeds
Maintain a centralized data dictionary and data mapping documentation
Perform recurring SQL-driven data profiling, validation checks and trend analyses
Identify anomalies, track systemic data risks and recommend governance improvements
Collaborate with business units to validate data usage and improve data entry practices
Respond to ServiceNow and help desk tickets for reporting, data pulls and system administration
Write and execute SQL queries and store reports and scripts in the designated repository
Participate in vendor meetings and review source-to-target mapping documents
Support data migration cycles with profiling, validation, issue resolution and testing
Contribute to new system architecture, dashboards, reports and data governance frameworks

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlapi

Platform: careers-html
Effort: medium