Hiring.Camp

Data Integration Analyst

Credence

·

Yesterday

Salary
$110k – $175k/yr
Location
Tysons, Virginia
Workplace
Hybrid
Type
Full-time
Department
Agency
Seniority
Mid
Experience
3+ years
Source
Workable

Description

Join a team where innovation meets mission, our AI, cloud, cyber, and modernization solutions save agencies thousands of hours, safeguard national security, and strengthen health and humanitarian missions worldwide. With more than 1,700+ team members, 1,500+ AI & data experts, and 100+ prime contracts, we deliver at scale and with purpose.

 

We’ve been recognized as a Top Workplace by The Washington Post for six consecutive years and named to the Inc. 5000 list of Fastest-Growing Private Companies in 13 of the past 14 years. Credence is a welcoming environment for those looking to grow and make a meaningful impact. We encourage employees to push boundaries and help solve critical, world-changing federal challenges.

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. Working alongside business owners, senior engineers, architects, reporting developers, and external partners, the analyst will migrate approved legacy data into ServiceNow using Import Sets and Transform Maps while aligning legacy and modernized operational records into consistent, traceable reporting datasets.

Primary Responsibilities

  • Analyze and map source data. Profile legacy datasets and create detailed source-to-target mappings covering keys, parent-child relationships, data types, code translations, and business rules. Review mapping logic with senior team members and business owners while maintaining traceability to requirements.
  • Migrate legacy data into ServiceNow. Configure ServiceNow Import Sets and Transform Maps, implementing data cleansing, validation, load sequencing, and exception-handling routines.
  • Align legacy and modern datasets for unified reporting. Partner with the data engineering and reporting teams to merge legacy and modernized operational records within the approved reporting architecture. Follow established data modeling standards to map consistent identifiers and apply shared entity, location, and date definitions.
  • Maintain reporting continuity and accuracy. Retain 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.
  • Validate migrations and reporting results. Execute trial migrations and automated reconciliation of record counts, relationships, quantities, and financial totals. Compare report outputs against source records and approved business rules, documenting discrepancies and acceptance evidence.
  • Support partner interfaces and Agile delivery. 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.

Expected Deliverables & Success Measures

  • Deliverables: 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 Measures: Legacy data is accurately migrated into ServiceNow, and combined reporting delivers complete, consistent operational results across both systems without double counting. Business owners can trace reported metrics back to source records, with all exceptions resolved against agreed acceptance criteria.

Skills

JavaScriptSQLData EngineeringServiceNowAgile

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 DisabilityTraining & DevelopmentWellness Resources

Similar Jobs

30

Data Integration Analyst

InfoImage·Brisbane, Queensland +1

2w ago

Data Integration Analyst

Boeing·New York City, New York +1·Hybrid

4mo ago

Data Integration Analyst

ProSidian Consulting·Alexandria, Virginia·Hybrid

7mo ago

Data Integration Analyst

ProSidian Consulting·Alexandria, Virginia·Hybrid

7mo ago

Data Integration Analyst II; Aplenc Lab

Chop·US

1d ago

Business Systems Analyst (Data & Integration) - 3714999

Lighthouse Technology Services·Hybrid

Senior Data Integration Analyst

Sanofi·Hyderabad, Telangana

1w ago

Senior Analyst - Data Integration

JLL employee·India·Onsite

1mo ago

Oracle SaaS Reference Data Integration Analyst - AVP

Citi Bank·US·Hybrid

1mo ago

Technology - Data Integration Analyst

Venues NSW·Australia

1mo ago

Data Analyst /Data Integration/Quality & Governance

Softek International Inc·Remote

Senior Healthcare Data Integration Analyst

Truveta·Hyderabad, Telangana·Onsite

1mo ago

SENIOR DATA INTEGRATION ANALYST (DATABRICKS/PYTHON) (36005)

Robert Bosch·Curitiba, Paraná

1mo ago

Data Integration Analyst, AI & Risk Adjustment

Reveleer·Remote

Oracle SaaS Reference Data Integration Analyst - AVP

Citi Bank·Tampa, Florida

2mo ago

Accounting Systems & Data Integration Analyst

Careers Home·Centennial, Colorado +4·Remote

3mo ago

Clinical Systems Analyst - Data Integration & Software Development

Stanfordmedicine·1830 Embarcadero - PALO ALTO, US·Hybrid

4mo ago

Sr Analyst, Data Integration & Workflows

Spgi·The Netherlands·Remote

6mo ago

Sr Analyst, Data Integration & Workflows

Spgi·The Netherlands·Remote

6mo ago

Functional Analyst and Data Integration

Advanced Technology Leaders·Fort Lee, Virginia

2w ago

Sr. Feeds Analyst, Measurement - Data Integration

Ovative·Chicago, Illinois +2·Hybrid

4w ago

Senior IT Analyst for Data Integration & Enablement Stream

B2Bnetwork

Client Data Integration (CDI) Analyst, Officer

Statestreet·Quincy, Massachusetts

5mo ago

IT Data Integration & DevOps Analyst

Council for Professional Recognition·New York City, New York·Remote

10mo ago

Lead Technology Analyst – SAP BASIS & Data Integration

Airbus·Bengaluru, Karnataka·Hybrid

1w ago

Sr Business Analyst | Trading Operations & Data Integration

Engineers and Constructors International Inc.·Houston, Texas

3w ago

Data Integration & Decision Support Analyst (N2701)

SimIS Inc.·Norfolk, Virginia·Onsite

2mo ago

Data Product and Integration Analyst

Gnw·Richmond, Virginia·Remote, Hybrid, Onsite

3mo ago

Junior - AI Integration & Data Validation QA Analyst

Chistats·Pune, Maharashtra

3mo ago

AI Integration & Data Validation QA Analyst

Chistats·Pune, Maharashtra

3mo ago