Data Analyst

Info Origin Inc.; Nashville (TN); On-site; USD 65,000 - 95,000; Full time

Job summary

First Roles is seeking a Data Mapping & Integrity Analyst in Nashville to drive data quality, field mapping, reporting, and modernization of legacy systems. The role emphasizes SQL proficiency, advanced Excel, and strong data governance.

You will partner with vendors and stakeholders to ensure accurate data migration and reliable reporting. The position focuses on documenting data fields, building data dictionaries, and validating mappings across reports and APIs while handling data requests via

Qualifications

• Advanced SQL for data profiling, validation, and reporting.
• Advanced Excel skills including VLOOKUP/XLOOKUP, pivot tables, and data modeling.

Responsibilities

• Identify, validate, and document data fields in the legacy LARS system.
• Develop and maintain data mapping documents and data dictionaries.
• Analyze field relationships, dependencies, and usage across reports, APIs, and extracts.
• Perform SQL-based data profiling, validation, and integrity checks.
• Identify data discrepancies, quality issues, and systemic risks.
• Handle ServiceNow/help desk tickets for reporting and data requests.
• Write SQL queries to generate accurate reports and data extracts.
• Validate source-to-target mappings for system modernization.
• Support data migration, testing, and issue resolution.
• Collaborate with vendors and business stakeholders on data governance and modernization.

Skills

SQL

Excel

Data mapping

Data quality

Data migration

Documentation

Analytical skills

Tools

ServiceNow

Job description

Job Summary The client is seeking a Data Mapping & Integrity Analyst to support data quality, field mapping, reporting, and modernization of the legacy Licensure and Regulation System (LARS). The role requires strong SQL, advanced Excel, data mapping, and data validation experience.

Key Responsibilities

• Identify, validate, and document data fields in the legacy LARS system.
• Develop and maintain data mapping documents and data dictionaries.
• Analyze field relationships, dependencies, and usage across reports, APIs, and extracts.
• Perform SQL-based data profiling, validation, and integrity checks.
• Identify data discrepancies, quality issues, and systemic risks.
• Handle ServiceNow/help desk tickets for reporting and data requests.
• Write SQL queries to generate accurate reports and data extracts.
• Validate source-to-target mappings for system modernization.
• Support data migration, testing, and issue resolution.
• Collaborate with vendors and business stakeholders on data governance and modernization.

Required Skills

• Advanced SQL: Queries, data profiling, validation, and reporting.
• Advanced Excel: VLOOKUP/XLOOKUP, pivot tables, and data modeling.
• Data Mapping: Field mapping, source-to-target mapping, and data dictionaries.
• Data Quality & Integrity: Data validation, discrepancy analysis, and issue resolution.
• Data Migration: Migration testing and data reconciliation.
• Documentation: Technical documentation and mapping specifications.
• Strong analytical, problem-solving, and communication skills.

Preferred/Relevant Experience

• Legacy system modernization projects.
• ServiceNow ticketing and reporting support.
• Data governance and data quality frameworks.
• API data feeds and reporting systems.
• Vendor coordination and stakeholder management.