Data Engineer / BI Developer — GCP, dbt & Power BI

OSI Digital, Inc.; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

OSI Digital, Inc. is seeking a Data Engineer / BI Developer in Toronto to design, build, and optimize cloud-native data pipelines and analytics solutions. You will work with GCP, BigQuery, Airflow, dbt, SQL, and Power BI to deliver scalable data models and compelling dashboards.

The ideal candidate has 2–4 years of experience, strong SQL skills, and hands-on BI capabilities. This role emphasizes data warehousing, ETL/ELT patterns, and close collaboration with business stakeholders.

Qualifications

• 2–4 years of experience in Data Engineering, BI, or Analytics Engineering.
• Hands-on with Google BigQuery, Apache Airflow, dbt, SQL, and Power BI.
• Strong knowledge of data warehousing, ETL/ELT, data modeling and dashboard development.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Apache Airflow.
• Develop and optimize data warehouse solutions using Google BigQuery.
• Build reusable and maintainable transformation models with dbt.
• Develop interactive reports and dashboards using Power BI.
• Write complex SQL queries for extraction, transformation, validation, and reporting.
• Create and maintain dimensional models, fact tables, views, and reporting datasets.
• Develop dbt models, tests, documentation, macros, and incremental processing logic.
• Monitor Airflow DAGs and troubleshoot pipeline and data-quality issues.
• Optimize BigQuery queries for performance and cost efficiency.
• Build Power BI semantic models, relationships, measures, and DAX calculations.
• Perform source-to-target validation and data reconciliation.
• Implement data-quality checks to ensure reliable reporting.
• Participate in code reviews, deployments, testing, and production support.
• Maintain technical documentation for pipelines, transformations, datasets, and dashboards.

Skills

Data engineering

BI development

SQL

ETL/ELT

Data modeling

Git

Python

Agile/Scrum

Stakeholder collaboration

Tools

Google BigQuery

Apache Airflow

dbt Core/Cloud

Power BI

Power Query

DAX

Power BI Service

Git

Python

Databricks

Snowflake

Azure/AWS

Job description

OSI Digital, Inc. is seeking a Data Engineer / BI Developer in Toronto to design, build, and optimize cloud-native data pipelines and analytics solutions. You will work with GCP, BigQuery, Airflow, dbt, SQL, and Power BI to deliver scalable data models and compelling dashboards.

The ideal candidate has 2–4 years of experience, strong SQL skills, and hands-on BI capabilities. This role emphasizes data warehousing, ETL/ELT patterns, and close collaboration with business stakeholders.