Data Mapping and Integrity Analyst

Data Mapping & Integrity Analyst – SQL, Data Quality & Data Modeling

Job Title : Data Mapping & Integrity Analyst – SQL, Data Quality

Location: Nashville, Tennessee

Work Arrangement : In-person, with potential for some hybrid work after training

Residency Requirement : Candidate must be a Tennessee state resident

Estimated Start Date : 11/09/2026

Estimated End Date : 06/30/2027

Schedule : Monday–Friday

Working Hours : 8:00 AM–4:30 PM CST

Hours per Day : 7.5

Rate: $25-$30

Contractors relocating to Tennessee must establish residency prior to their start date

Position Overview:

A highly analytical Data Mapping & Integrity Analyst is needed to support ongoing data quality, documentation, and modernization efforts for a legacy licensure and regulation system

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

Required Skills / Experience:

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 problemsolving skills

Ability to manage timelines, deliverables, and multiple workstreams

Effective communication skills with both technical and non-technical stakeholders

Required Qualification Levels:

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)

Preferred Skills / Experience:

SQL Server Reporting Services (SSRS) , Expert (10+ Years) , Not Required

Primary Objectives:

Develop and maintain a complete field mapping framework for the 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 modernization by validating source-to-target mapping, participating in vendor meetings, and supporting data migration testing cycles

Job Responsibilities:

1. Field Identification, Mapping & Documentation:

Identify, validate, and document all existing fields in the 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

1. 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

1. 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

1. Modernization Project Support:

Participate in vendor meetings and represent legacy system data needs

Review vendor mapping documents and validate accuracy of sourcetotarget fields

Support data migration cycles with profiling, validation, issue resolution, and testing

Contribute to new system architecture, dashboards, reports, and longterm data governance frameworks

Ideal Candidate:

Based on the required qualifications and responsibilities, the strongest candidate is a senior data analyst / data integrity specialist with deep hands-on SQL experience who has worked with complex legacy databases and can independently investigate, document, validate, and explain data

The ideal candidate should combine:

SQL + Microsoft SQL Server + Data Analysis + Data Modeling + Advanced Excel + Data Mapping

The candidate should be particularly strong in:

Data Profiling + Data Quality + Data Validation + Source-to-Target Mapping + Data Dictionaries + SQL Reporting + Root-Cause Analysis

The strongest candidate will not simply be someone who runs SQL reports

The role requires someone who can understand how fields are structured and used across systems, identify inconsistencies and systemic data risks, document relationships and dependencies, and support modernization and migration activities

Experience working with ServiceNow, help desk reporting requests, vendor mapping documents, data migration testing, API feeds, dashboards, reporting, and data governance would align especially well with the work described

Because the qualification matrix requires 10+ years of SQL and Microsoft SQL Server and 7–9 years of Data Analysis, Data Modeling, Excel, and Data Analytics Specialist experience, this role is best suited to a highly experienced data professional rather than a junior or mid-level analyst