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