Senior Data Engineer

Ardent SoftSol Inc.; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

Ardent SoftSol Inc. in Toronto, Ontario, seeks a senior Data Analyst/Migration Lead to drive data analysis, profiling, discovery, and migration assessment activities across systems.

You will map sources to targets for BigQuery datasets, pipelines, and reporting assets, and review Airflow/Cloud Composer workflows and dependencies. You will define migration requirements, collaborate with Business SMEs, Architects, and Engineering teams to validate outcomes, and support UAT, data validation, and

Qualifications

• 9+ years of data analysis experience
• Strong understanding of data warehousing, lakehouse, and analytics platforms
• Experience with migration projects and data governance

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 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

SQL & Data Analysis

Data Profiling & Data Mapping

Job description

Contract

Years of Experience: 7-10 Years

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

Preferred Skills

• Strong understanding of Data Warehousing and Lakehouse concepts
• Experience with analytics platforms

Qualifications

• 9+ years of Data Analysis experience
• Strong understanding of Data Warehousing, Lakehouse, and Analytics platforms