← Back to jobsJob ID col-cmwpbt68r09rfd8ha7yrigwcn

MindlancePosted 1 day ago

Data Analyst SeniorNew

Full-time
On-site
7+ years
Competitive
Posted 1 day ago

Mindlance is recruiting a Senior Data Analyst for a confidential client. The role supports legacy application modernization through data profiling, migration and transformation analysis, validation, and collaboration with business and technical teams.

Posted
1 day ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Perform comprehensive data profiling across legacy applications, databases, and enterprise data platforms to assess data quality, completeness, consistency, uniqueness, and integrity
  • Analyze complex datasets using advanced SQL queries to identify anomalies, duplicate records, missing values, inconsistent data patterns, and referential integrity issues
  • Client undocumented business rules, data relationships, transformation logic, and dependencies embedded within legacy applications
  • Conduct source-to-target data analysis to identify structural, semantic, and functional differences between legacy and modernized systems
  • Develop data profiling reports, data quality scorecards, and actionable recommendations to support modernization initiatives
  • Play a key role in transitioning legacy brownfield applications into modernized goldfield architecture through comprehensive data discovery and analytical assessments from Data Platform perspective
  • Apply critical thinking to challenge existing business processes, legacy data structures, and application dependencies rather than simply replicating outdated functionality
  • Evaluate legacy data models and identify opportunities for data 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
  • Identify opportunities to eliminate redundant data, obsolete business rules, and unnecessary application dependencies
  • Assess the impact of modernization decisions on upstream and downstream systems, integrations, reporting, and critical business processes. Support data-driven decisions regarding data retention, archival, transformation, and migration
  • Lead data analysis activities throughout the end-to-end data migration lifecycle, including discovery, assessment, mapping, transformation, validation, and reconciliation
  • Develop and maintain detailed source-to-target mapping specifications, transformation rules, and data 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 transformation logic and migration pipelines
  • Perform data reconciliation between legacy and target systems to ensure accuracy, completeness, and consistency
  • Develop complex SQL queries and automated validation scripts to verify migrated datasets
  • Support migration mock runs, dress rehearsals, cutover planning, and post-migration validation
  • Investigate migration discrepancies, conduct root cause analysis, and recommend corrective actions
  • Apply strong analytical reasoning to evaluate complex data problems where requirements, documentation, or business rules may be incomplete or ambiguous
  • Go beyond documenting current-state processes to challenge assumptions and identify opportunities for modernization
  • Translate complex technical findings into clear business insights, risks, and actionable recommendations
  • Evaluate alternative data transformation approaches by considering business value, scalability, maintainability, and implementation risks
  • Proactively identify hidden dependencies and potential downstream impacts before modernization or migration decisions are finalized
  • Facilitate data-driven discussions to resolve conflicting business rules and data definitions across applications
  • Partner with business stakeholders, product owners, business analysts, architects, and engineering teams to understand existing business capabilities and future-state requirements
  • Conduct data discovery workshops and working sessions to clarify business rules, data ownership, and transformation expectations
  • Translate business requirements into technical data specifications and acceptance criteria
  • Develop and maintain data dictionaries, lineage documentation, mapping specifications, and data quality assessments
  • Communicate complex data findings to both technical teams and executive stakeholders
  • Support UAT by defining data validation scenarios and ensuring modernized applications meet business expectations

Qualifications

  • Bachelor's degree in computer science, Information Systems, Data Analytics, Engineering, or a related field
  • 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
  • Strong hands-on experience with data profiling, data quality analysis, data reconciliation, and root cause analysis
  • Demonstrated experience analyzing legacy applications and supporting brownfield-to modernized application transformations
  • Strong understanding of relational databases, data modeling, data integration, and enterprise data architectures
  • Proven 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
  • Excellent 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 with the ability to influence technical and business stakeholders

Required skills

Data IntegrationData MigrationData ModelingData ProfilingData Quality AnalysisData ReconciliationData ValidationEnterprise Application ModernizationEnterprise Data ArchitectureRelational DatabasesSQLSource-to-Target Mapping

Full job description

Mindlance is recruiting a Senior Data Analyst for a confidential client. The role supports legacy application modernization through data profiling, migration and transformation analysis, validation, and collaboration with business and technical teams.

