Data Analyst

Data Analyst Remote Duration -4 months potential to be increased. Virtual Data Analyst - Cloud Migration Role Responsibilit ies Here are key job responsibilities for a Data Analyst supporting a legacy-to-GCP data migration proje ct: Migration Planning & Assess mentData Inventory & Audit: Identify and catalog all legacy data sources, including databases, data warehouses, files, and sys temsData Quality Assessment: Evaluate source data quality, identify gaps, inconsistencies, and anoma liesMigration Scope Definition: Help determine which data systems and datasets will be migrated vs. decommissi onedImpact Analysis: Document dependencies and identify systems/applications relying on legacy dataData Mapping & Transforma tionSchema Mapping: Map legacy database schemas to GCP target structures (BigQuery, Cloud SQL, e tc.)Data Transformation Logic: Define and document ETL/ELT rules and data transformation requirem entsData Lineage Documentation: Track data flow from source systems through transformation to GCP tar getsValidation Rules: Create data quality checks and reconciliation proce ssesGCP Platform Sup portGCP Architecture Familiarization: Learn GCP services relevant to migration (BigQuery, Dataflow, Pub/Sub, e tc.)Data Model Design: Collaborate on designing optimal data structures in GCP for performance and scalabi lityTool & Script Development: Support creation of migration scripts and testing framew orksPerformance Optimization: Analyze and optimize query performance in BigQuery and other GCP serv icesTesting & Valida tionTest Data Preparation: Create representative test datasets for UAT and valida tionMigration Testing: Execute test migrations and validate data accuracy and complete nessReconciliation: Compare source and target data to ensure successful migration with zero data lossPerformance Benchmarking: Track migration performance metrics and identify bottlen ecksStakeholder Engage mentRequirements Gathering: Interview business users and data owners to understand data n eedsDocumentation: Create comprehensive migration runbooks and data dictiona riesTraining Support: Help prepare documentation for post-migration data access and u sageChange Management: Communicate timelines, impacts, and new processes to stakehol dersPost-Migration Sup portData Validation: Perform comprehensive post-migration quality ch ecksPerformance Monitoring: Monitor GCP resource utilization and query perform anceIssue Resolution: Troubleshoot data discrepancies and resolve migration is suesDocumentation Updates: Maintain accurate documentation of migrated data as sets

The Data Analyst will support a legacy-to-GCP data migration project, focusing on migration planning, data mapping, and validation. Responsibilities include assessing data quality, defining transformation logic, and ensuring successful data migration.

Candidates should have experience in data analysis and migration, particularly with GCP services. Strong skills in data quality assessment, documentation, and stakeholder engagement are essential.

Identified from the job description. Confirm important requirements above.

• Data Analysis
• Data Migration
• Data Quality Assessment
• ETL
• Data Mapping
• GCP
• BigQuery
• Cloud SQL
• Data Transformation
• Data Lineage
• Performance Optimization
• Testing
• Documentation
• Stakeholder Engagement
• Change Management
• Post-Migration Support

Minimum experience

2+ years