Senior Data Analyst

InfoSpeed Services, Inc.; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

InfoSpeed Services, Inc. is seeking a Senior Data Analyst to lead a large-scale migration from GCP BigQuery to Azure Databricks. You will drive data discovery, source-to-target mapping, data lineage, migration planning, and validation across enterprise data domains.

You will analyze Airflow/Composer workloads, reconcile datasets, collaborate with SMEs and engineers, support UAT, and create governance artifacts such as data dictionaries and business rules.

Qualifications

• 12+ years of Data Analysis experience.
• Experience with large-scale data migration projects.
• Strong SQL skills and data profiling/mapping capabilities.

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.

Skills

GCP BigQuery

Apache Airflow / Cloud Composer

Spark / PySpark

SQL & Data Analysis

Data Profiling & Data Mapping

Job description

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
• Spark / PySpark
• SQL & Data Analysis
• Data Profiling & Data Mapping

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

This role is critical to the success of our data migration initiative, and we are looking for a candidate w