ZipStaff Inc.

Senior Data Analyst

McLean, Virginia•Contract
$38 - $40 hourly
About the Job
Title: Senior Data Analyst.
Location: McLean, VA (On-site).
Type: Contract, 11 months.

Overview:
ZipStaff is hiring a Senior Data Analyst for our client, a large financial services and mortgage finance organization. This role focuses on data discovery, modernization, and migration, with strong hands-on data profiling, data analysis, and enterprise application modernization. You'll help transform legacy (brownfield) applications into modern, scalable (goldfield) solutions while ensuring data integrity and seamless migration, analyzing complex legacy data ecosystems, uncovering hidden business rules and dependencies, and translating requirements into data transformation strategies. You'll collaborate with business stakeholders, solution architects, data engineers, application development, and QA teams. This is an 11-month on-site contract in McLean, VA.

Responsibilities:
  • Perform comprehensive data profiling across legacy applications, databases, and enterprise data platforms, covering quality, completeness, consistency, and integrity.
  • Use advanced SQL analysis to find anomalies, duplicates, missing values, and referential integrity issues.
  • Discover undocumented business rules, data relationships, and transformation logic.
  • Perform source-to-target analysis between legacy and modernized systems, and produce data profiling reports and quality scorecards.
  • Evaluate legacy data models, define future-state data models with architects, eliminate redundant data and obsolete rules, and assess upstream and downstream impact.
  • Lead data analysis across the migration lifecycle (discovery, mapping, transformation, validation, and reconciliation) and produce source-to-target mapping specifications.
  • Partner with data engineering to define and validate ETL/ELT logic, reconcile legacy and target data, write SQL validation scripts, and support mock runs, cutover, post-migration validation, and root-cause analysis.
  • Facilitate data discovery workshops; maintain data dictionaries and lineage documentation; support UAT with data validation scenarios; and communicate findings to technical and executive stakeholders.

Required Qualifications:
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field.
  • 7+ years of hands-on data analysis, with significant enterprise application modernization or data migration experience.
  • Advanced SQL, including complex joins, aggregations, and performance.
  • 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 with source-to-target mappings, transformation rules, and validation strategies.
  • Excellent critical thinking, communication, and coordination with business and technical teams, and the ability to work independently in ambiguity.

Preferred Qualifications:
  • Background as a systems analyst.
  • MongoDB and NoSQL experience.

Benefits:
  • Health Insurance.
  • Dental Insurance.
  • Vision Insurance.
  • 401(k) + matching.
  • Paid time off.
  • Referral Program.

About ZipStaff:
ZipStaff connects skilled technology professionals with leading organizations across the United States, matching top talent with impactful contract and full-time opportunities.

To apply, submit your resume through this posting. Qualified candidates will be contacted by a ZipStaff recruiter.