Senior Data Analyst

Job summary

Lead data discovery, source-to-target mapping, and migration planning for a large-scale transition from GCP BigQuery to Azure Databricks. Collaborate with stakeholders to validate migration outcomes and create comprehensive data governance documentation.

Job details

Role: Senior Data Analyst Location: Downtown Toronto, Canada Duration: Fulltime Hybrid: (3 days office, 2 days remote) Job Summary We are seeking a Senior Data Analyst to play a pivotal role in a large-scale enterprise migration from GCP BigQuery to Azure Databricks. This position will focus on data discovery, source-to-target mapping, data lineage analysis, migration planning, reconciliation, and business validation activities across various enterprise data domains. The successful candidate will be instrumental in migrating BigQuery datasets, Airflow/Composer workloads, and analytics assets to an Azure Databricks Lakehouse platform. Responsibilities Lead data analysis, profiling, discovery, and migration assessment activities. Perform source-to-target mapping for BigQuery datasets, pipelines, and reporting assets. Analyze Airflow/Composer workflows and downstream dependencies. Define migration, reconciliation, and data quality requirements. Collaborate with Business SMEs, Architects, and Engineering teams to validate migration outcomes. Support User Acceptance Testing (UAT), defect analysis, data validation, and migration sign-off activities. Create data lineage, business rules, data dictionaries, and governance documentation. Mandatory Skills GCP BigQuery Apache Airflow / Cloud Composer Azure Databricks Spark / PySpark Data Migration & Data Reconciliation SQL & Data Analysis Data Profiling & Data Mapping Data Lineage & Data Governance Preferred Skills Experience with Enterprise Data Lake / Lakehouse architectures Familiarity with data governance frameworks Knowledge of data visualization tools Qualifications 12+ years of Data Analysis experience Proven experience supporting large-scale cloud data migration programs This role is critical to the success of our data migration initiative, and we are looking for a candidate who is detail-oriented, analytical, and capable of working collaboratively across teams. If you meet the qualifications and are excited about the opportunity to contribute to a transformative project, we encourage you to apply.

What you’ll do

Lead data discovery, source-to-target mapping, and migration planning for a large-scale transition from GCP BigQuery to Azure Databricks. Collaborate with stakeholders to validate migration outcomes and create comprehensive data governance documentation.

Requirements

Requires over 12 years of data analysis experience with a proven track record in large-scale cloud data migration programs. Must be proficient in GCP BigQuery, Azure Databricks, Spark, and Apache Airflow.

Listed skills

• SQL · Preferred
• Data analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• GCP BigQuery
• Apache Airflow
• Cloud Composer
• Azure Databricks
• Spark
• PySpark
• Data Migration
• Data Reconciliation
• SQL
• Data Analysis
• Data Profiling
• Data Mapping
• Data Lineage
• Data Governance
• Enterprise Data Lake
• Lakehouse Architecture

Job areas

• Data & Analytics
• Technology
• Consulting
• Software
• Engineering