Responsibilities

  • Perform comprehensive data profiling across legacy applications, databases, and enterprise data platforms to assess data quality, completeness, consistency, uniqueness, and integrity
  • Analyze complex datasets using advanced SQL queries to identify anomalies, duplicate records, missing values, inconsistent data patterns, and referential integrity issues
  • Client undocumented business rules, data relationships, transformation logic, and dependencies embedded within legacy applications
  • Conduct source-to-target data analysis to identify structural, semantic, and functional differences between legacy and modernized systems
  • Develop data profiling reports, data quality scorecards, and actionable recommendations to support modernization initiatives
  • Play a key role in transitioning legacy brownfield applications into modernized goldfield architecture through comprehensive data discovery and analytical assessments from Data Platform perspective
  • Apply critical thinking to challenge existing business processes, legacy data structures, and application dependencies rather than simply replicating outdated functionality
  • Evaluate legacy data models and identify opportunities for data 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
  • Identify opportunities to eliminate redundant data, obsolete business rules, and unnecessary application dependencies
  • Assess the impact of modernization decisions on upstream and downstream systems, integrations, reporting, and critical business processes. Support data-driven decisions regarding data retention, archival, transformation, and migration
  • Lead data analysis activities throughout the end-to-end data migration lifecycle, including discovery, assessment, mapping, transformation, validation, and reconciliation
  • Develop and maintain detailed source-to-target mapping specifications, transformation rules, and data 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 transformation logic and migration pipelines
  • Perform data reconciliation between legacy and target systems to ensure accuracy, completeness, and consistency
  • Develop complex SQL queries and automated validation scripts to verify migrated datasets
  • Support migration mock runs, dress rehearsals, cutover planning, and post-migration validation
  • Investigate migration discrepancies, conduct root cause analysis, and recommend corrective actions
  • Apply strong analytical reasoning to evaluate complex data problems where requirements, documentation, or business rules may be incomplete or ambiguous
  • Go beyond documenting current-state processes to challenge assumptions and identify opportunities for modernization
  • Translate complex technical findings into clear business insights, risks, and actionable recommendations
  • Evaluate alternative data transformation approaches by considering business value, scalability, maintainability, and implementation risks
  • Proactively identify hidden dependencies and potential downstream impacts before modernization or migration decisions are finalized
  • Facilitate data-driven discussions to resolve conflicting business rules and data definitions across applications
  • Partner with business stakeholders, product owners, business analysts, architects, and engineering teams to understand existing business capabilities and future-state requirements
  • Conduct data discovery workshops and working sessions to clarify business rules, data ownership, and transformation expectations
  • Translate business requirements into technical data specifications and acceptance criteria
  • Develop and maintain data dictionaries, lineage documentation, mapping specifications, and data quality assessments
  • Communicate complex data findings to both technical teams and executive stakeholders
  • Support UAT by defining data validation scenarios and ensuring modernized applications meet business expectations

Company

  • Enterprise staffing and workforce solutions
  • Union, New Jersey, USA
  • http://www.mindlance.com/
  • Founded in 1999
  • 1001-5000 employees

Qualifications

  • Bachelor's degree in computer science, Information Systems, Data Analytics, Engineering, or a related field
  • 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
  • Strong hands-on experience with data profiling, data quality analysis, data reconciliation, and root cause analysis
  • Demonstrated experience analyzing legacy applications and supporting brownfield-to modernized application transformations
  • Strong understanding of relational databases, data modeling, data integration, and enterprise data architectures
  • Proven 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
  • Excellent 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 with the ability to influence technical and business stakeholders
  • 7+ years of experience in data analysis, with significant hands-on involvement in enterprise application modernization or data migration initiatives.

Required skills

  • Data Integration, Data Migration, Data Modeling, Data Profiling, Data Quality Analysis, Data Reconciliation, Data Validation, Enterprise Application Modernization, Enterprise Data Architecture, Relational Databases, SQL, Source-to-Target Mapping

Experience

  • 7+ years

Job details

Employment type

Full-time

Seniority level

7+ years

Date posted

Nov 20, 2026

Work mode

On-site

Job source

www1.jobdiva.com

Company

Mindlance

Information Technology & AI

Enterprise staffing and workforce solutions

See all 40 jobs from Mindlance →
  • Union, New Jersey, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 1999
  • mindlance.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in McLean

Consulting

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

Zillion Technologies, Inc. is seeking a Senior Data Analyst to support enterprise application modernization by analyzing legacy data ecosystems and ensuring data integrity through migration.

Why similarSame roleData IntegrationMcLean

just now

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

Technology Ventures is seeking a Senior Data Analyst to support enterprise data platforms and application modernization initiatives. The role focuses on SQL, data profiling, data mapping, and data integration.

Why similarSame roleData IntegrationMcLean

ICONMA

1d ago

New

Senior Data Analyst

Full-timeOn-siteMcLean, VACompetitive

ICONMA’s confidential client, a real estate and financial services company, is seeking a Senior Data Analyst.

Why similarSame roleData IntegrationMcLean

Get new Data Analyst jobs in McLean by email

Create job alert

Data Analyst Senior

Mindlance · Competitive

Apply on company site