Senior Business Intelligence Engineer (10+ years) to build a semantic layer using GCP BigQuery and enterprise BI reporting solutions - 010374 Our TMT client is seeking a

Senior Business Intelligence Engineer (10+ years) to build a semantic layer using GCP BigQuery and enterprise BI reporting solutions

Join a large-scale Consolidated Ad Revenue Reporting initiative focused on creating governed, analytics-ready datasets for enterprise reporting and self-service analytics. This role bridges Data Engineering, Business Intelligence, and Business Analysis to support consistent KPI definitions and trusted advertising revenue reporting across Finance, Sales, Revenue Management, and Executive stakeholders. The position involves designing and maintaining a scalable semantic layer, developing SQL transformations, and supporting enterprise reporting models within GCP BigQuery and Strategy (formerly MicroStrategy). The engagement supports a high-visibility reporting modernization initiative within a complex enterprise data workplace.

Contract: 12 months

Hybrid (3 days a week, on Tuesdays, Wednesdays and Thursdays), Queen Street West, Toronto, Working Hours: EST

Must Haves

8+ years in

Business Intelligence ,

Data Engineering , or Analytics Engineering within enterprise data environments

Advanced

SQL

development including joins, aggregations, window functions, and query optimization

Hands-on experience with

GCP BigQuery , semantic layers, dimensional data models, and enterprise reporting models

Experience with

Strategy (formerly MicroStrategy) ,





semantic models , and self-service analytics platforms

Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or related field

Experience implementing

governed analytics solutions and enterprise semantic layers

Demonstrated ability to effectively

engage and influence cross-functional stakeholders , including managing challenging discussions and driving consensus on business definitions, metrics, and reporting requirements.

Nice to Have

Experience with dbt and cloud storage technologies

Knowledge of advertising, media, broadcast, or digital revenue reporting

Experience supporting Finance reporting and reconciliation processes

Understanding of metadata management, business glossaries, and data lineage

Responsibilities

Design and maintain the central semantic layer within GCP BigQuery for ad revenue reporting

Develop complex SQL transformations and centralized business logic for KPI consistency

Collaborate with Data Engineering teams to support data quality, lineage, and performance

Facilitate discussions with stakeholders on metric definitions, reporting standards, and business rules

Support semantic models powering Strategy (formerly MicroStrategy) BI and reporting solutions

Document business metadata, data definitions, and semantic layer artifacts

Develop dashboards and analytics-ready datasets for self-service reporting

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.

#J-18808-Ljbffr

📌 Senior Business Intelligence Engineer (10+ years) to build a semantic layer using GCP BigQuery and e (Winnipeg)
🏢 S.I. Systems
📍 Winnipeg