Data Administrator/Database Administrator

STI•Nashville, TN

2d•Onsite

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 the identification, documentation, and assessment of fields across the legacy system and supports data 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 in person at 665 Mainstream Dr, Nashville, TN 37243, with the potential for some hybrid work after training. The schedule is Monday through Friday, 8:00 AM–4:30 PM CST.

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

Develop and maintain a complete field mapping framework for the LARS legacy system.
Identify, validate, and document all existing fields in the LARS legacy system.
Analyze field relationships, dependencies, and use across extracts, correspondence, certificates, and API data feeds.
Update data 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 data anomalies and quality concerns, document findings, and escalate 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 deliver accurate reporting outputs; 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.