Data Mapping & Integrity Analyst

Note: This position requires onsite attendance during the initial training period. Hybrid work arrangements may be available based on performance and business needs., 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

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., 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 Data Validation ServiceNow