Data Mapping & Integrity Analyst - Onsite Nashville, Tennessee
About The Position
The Tennessee Department of Health is seeking a highly analytical Data Mapping & Integrity Analyst to support data quality, documentation, and modernization efforts for the Licensure and Regulation System (LARS). The role leads identification, documentation, and assessment of legacy-system data fields and supports integrity reviews, reporting, and modernization activities. It helps ensure consistent, accurate, and reliable data use across extracts, correspondence, certificates, API feeds, and modernization mapping efforts. The position is onsite in Nashville, Tennessee, with potential for some hybrid work after training. The schedule is Monday through Friday, 8:00 AM–4:30 PM CST, at 665 Mainstream Dr, Nashville, TN 37243.
Requirements
- 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 technical and non-technical stakeholders.
Responsibilities
- Identify, validate, and document all existing fields in the LARS legacy system.
- Analyze field relationships and dependencies, including how fields are used across extracts, correspondence, certificates, and API data feeds.
- Update mapping documentation when inconsistencies or gaps are identified and maintain a centralized data dictionary for agency-wide reference.
- Perform recurring SQL-driven data profiling, validation checks, and trend analyses.
- Identify and document anomalies and data quality concerns, escalating findings as needed.
- Track recurring issues and 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 provide accurate reporting outputs and ensure results are validated and clearly documented.
- 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 source-to-target fields.
- Support data migration cycles through profiling, validation, issue resolution, and testing.
- Contribute to new system architecture, dashboards, reports, and long-term data governance frameworks.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
No Education Listed
