Senior Data Analyst

ZipStaff•McLean, VA
•Onsite

About The Position

ZipStaff is hiring a Senior Data Analyst for a client in financial services and mortgage finance. The role focuses on data discovery, modernization, and migration, including hands-on data profiling and analysis to help transform legacy applications into modern, scalable solutions while maintaining data integrity and enabling seamless migration. The analyst will examine complex legacy data ecosystems, uncover undocumented business rules and dependencies, and translate requirements into data transformation strategies. The role collaborates with business stakeholders, solution architects, data engineers, application development teams, and QA teams. This is an 11-month on-site contract based in McLean, Virginia.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field.
  • At least 7 years of hands-on data analysis experience, including significant enterprise application modernization or data migration experience.
  • Advanced SQL skills, including complex joins, aggregations, and performance considerations.
  • Experience with data profiling, data quality analysis, reconciliation, and root-cause analysis.
  • Experience with relational databases, data modeling, data integration, enterprise data architecture, data mapping, and ETL processes.
  • Experience creating source-to-target mappings, transformation rules, and validation strategies.
  • Strong critical thinking, communication, and coordination skills for working with business and technical teams.
  • Ability to work independently in ambiguous situations.

Nice To Haves

  • Background as a systems analyst.
  • MongoDB and NoSQL experience.

Responsibilities

  • Perform data profiling across legacy applications, databases, and enterprise data platforms, assessing quality, completeness, consistency, and integrity.
  • Use advanced SQL to identify anomalies, duplicate records, missing values, and referential integrity issues.
  • Discover undocumented business rules, data relationships, and transformation logic.
  • Conduct source-to-target analysis between legacy and modernized systems, and create data profiling reports and quality scorecards.
  • Evaluate legacy data models and define future-state data models with architects; identify redundant data and obsolete rules, and assess upstream and downstream impacts.
  • Lead data analysis throughout the migration lifecycle, including discovery, mapping, transformation, validation, and reconciliation.
  • Produce source-to-target mapping specifications.
  • Partner with data engineering to define and validate ETL/ELT logic, reconcile legacy and target data, and write SQL validation scripts.
  • Support mock runs, cutover, post-migration validation, and root-cause analysis.
  • Facilitate data discovery workshops and maintain data dictionaries and lineage documentation.
  • Support UAT by developing data validation scenarios.
  • Communicate findings to technical and executive stakeholders.

Benefits

  • Health insurance
  • Dental insurance
  • Vision insurance
  • 401(k)
  • 401(k) matching
  • Paid time off
  • Referral program
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service