SQL Database Administrator

Location: Nashville, TN (In-Person; Potential Hybrid After Training)
Duration: 6+ months

Type: Contract

Job Description

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 hands-on experience with SQL, advanced Excel, data mapping, and complex dataset analysis. 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.

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 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 data anomalies and quality concerns, document findings, and escalate issues 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 and data extracts.

· 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 the accuracy of source-to-target field mappings.

· Support data migration cycles through data profiling, validation, issue resolution, and testing.

· Contribute to new system architecture, dashboards, reports, and long-term data governance frameworks.

· Manage timelines, deliverables, and multiple workstreams while coordinating with technical and non-technical stakeholders.

Mandatory Skills

• Advanced SQL – Querying, data profiling, reporting, and data integrity validation.
• Advanced Microsoft Excel – Lookups, pivot tables, and data modeling.
• Data Mapping & Documentation – Field identification, source-to-target mapping, and data dictionary maintenance.
• Data Quality & Integrity – Data validation, anomaly detection, discrepancy analysis, and trend analysis.
• Analytical & Problem-Solving Skills – Ability to analyze complex datasets, document findings, and resolve data-related issues.
• Effective communication skills with both technical and non-technical stakeholders