Data Mapping & Integrity Analyst

Job Description

Job Description

Title: Data Mapping & Integrity Analyst
Location: Nashville, TN (Onsite)
Duration: 8 Months
Interview type In Person Interview

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

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

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

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

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

• Participate in vendor meetings and represent legacy system data needs.
• Review vendor mapping documents and validate accuracy of SourceForge 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.

• Advanced SQL skills for querying, data profiling, and integrity validation
• Strong Excel skills including lookups, pivot tables, and data modelling
• 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

• Data Analysis
• Data Modelling
• Microsoft SQL Server
• SQL
• Excel
• Data Analytics Specialist
• SQL Server Reporting Services (SSRS)