Senior Data Analyst

Codetech•McLean, VA

About The Position

We are seeking a highly skilled, analytical Senior Data Analyst to support enterprise application modernization and data migration. The role focuses on transforming legacy applications into modern, scalable solutions while maintaining data integrity, consistency, and reliable migration. The analyst will examine complex legacy data ecosystems, uncover undocumented business rules and dependencies, and translate business requirements into data transformation strategies. The position involves data discovery and profiling, assessment of legacy and future-state data models, source-to-target mapping, migration and transformation analysis, validation, and reconciliation. The analyst will work with business stakeholders, solution architects, data engineers, application development teams, and quality assurance teams to inform modernization decisions and support successful migration and UAT.

Requirements

  • Bachelor's degree in computer science, Information Systems, Data Analytics, Engineering, or a related field.
  • At least 7 years of experience in data analysis, with significant hands-on involvement in enterprise application modernization or data migration initiatives.
  • Advanced SQL proficiency, including complex joins, aggregations, and performance optimization.
  • Hands-on experience with data profiling, data quality analysis, data reconciliation, and root cause analysis.
  • Experience analyzing legacy applications and supporting brownfield-to-modernized application transformations.
  • Strong understanding of relational databases, data modeling, data integration, and enterprise data architectures.
  • Ability to define source-to-target mappings, transformation rules, and data validation strategies.
  • Experience working with large, complex datasets across multiple applications and data sources.
  • Strong critical thinking, analytical reasoning, and problem-solving skills.
  • Ability to work independently in ambiguous environments and drive clarity through data-driven analysis.
  • Strong communication skills and ability to influence technical and business stakeholders.
  • Excellent communication and coordination abilities, including effective collaboration with business and technical teams.

Nice To Haves

  • Background as a systems analyst.
  • Experience with MongoDB and NoSQL.

Responsibilities

  • Profile data across legacy applications, databases, and enterprise data platforms, assessing quality, completeness, consistency, uniqueness, and integrity.
  • Use advanced SQL to identify anomalies, duplicate records, missing values, inconsistent patterns, and referential integrity issues.
  • Discover undocumented business rules, data relationships, transformation logic, and dependencies in legacy applications.
  • Conduct source-to-target analysis to identify structural, semantic, and functional differences between legacy and modernized systems.
  • Develop data profiling reports, data quality scorecards, and recommendations for modernization initiatives.
  • Assess legacy applications and data models, identifying opportunities for simplification, standardization, consolidation, and optimization.
  • Collaborate with architects and engineering teams to define future-state data models aligned with modern application architecture and business capabilities.
  • Assess the impact of modernization decisions on upstream and downstream systems, integrations, reporting, and business processes.
  • Support data-driven decisions about data retention, archival, transformation, and migration.
  • Lead data analysis throughout the migration lifecycle, including discovery, assessment, mapping, transformation, validation, and reconciliation.
  • Develop and maintain source-to-target mapping specifications, transformation rules, and migration requirements.
  • Identify and resolve data quality issues and migration risks before production cutover.
  • Partner with data engineering teams to define and validate ETL/ELT logic and migration pipelines.
  • Perform reconciliation between legacy and target systems and develop SQL queries and automated scripts to validate migrated data.
  • Support migration mock runs, dress rehearsals, cutover planning, and post-migration validation.
  • Investigate migration discrepancies, conduct root cause analysis, and recommend corrective actions.
  • Evaluate complex data problems, challenge assumptions, assess alternative transformation approaches, and identify downstream impacts.
  • Facilitate data-driven discussions to resolve conflicting business rules and data definitions.
  • Partner with stakeholders and technical teams to clarify current capabilities and future-state requirements.
  • Conduct data discovery workshops and working sessions on business rules, data ownership, and transformation expectations.
  • Translate business requirements into technical data specifications and acceptance criteria.
  • Maintain data dictionaries, lineage documentation, mapping specifications, and data quality assessments.
  • Communicate findings, risks, and recommendations to technical teams and executive stakeholders.
  • Support UAT by defining data validation scenarios and ensuring modernized applications meet business expectations.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service