Role: Senior Data Analyst

Location: Downtown Toronto, Canada

Duration: Fulltime

Hybrid: (3 days in 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

📌 Senior Data Analyst (Toronto)
🏢 Umanist Staffing
📍 Toronto