job summary:
We are seeking a highly skilled and analytical Senior Data Analyst with strong hands-on
experience in data profiling, data analysis, and enterprise application modernization. The
ideal candidate will play a critical role in transforming legacy (brownfield) applications into
modern, scalable, future-ready (goldfield) solutions while ensuring data integrity,
consistency, and seamless migration.
This role requires exceptional critical thinking, problem-solving capabilities, and the ability
to analyze complex legacy data ecosystems, uncover hidden business rules, identify data
dependencies, and translate business requirements into actionable data transformation
strategies.
The candidate will collaborate closely with business stakeholders, solution architects, data
engineers, application development teams, and quality assurance teams to drive data-
driven modernization decisions.
location: McLean, Virginia
job type: Contract
salary: $40 - 59 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
Key Responsibilities
1. Data Profiling & Discovery
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.
Discover 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.
2. Brownfield-to-Goldfield Application Modernization
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.
3. Data Migration & Transformation
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.
4. Critical Thinking & Problem Solving
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.
5. Business & Technical Collaboration
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:
Must Have Qualifications: 7 years of strong hands-on experience as a data analyst
required. The ideal candidate will have experience in data analysis, data profiling
(across both consumption and application), data concepts, data mapping, advanced
SQL proficiency, ETL processes, and solid technical skills in data. The candidate must
demonstrate excellent communication and coordination abilities, working effectively
with both business and technical teams. A background as a systems analyst, as well
as experience with MongoDB and NoSQL, are nice to have.
skills:
application architecture,complex datasets,business logic,business applications,data analysis,data- driven,data-driven,Data Analytics,Data Discovery,data-driven analysis,Data Platform,data integration,ensuring data integrity,referential integrity,data mapping,Data Migration,data profiling,data retention,data structures,data transformation,data validation,databases,data ecosystems,enterprise data platforms,enterprise application,ETL processes,ETL,advanced SQL queries,complex SQL queries,data engineering,Information Systems,computer science,legacy systems,experience with MongoDB,NoSQL,performance optimization,relational databases,SQL queries,application development,technical data,analytical,ability to analyze,analytical reasoning,business acumen,communication,Communicate,Strong communication skills,coordination,exceptional critical thinking,critical thinking,critical thinker,ability to influence,problem-solving capabilities,Problem Solving,problem-solving skills,problem solver,Proactively,Ability to work independently,Collaboration,acceptance criteria,UAT,architecture,data reconciliation,existing business processes,critical business processes,business requirements,business rules,business insights,assessments,corrective actions,data relationships,data models,data modeling,data quality,archival,consolidation,quality assurance,maintain data,Investigate,risks,root cause analysis,scalability,semantic,standardization,business value
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
We use AI tools to support our recruiters and interviewers with tasks like note-taking, summarization, and documentation of interviews to ensure they can be fully focused on your conversation. All hiring decisions are made by people.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
![]()