Data Administrator/Database Administrator :: Nashville, TN (Onsite)

Seeking for a Data Administrator/Database Administrator to support ongoing data quality, documentation, and modernization efforts for the Licensure and Regulation System (LARS). This role is crucial in ensuring consistent, accurate, and reliable data use across various platforms. Primary Objectives:

• Develop and maintain a complete field mapping framework for the LARS legacy system.
• Conduct recurring data integrity and quality assessments.
• Support ServiceNow and help desk ticket requests for reporting and data pulls.
• Contribute to LARS modernization by validating source-to-target mapping.

Key Responsibilities:

• Field Identification, Mapping & Documentation:

• Identify, validate, and document all existing fields in the LARS legacy system.
• Analyze field relationships and dependencies.
• 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 and validation checks.
• Identify anomalies and data quality concerns; document findings and escalate as needed.
• Collaborate with business units to validate data usage.

• Ticket & Reporting Support:

• Respond to help desk and ServiceNow ticket requests within established timelines.
• Write and execute SQL queries to deliver accurate reporting outputs.
• 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.

• 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 both technical and non-technical stakeholders.

Must Have Experience:

• Data Analysis: 7-9 years
• Data Modeling: 7-9 years
• Microsoft SQL Server: 10 years
• SQL: 10 years
• Excel: 7-9 years
• Data Analytics Specialist: 7-9 years
• SQL Server Reporting Services (SSRS): 10 years