Data Integration Analyst

Credence•Tysons, VA
•$110,000 - $175,000

About The Position

The Data Integration Analyst will perform hands-on data profiling, source-to-target mapping, transformation rule definition, and reconciliation testing for an enterprise platform modernization effort. The analyst will work with business owners, senior engineers, architects, reporting developers, and external partners to migrate approved legacy data into ServiceNow using Import Sets and Transform Maps, while aligning legacy and modernized operational records into consistent, traceable reporting datasets. The role includes profiling legacy datasets; defining and documenting mappings, transformation rules, and business definitions; configuring and validating ServiceNow data imports; aligning data for unified reporting; preserving identifiers and lineage across system cutover; and reconciling migration and reporting results. The analyst will also support partner interface testing, Agile delivery, cutover rehearsals, and operational handover. Expected deliverables include approved source-to-target mappings and business definitions, configured ServiceNow Transform Maps and scripts, key crosswalks and data lineage documentation, reconciliation and test results, and cutover support procedures. Success means legacy data is accurately migrated and combined reporting is complete and consistent across both systems without double counting. Business owners should be able to trace reported metrics to source records, with exceptions resolved against agreed acceptance criteria.

Requirements

  • 3–5 years of experience in data analysis, data migration, system integration, or reporting across legacy and modernized enterprise platforms.
  • Hands-on ServiceNow experience with Import Sets, Transform Maps, field mapping, coalesce configuration, reference handling, and JavaScript transformation scripts.
  • Strong SQL and data profiling skills, including the ability to author source-to-target mappings, standardize data, and reconcile complex datasets.
  • Ability to map and validate parent-child data relationships, partial records, adjustments, and aggregation rules that prevent double counting.
  • Experience executing trial migrations, delta loads, cutover validation, and structured reconciliation testing.
  • Familiarity with API or file-based integrations, including XML, and supporting end-to-end testing with external partners.
  • Strong documentation and communication skills, including the ability to work effectively in Agile teams and explain mapping logic and reconciliation findings to technical and business stakeholders.

Nice To Haves

  • Experience supporting large-scale federal or enterprise operational modernization programs.
  • Familiarity with business intelligence tools, dimensional modeling concepts, and historical reporting across legacy system retirements.
  • Knowledge of ServiceNow integration capabilities, secure data handling, access controls, and load performance tuning.
  • Bachelor’s degree in computer science, information systems, data analytics, or a related discipline, or equivalent relevant experience.

Responsibilities

  • Profile legacy datasets and create detailed source-to-target mappings for keys, parent-child relationships, data types, code translations, and business rules.
  • Review mapping logic with senior team members and business owners, maintaining traceability to requirements.
  • Configure ServiceNow Import Sets and Transform Maps, including data cleansing, validation, load sequencing, and exception-handling routines.
  • Work with data engineering and reporting teams to merge legacy and modernized operational records within the approved reporting architecture.
  • Apply data modeling standards to map consistent identifiers and shared entity, location, and date definitions.
  • Preserve source-system identifiers, key crosswalks, and data lineage across system cutover.
  • Account for partial records, adjustments, cancellations, status differences, and financial calculations to prevent duplicate counting across systems.
  • Execute trial migrations and automated reconciliation of record counts, relationships, quantities, and financial totals.
  • Compare report outputs against source records and approved business rules; document discrepancies and acceptance evidence.
  • Coordinate external partner test data and scenarios for API and XML file exchanges, validate end-to-end outcomes, and resolve data defects.
  • Participate in Agile ceremonies, maintain version-controlled mappings and test artifacts, and support cutover rehearsals and operational handover.

Benefits

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k, IRA)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off (Vacation, Sick & Public Holidays)
  • Family Leave (Maternity, Paternity)
  • Short Term & Long Term Disability
  • Training & Development
  • Wellness Resources
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service