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 layerusing GCP BigQuery and enterprise BI reporting solutions - 010374 (Toronto)
🏢 S.I. Systems
📍 Toronto