SQL Database Administration - Data Mapping & Integrity Analyst

About the role

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.

Responsibilities

• 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