Data Analyst - SQL, Excel
About The Position
The Data Analyst will support data quality, documentation, and system modernization initiatives for a legacy Licensure and Regulation System (LARS). The role focuses on identifying and documenting data fields, assessing data integrity, responding to reporting and data-extraction requests, and contributing to data migration and modernization activities. The analyst will collaborate with technical teams and business stakeholders to help ensure data is accurate, consistent, and reliable. The position is an 8-month W2 contract based onsite in Nashville, Tennessee. Local candidates are requested.
Requirements
- Advanced SQL skills, including querying, data profiling, and data integrity validation.
- Strong Microsoft Excel skills, including lookups, pivot tables, and data modeling.
- Experience in data mapping, data analysis, and technical documentation.
- Strong analytical, critical-thinking, and problem-solving skills.
- Ability to manage timelines, deliverables, and multiple workstreams effectively.
- Excellent written and verbal communication skills.
- Ability to collaborate with technical and non-technical stakeholders.
Responsibilities
- Identify, validate, and document fields in the legacy system.
- Analyze field relationships, dependencies, and usage across data extracts, correspondence, certificates, and API feeds.
- Update data mapping documentation and maintain a centralized data dictionary.
- Perform SQL-based data profiling, validation checks, and trend analysis.
- Identify and document data anomalies and quality issues, escalate concerns, track recurring issues and systemic risks, and recommend improvements and data governance standards.
- Collaborate with business teams to validate data usage and improve data entry practices.
- Respond to help desk and ServiceNow tickets within established timelines.
- Develop and execute SQL queries to generate reports and data extracts, validate requested data, document results, and maintain reports and SQL scripts in the designated repository.
- Participate in vendor meetings and communicate legacy-system data requirements.
- Review vendor mapping documents and validate source-to-target field mappings.
- Support data migration through profiling, validation, issue resolution, and testing.
- Contribute to future system architecture, dashboards, reporting solutions, and long-term data governance initiatives.
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
