
Senior Data Analyst
Sidram Technologies · McLean, VA, United States
Weak hiring record · median 373 days open
- First seen
- 20 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- 88% of this employer's openings are over 60 days old
In its favour
- Posted yesterday
- Still listed on the employer's own board
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.
Schedule
Standard
Senior Data Analyst – BF Modernization
Job Title
Senior Data Analyst – Data Discovery, Modernization & Migration
Position Overview
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.
Key Responsibilities
- 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.
- 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.
- 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.
- 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.
- 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.
Required 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.
Key Success Criteria The successful candidate will demonstrate the ability to:
Discover
Uncover hidden data relationships, business rules, and quality issues within
complex legacy systems.
Challenge
Critically evaluate existing data structures and processes instead of blindly
carrying them into the future state.
Transform
Help shape simplified, scalable, and business-aligned data models for
modern applications.
Migrate
Enable accurate, complete, and reliable data migration with minimal business
disruption.
Validate
Establish confidence in modernized applications through comprehensive
data reconciliation and validation.
Influence
Convert complex data findings into actionable decisions that improve
modernization outcomes.
Ideal Candidate Profile
We are looking for more than a traditional data analyst who can write SQL queries and
produce reports.
We need a critical thinker and hands-on data problem solver who can dissect complex
legacy data ecosystems, challenge existing assumptions, uncover hidden business logic,
and help reimagine how data should support modern business applications.
The ideal candidate combines deep technical data analysis expertise with business
acumen and a modernization mindset—ensuring that legacy complexity is not simply
migrated into the new technology landscape.
Required Skills
Basic Qualification
Additional Skills
Background Check
No
Drug Screen
No
More jobs at Sidram Technologies
All 2,928- Data Engineer, Ontada Data ProductsSidram Technologies · Irving, TX, United Statestoday
- Palo Alto / Zscaler Network Security EngineerSidram Technologies · Waukegan, IL, IL, United Statestoday
- Technical Product Owner & Project Manager - Finance Data HubSidram Technologies · Cary, NC, NC, United Statestoday
- Senior Java DeveloperSidram Technologies · Jacksonville, FL, United Statestoday
Similar roles
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Senior Data Scientist - Product Intelligence AnalyticsAxon · Washington · United States · USD 123,750–198,000/yrtoday