Data Mapping & Integrity Analyst

eBusiness Solutions Inc.; Nashville (TN); Hybrid; USD 70,000 - 100,000; Full time

Job summary

eBusiness Solutions Inc. is seeking a Data Mapping & Integrity Analyst for the LARS project in Nashville, TN. The role focuses on data mapping, quality assessments, and supporting modernization and data migration efforts.

The candidate will lead data profiling, validation, and reporting tasks, collaborating with technical and business stakeholders to ensure data accuracy and governance. Onsite with potential hybrid flexibility after training.

Qualifications

• Strong SQL querying, data profiling, and validation.
• Advanced Excel skills including Pivot Tables, VLOOKUP/XLOOKUP.
• Experience with data mapping, documentation, and data dictionaries.
• Excellent analytical and communication abilities.
• Experience supporting reporting and data extraction.

Responsibilities

• Data Mapping & Documentation: identify, validate, and document all existing LARS data fields.
• Data Quality & Integrity Analysis: perform SQL-based profiling, validation, and integrity reviews.
• Reporting & Ticket Support: respond to ServiceNow requests and develop SQL queries for reporting.
• Modernization & Data Migration Support: assist with migration testing, data validation, and future-state reporting.

Skills

SQL

Data Mapping

Data Integrity Analysis

Data Quality Management

Data Profiling

Microsoft Excel (Advanced)

Reporting & Analytics

Documentation & Data Dictionary Mgmt

Job description

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 & Documentation

• Identify, 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 Analysis

• Perform 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 Support

• Respond 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 Support

• Support 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 Qualifications

• Strong 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 Qualifications

• Experience 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 Skills

• SQL
• Data Mapping
• Data Integrity Analysis
• Data Quality Management
• Data Profiling
• Microsoft Excel (Advanced)
• Reporting & Analytics
• Documentation & Data Dictionary Management