Temporaryjobs Logo
Envision Technology Solutions logo

Data Analyst

Canada
Niveau intermédiaire

About the role

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

About Envision Technology Solutions

IT Services and IT Consulting