Jobs › Companies › Credence › Data Integration Analyst

About this Data Integration Analyst role at Credence

Credence · Onsite · Tysons, Virginia, United States

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.

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, with proven 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.

Preferred Qualifications

  • 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.

Salary Range: $110,000.00 to $175,000.00 annually. Actual compensation will be determined based on the selected candidate's experience, education, skills, and overall qualifications.

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
Ready to apply to Credence?
Apply to Credence

About Credence

At Credence, we support our clients’ mission-critical needs, powered by technology. We provide cutting-edge solutions, including AI/ML, enterprise modernization, and advanced intelligence capabilities, to the largest defense and health federal organizations. Through partnership and trust, we increase mission success for war-fighters and secure our nation for a better future.

We are privately held, are repeatedly recognized as a top place to work, and have been on the Inc. 5000 Fastest Growing Private Companies list for the last 12 years. We practice servant leadership and believe that by focusing on the success of our clients, team members, and partners, we all achieve greater success.

See all jobs at Credence →

Similar jobs

Credence
Program Manager - Program Integration WAX 01.4.04
Credence
⚡ Apply early Wright-Patterson Air Force Bas... Onsite
● New 👁 Seen ✓ Applied 15m ago
Credence
ACWS Senior Appian Architect
Credence
⚡ Apply early Arlington, Virginia, United St... Onsite $200,000–$225,000
● New 👁 Seen ✓ Applied 15m ago
Credence
Test and Evaluation Engineer II - Data Analyst
Credence
⚡ Apply early Aberdeen Proving Ground, Maryl... Onsite $110,000–$150,000
● New 👁 Seen ✓ Applied 8h ago
Credence
Integration Support Manager, SME
Credence
⚡ Apply early Vandenberg Space Force Base, C... Onsite $155,000–$185,000
● New 👁 Seen ✓ Applied 8h ago
Credence
Acquisition Logistician - Depot B-52 (WBD) - 01.3.28
Credence
⚡ Apply early Tinker Air Force Base, Oklahom... Onsite
● New 👁 Seen ✓ Applied 1d ago
Credence
Senior Cloud Platform Engineer (AIOps)
Credence
⚡ Apply early McLean, Virginia, United State... Onsite $150,000–$190,000
● New 👁 Seen ✓ Applied 1d ago
Credence
Cyber Intelligence Analyst CROWS 7.17
Credence
⚡ Apply early WPAFB, Ohio, United States Onsite
● New 👁 Seen ✓ Applied 1d ago
Credence
Space Training Manager, SME - Space Delta 5 (DEL 5) S7
Credence
⚡ Apply early Vandenberg Space Force Base, C... Onsite $155,000–$180,000
● New 👁 Seen ✓ Applied 1d ago
Credence
Mid-Level Google Cloud Platform Looker Developer
Credence
⚡ Apply early Tysons, Virginia, United State... Onsite
● New 👁 Seen ✓ Applied 2d ago

Sign up for suggestions tailored to the jobs you open and the searches you save.

More jobs at Credence

See all jobs at Credence →

Apply now
🤖

Whoa — hold up

JobsRadar was built for real people having a rough time in their job search — not for automated requests. You're clicking way too fast and you're now temporarily blocked.

Come back later. If you're genuinely job hunting, we've got your back — just act like a human.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Get an edge on your job hunt.

Join our Telegram channel for the stuff that helps you land the role — salary benchmarks, the weekly market pulse, and new-feature drops. No spam, just signal.

Join the channel — it's free