Data Mapping & Integrity Analyst

Generis TEK Inc.; Nashville (TN); On-site; USD 55,000 - 90,000; Part time

Job summary

First Roles is seeking a Data Mapping & Integrity Analyst for a Nashville-based contract role with the Tennessee Department of Health. The position focuses on data quality, documentation, and modernization efforts for the Licensure and Regulation System (LARS).

The role requires strong SQL, advanced Excel, and experience analyzing complex datasets. You will document findings, support reporting requests, and participate in modernization activities with stakeholder engagement.

Qualifications

• Advanced SQL for data profiling, validation and integrity checks.
• Strong Excel skills including lookups, pivots, and data modeling.
• Experience with data mapping and comprehensive documentation.
• Excellent analytical and problem-solving abilities.
• Strong ability to manage timelines, deliverables, and multiple workstreams.
• Effective communication with technical and non-technical stakeholders.

Responsibilities

• Identify, validate, and document all existing fields in the LARS legacy system.
• Analyze field relationships and dependencies across extracts, certificates, API data feeds.
• Update data mapping documentation when gaps are found.
• Maintain a centralized data dictionary for agency-wide reference.
• Perform SQL-driven data profiling and trend analyses.
• Collaborate with business units to validate data usage and improve data entry practices.
• Support data migration testing and modernization efforts.

Skills

Advanced SQL skills

Excel proficiency

Data mapping & documentation

Analytical thinking

Project/time management

Stakeholder communication

Tools

SQL

ServiceNow

Excel

Job description

We have Contract role Data Mapping & Integrity Analyst for client at Nashville, TN. Please let me know if you or any of your friends would be interested in this position.

Position Details: Data Mapping & Integrity Analyst -Nashville TN Location : Nashville, TN 37243 Onsite Project Duration : 7+ months of contract

The Tennessee Department of Health 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.

Key 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 elevate 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 look ups, 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