TT
Data Administrator/Database Administrator
Talent Technical Services, Inc
- 🇺🇸 United States
- On-site
- Staff / Principal
- 18 hours ago
- $30 – $32 / hour
- SQL
- Excel
- ServiceNow
- Pivot Tables
- Data Modeling
- Microsoft SQL Server
- SSRS
18 hours ago
Job Duration: 8 Months
Job Location: Nashville, Tennessee, 37243 (Onsite)
Schedule: Monday–Friday, 8:00 AM–4:30 PM CST
Job Summary:
- 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 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.
- 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.
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.
- Perform recurring SQL-driven data profiling, validation checks, and trend analyses.
- Identify anomalies and data quality concerns; document findings and escalate 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.
- 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.
- 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.
- 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
- Data Analysis Advanced (7-9 Years)
- Data Modeling Advanced (7-9 Years)
- Microsoft SQL Server Expert (10+ Years)
- SQL Expert (10+ Years)
- Excel Advanced (7-9 Years)
- Data Analytics Specialist Advanced (7-9 Years)
- SQL Server Reporting Services (SSRS) Expert (10+ Years)
Data Administrator/Database Administrator · Talent Technical Services, Inc