The client is seeking a highly analytical Data Mapping & Integrity Analyst to support ongoing data quality, documentation, and modernization efforts for the Licensure and Regulation System (LARS).
This role will lead the identification, documentation, and assessment of data fields across the legacy system while supporting data integrity reviews, reporting needs, and modernization activities.
The ideal candidate will have strong SQL skills, advanced Excel proficiency, and experience analyzing complex datasets.
Clear communication, stakeholder engagement, and the ability to document technical findings comprehensively are essential.
This position plays a critical role in ensuring consistent, accurate, and reliable data use across extracts, correspondence, certificates, API feeds, and modernization mapping efforts.
Primary Objectives:
Develop and maintain a complete field mapping framework for the LARS legacy system.
Conduct recurring data integrity and quality assessments to identify discrepancies, structural issues, and systemic data risks.
Support ServiceNow and help desk ticket requests for reporting, data pulls, and system administration.
Contribute to LARS modernization by validating source-to-target mapping, participating in vendor meetings, and supporting data migration testing cycles.
Job Responsibilities: Field Identification, Mapping & Documentation
Identify, validate, and document all existing fields in the LARS legacy system.
Analyze field relationships, dependencies, and how each field is used across extracts, correspondence, certificates, and API data feeds.
Update data mapping documentation when inconsistencies or gaps are identified.
Maintain a centralized data dictionary for agency-wide reference.
Data Integrity & Quality Review
Perform recurring SQL-driven data profiling, validation checks, and trend analyses.
Identify anomalies and data quality concerns; document findings and escalate as needed.
Track recurring issues, systemic data risks, and recommend improvements or governance standards.
Collaborate with business units to validate data usage and improve data entry practices.
Ticket & Reporting Support
Respond to help desk and ServiceNow ticket requests within established timelines.
Write and execute SQL queries to deliver accurate reporting outputs.
Ensure all requested data delivers validated, clearly documented results.
Store completed reports and SQL scripts in the designated repository.
Modernization Project Support
Participate in vendor meetings and represent legacy system data needs.
Review vendor mapping documents and validate accuracy of source to target fields.
Support data migration cycles with profiling, validation, issue resolution, and testing.
Contribute to new system architecture, dashboards, reports, and long-term data governance frameworks.
Required Skills & Qualifications:
Advanced SQL skills for querying, data profiling, and integrity validation
Strong Excel skills including lookups, pivot tables, and data modeling
Experience with data mapping and documentation
Strong analytical and problem-solving skills
Ability to manage timelines, deliverables, and multiple workstreams
Effective communication skills with both technical and non-technical stakeholders
Skills Matrix:
Data Analysis Advanced (7-9 Years)
Data Modeling Advanced (7-9 Years)
Microsoft SQL Server Expert (10+ Years)
SQL Expert (10+ Years)
Excel Advanced (7-9 Years)
Data Analytics Specialist Advanced (7-9 Years)
SQL Server Reporting Services (SSRS) Expert (10+ Years)
Numbers & Facts
Location
Nashville, TN
Salary
$30–$32 Per Hour
Skills
Analysis Skillsunmatched
Communication Skillsunmatched
Data Administrationunmatched
Data Analysisunmatched
Data Entryunmatched
Data Formatsunmatched
Data Mappingunmatched
Data Migrationunmatched
Data Modelingunmatched
Data Profilingunmatched
Data Qualityunmatched
Data Setsunmatched
Database Administrationunmatched
Delivery Managementunmatched
Documentationunmatched
Field Mappingunmatched
Groundskeepingunmatched
Help Deskunmatched
Microsoft Excelunmatched
Microsoft SQL Serverunmatched
Pivot Tablesunmatched
Problem Solving Skillsunmatched
Regulationsunmatched
Reporting Dashboardsunmatched
SQL (Structured Query Language)unmatched
SQL Server Reporting Services (SSRS)unmatched
Scripting (Scripting Languages)unmatched
ServiceNowunmatched
System Architectureunmatched
Systems Administration/Managementunmatched
Technical Writingunmatched
Testingunmatched
Time Managementunmatched
Trend Analysisunmatched
Validation Testingunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.