Data Mapping & Integrity Analyst

• Catalog, validate, and document all existing fields and schemas across the legacy environment.
• Analyze dependencies, field relationships, and downstream data consumption across API feeds, extracts, operational reports, and system-generated correspondence.
• Establish and maintain a comprehensive, centralized data dictionary for cross-functional organizational reference.
• Identify mapping discrepancies or gaps and maintain up-to-date source-to-target documentation.

Data Integrity & Quality Profiling

• Execute routine SQL-driven profiling scripts, validation checks, and data anomaly investigations.
• Detect structural issues, systemic data risks, and trends, escalating critical integrity concerns appropriately.
• Collaborate with business and technical teams to establish improved data governance standards and validation practices.

Ticket Support & Ad-Hoc Data Analysis

• Fulfill inbound reporting, data extraction, and administrative support requests submitted via ServiceNow/ticketing platforms within established response targets.
• Write clean, optimized SQL scripts to deliver accurate datasets, storing validated scripts and report templates in designated source repositories.

Modernization & Migration Support

• Serve as a legacy data subject matter expert in cross-functional migration planning and technical vendor discussions.
• Audit vendor data mapping artifacts to verify the accuracy of source-to-target schema transformations.
• Support migration dry runs and testing cycles through pre- and post-load validation, integrity testing, and defect resolution.

We are seeking an analytical and detail-oriented Data Mapping & Integrity Analyst to lead critical data quality, technical documentation, and legacy system modernization initiatives. In this role, you will be responsible for mapping and evaluating data fields across a complex legacy regulatory platform, conducting rigorous data profiling, and ensuring reliable data flow across downstream reporting, APIs, correspondence, and system migration phases.

The ideal candidate brings extensive background in SQL querying, relational database structures, and advanced Excel analysis, coupled with the communication skills needed to align technical documentation with business requirements., * Extensive hands-on experience writing complex SQL queries for data extraction, profiling, reconciliation, and validation.

• Advanced Microsoft SQL Server and relational database querying proficiency.
• Advanced Excel capabilities (advanced formulas, data models, PivotTables, and cross-source reconciliations).
• Demonstrated track record developing end-to-end data dictionaries, data catalogs, and source-to-target mapping specifications.
• Prior exposure to legacy system migration or modernization testing cycles.
• Experience with ServiceNow or enterprise ticketing and reporting workflows is a plus.

Professional Strengths:

• Strong analytical problem-solving skills with a focus on data governance and risk mitigation.
• Excellent written and verbal communication skills, with proven ability to translate complex data structures for non-technical stakeholders.
• Strong time management and delivery accountability across multiple concurrent workstreams., * Data Analysis (Required 7 Years)
• Data Modeling (Required 7 Years)
• Microsoft SQL Server (Required 10 Years)
• SQL (Required 10 Years)
• Excel (Required 7 Years)
• Data Analytics Specialist (Required 7 Years)
• SQL Server Reporting Services (SSRS) (Required 10 Years)

• Residency Requirement: Candidates must currently reside in the state of Tennessee (proof of residency required prior to engagement).
• Screening: Selected candidates must successfully pass a comprehensive 7-year multi-jurisdictional criminal background investigation and statewide registry screening prior to start.
• Position Type: Contract
• Location: Nashville, TN (On-site with potential hybrid flexibility following initial training; candidates must currently reside in Tennessee)
• Schedule: Monday - Friday, 8:00 AM - 4:30 PM CST (37.5 hours/week)