Data Mapping & Integrity Analyst

One of our client in the government domain is seeking a highly analytical Data Mapping & Integrity Analyst to support ongoing data quality, documentation, and modernization initiatives for the Licensure and Regulation System (LARS). This role will be responsible for leading data mapping efforts, conducting data integrity assessments, supporting reporting requirements, and assisting with modernization and data migration activities.

Data Mapping & Integrity Analyst

Location: Nashville, TN 37243 (Onsite with potential hybrid flexibility after training)
Duration: Long-Term Contract
Work Schedule: Monday-Friday, 8:00 AM - 4:30 PM CST

Note: This position requires onsite attendance during the initial training period. Hybrid work arrangements may be available based on performance and business needs.

The ideal candidate will possess strong SQL expertise, advanced Excel skills, experience with data profiling and validation, and the ability to communicate effectively with both technical and business stakeholders.Key Responsibilities****Data Mapping & DocumentationIdentify, validate, and document all existing data fields within the LARS legacy system. Analyze data relationships, dependencies, and field usage across reports, certificates, correspondence, extracts, and API feeds. Develop and maintain comprehensive data mapping documentation and data dictionaries. Update mapping documents and identify inconsistencies, gaps, and data definition issues. Data Quality & Integrity AnalysisPerform SQL-based data profiling, validation, and integrity reviews. Analyze datasets to identify anomalies, inconsistencies, and data quality concerns. Document findings and recommend improvements to data quality and governance practices. Collaborate with business users to validate data usage and improve data accuracy. Reporting & Ticket SupportRespond to ServiceNow and help desk requests related to reporting and data extraction. Develop and execute SQL queries to support reporting needs. Validate and document all report outputs before delivery. Maintain report documentation and SQL scripts within designated repositories. Modernization & Data Migration SupportSupport LARS modernization initiatives and data migration activities. Participate in vendor meetings and provide subject matter expertise regarding legacy system data. Review and validate source-to-target mapping documentation. Assist with migration testing, data validation, issue resolution, and user acceptance activities. Contribute to future-state reporting, dashboards, and data governance initiatives. Required QualificationsStrong experience with SQL querying, data profiling, and data validation. Advanced Microsoft Excel skills including Pivot Tables, VLOOKUP/XLOOKUP, and data analysis techniques. Experience with data mapping, data documentation, and data dictionaries. Strong analytical and problem-solving abilities. Experience supporting reporting and data extraction requests. Ability to manage multiple priorities and meet project deadlines. Excellent written and verbal communication skills. Experience working with both technical and non-technical stakeholders. Preferred QualificationsExperience supporting data migration and modernization projects. Knowledge of data governance and master data management principles. Experience reviewing source-to-target mapping documentation. Familiarity with ServiceNow ticketing processes. Experience working within government, healthcare, or regulatory environments. Required SkillsSQL Data Mapping Data Integrity Analysis Data Quality Management Data Profiling Microsoft Excel (Advanced) Reporting & Analytics Documentation & Data Dictionary Management Data Validation ServiceNow