Data Integration Analyst

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

About The Position

The Data Integration Analyst performs hands-on data profiling, source-to-target mapping, transformation rule definition, and reconciliation testing for an enterprise platform modernization effort. Working with business owners, senior engineers, architects, reporting developers, and external partners, the analyst migrates approved legacy data into ServiceNow using Import Sets and Transform Maps and aligns legacy and modernized operational records into consistent, traceable reporting datasets. The role delivers approved mappings and business definitions, configured ServiceNow Transform Maps and scripts, crosswalks and data lineage documentation, reconciliation and test results, and cutover support procedures. Success means accurately migrated data and complete, consistent combined reporting without double counting, with reported metrics traceable to source records and 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, with 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 mappings with senior team members and business owners and maintain requirements traceability.
  • Configure ServiceNow Import Sets and Transform Maps, including data cleansing, validation, load sequencing, and exception-handling routines.
  • Partner with data engineering and reporting teams to combine legacy and modernized operational records within the approved reporting architecture, following data modeling standards and shared entity, location, and date definitions.
  • Maintain reporting continuity and accuracy by retaining 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.
  • Execute trial migrations and automated reconciliation of record counts, relationships, quantities, and financial totals; compare report outputs with source records and approved business rules, documenting 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