Data Analyst

Title: Data Mapping & Integrity AnalystLocation: Nashville, TN (In-person, with potential for hybrid after training)Duration: 8+ Months with Possible ExtensionJob OverviewWe are seeking a highly analytical Data Mapping & Integrity Analyst to join our team in supporting critical data quality, documentation, and legacy system modernization efforts for a healthcare regulatory platform.In this role, you will lead the identification, documentation, and assessment of data fields across legacy databases while supporting ongoing data integrity reviews, reporting needs, and system migration activities. The ideal candidate brings strong SQL skills, advanced Excel proficiency, and proven experience analyzing complex datasets.Key Responsibilities1. Field Identification, Data Mapping & DocumentationIdentify, validate, and document existing data fields within legacy database systems.Analyze field relationships, dependencies, and usage across data extracts, automated correspondence, certificates, and API feeds.Maintain and update data mapping documentation and centralized data dictionaries to establish agency-wide reference standards.2. Data Integrity & Quality ReviewPerform recurring SQL-driven data profiling, validation checks, and trend analyses.Identify data anomalies and structural quality concerns; document findings and escalate risks as necessary.Track systemic data issues and recommend ongoing data governance and quality improvements.Collaborate with functional teams to validate data usage and establish best practices for data entry.3. Reporting & Ticket SupportRespond to help desk and ticketing system requests (e.g., ServiceNow) within established timelines.Write and execute optimized SQL queries to deliver accurate custom reporting outputs.Store and organize completed reporting queries and scripts in designated repositories.4. System Modernization & Migration SupportRepresent legacy data requirements during modernization meetings with external vendors and technical leads.Review vendor mapping documents and validate source-to-target field accuracy.Assist with data migration testing cycles through profiling, verification, issue resolution, and user acceptance testing support.Required Qualifications & SkillsAdvanced SQL proficiency (writing custom queries, data profiling, database validation, and integrity checks).Advanced MS Excel skills (VLOOKUP/XLOOKUP, pivot tables, data modeling, and functions).Direct experience with Data Mapping, source-to-target mapping, and building data dictionaries.Demonstrated experience handling data requests via ticketing systems (e.g., ServiceNow).Strong analytical, problem-solving, and timeline management capabilities across multiple workstreams.Excellent verbal and written communication skills to bridge technical and non-technical stakeholder discussions.