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
Not the right fit? Search for Data Analyst jobs in Canada
About Envision Technology Solutions
Envision Technology Solutions (ETS) is a leading staffing and recruitment firm specializing in providing top-tier talent and workforce solutions across industries. With a proven track record, we connect exceptional candidates with exceptional opportunities, helping businesses thrive and individuals achieve their career goals.
ETS has a team of highly skilled recruiters and industry experts with in-depth knowledge of different sectors. Leveraging our expertise, we identify, attract, and select the best candidates for clients' unique requirements. Our extensive network and thorough screening processes ensure presenting only the most qualified candidates.
We have expertise in IT, Technology, Finance, Accounting, Engineering, Marketing, and more. Specialized recruiters understand sector-specific challenges, enabling tailored staffing solutions.
Why Choose ETS:
- Proven Track Record: Proven results through successful placements and partnerships.
- Extensive Talent Network: Diverse candidate sourcing through vast network.
- Personalized Approach: Customized solutions for clients and candidates.
- Industry Knowledge: Cutting-edge staffing solutions through trend awareness.
- Commitment to Excellence: Exceptional service, exceeding expectations for success.
Connect with us to stay updated on the latest job opportunities, industry insights, and professional development resources.
Let us help you find the right talent or discover your next career move!
Similar Jobs
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
Not the right fit? Search for Data Analyst jobs in Canada
About Envision Technology Solutions
Envision Technology Solutions (ETS) is a leading staffing and recruitment firm specializing in providing top-tier talent and workforce solutions across industries. With a proven track record, we connect exceptional candidates with exceptional opportunities, helping businesses thrive and individuals achieve their career goals.
ETS has a team of highly skilled recruiters and industry experts with in-depth knowledge of different sectors. Leveraging our expertise, we identify, attract, and select the best candidates for clients' unique requirements. Our extensive network and thorough screening processes ensure presenting only the most qualified candidates.
We have expertise in IT, Technology, Finance, Accounting, Engineering, Marketing, and more. Specialized recruiters understand sector-specific challenges, enabling tailored staffing solutions.
Why Choose ETS:
- Proven Track Record: Proven results through successful placements and partnerships.
- Extensive Talent Network: Diverse candidate sourcing through vast network.
- Personalized Approach: Customized solutions for clients and candidates.
- Industry Knowledge: Cutting-edge staffing solutions through trend awareness.
- Commitment to Excellence: Exceptional service, exceeding expectations for success.
Connect with us to stay updated on the latest job opportunities, industry insights, and professional development resources.
Let us help you find the right talent or discover your next career move!