Job ID: 91109-1
Job Title: Sr Data Analyst
Location: San Jose CA
Duration: 6+ months
Rate Range: $50 - $53/hour on W2/ C2C (All inclusive)
Job Summary:
We are seeking a highly skilled Senior Data Migration Analyst to support enterprise data migration and transformation initiatives. The ideal candidate will be responsible for analyzing legacy systems, mapping and validating data, developing migration strategies, and ensuring seamless data conversion into target platforms. This role requires strong analytical skills, advanced SQL expertise, and the ability to collaborate effectively with business stakeholders, IT teams, and third-party vendors.
Key Responsibilities:
" Analyze legacy source systems to understand data structures, business rules, and data relationships.
" Develop comprehensive source-to-target mapping documents for data migration projects.
" Extract, cleanse, transform, and validate data from multiple source systems.
" Write complex SQL queries to analyze, validate, reconcile, and troubleshoot data.
" Support the design and execution of ETL (Extract, Transform, Load) processes.
" Perform data profiling, data quality assessments, and data cleansing activities.
" Conduct pre-conversion assessments, mock migrations, and dry-run testing.
" Validate migrated data to ensure accuracy, completeness, and consistency.
" Identify and resolve data discrepancies prior to production deployment.
" Collaborate with business users, project teams, and third-party vendors to define data requirements and migration rules.
" Create data reconciliation reports and migration validation documentation.
" Support go-live activities and post-migration data verification efforts.
" Ensure compliance with data governance, security, and regulatory requirements.
Required Qualifications:
" 5+ years of experience as a Data Analyst, Data Migration Analyst, or Data Conversion Analyst.
" Strong expertise in data migration, data conversion, and data validation projects.
" Advanced SQL skills with experience writing complex queries, joins, stored procedures, and data reconciliation scripts.
" Experience with ETL processes and data transformation methodologies.
" Strong understanding of relational databases and data modeling concepts.
" Experience performing data mapping, profiling, cleansing, and validation.
" Proven ability to analyze large and complex datasets.
" Strong problem-solving and analytical skills.
" Experience working with business stakeholders and cross-functional teams.
" Excellent communication and documentation skills.
Preferred Qualifications:
" Experience with enterprise system migrations or modernization projects.
" Knowledge of ETL tools such as Informatica, SSIS, Talend, or similar platforms.
" Experience with data governance and data quality frameworks.
" Exposure to cloud-based data platforms and analytics solutions.
" Experience supporting large-scale data conversion and implementation projects.
Key Skills:
" Data Migration
" Data Conversion
" Data Mapping
" Data Validation
" SQL
" ETL Processes
" Data Cleansing
" Data Profiling
" Data Reconciliation
" Data Quality Analysis
" Business Analysis
" Analytics
" Stakeholder Management
" Documentation
" Testing & Validation
Company Benefits & Culture
For immediate consideration please click APPLY to begin the screening process with Alex.