Senior Data Analyst Data Transformation Program

Overview

On Site
$40 - $50
Contract - W2
Contract - 6 Month(s)

Skills

data analysis
metadata
ETl
Snowflake
NoSQL
GraphQL

Job Details

Role: Senior Data Analyst Data Transformation Program
Location: McLean, VA (Onsite 5 Days)
Duration: 6+ Months
Job Description:
Key Responsibilities:
Conduct in-depth data profiling of source and target systems to assess structures, anomalies, and readiness for migration.
Analyze complex ETL logic, particularly in IBM DataStage, to extract and document transformation and business rules.
Lead development of source-to-target mapping specifications, including transformations, joins, filters, and derived fields.
Collaborate with business, engineering, and governance teams to define and validate data requirements and lineage.
Document metadata, business terms, and mapping relationships in Collibra, ensuring alignment to enterprise standards.
Support testing, validation, and reconciliation efforts by tracing lineage and comparing expected vs. actual outcomes.
Mentor junior analysts and help enforce data quality, documentation, and metadata standards across the program.
Required Experience:
5+ years of experience in a data analyst or technical business analyst role with a focus on data transformations or migrations.
Strong SQL skills and hands-on experience with data profiling and validation across large datasets.
Proven experience working with ETL tools, with the ability to interpret complex logic (IBM DataStage preferred).
Expertise creating detailed source-to-target mapping documents and documenting transformation logic.
Experience working with Collibra for metadata management, business term definitions, and lineage tracking.
Strong analytical, documentation, and communication skills.
Ability to work independently and lead discussions with cross-functional teams.
Preferred Experience:
Experience with enterprise data platforms (e.g., Snowflake, NoSQL, GraphQL-based APIs).
Familiarity with data governance frameworks and enterprise data models.
Background in financial services, insurance, or regulatory reporting environments.
Exposure to JSON, XML, or API-based data integrations.
Reporting To:
Data Lead / Program Manager

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.