Senior Business Intelligence Engineer; to build semantic layer using GCP BigQuery and enterprise BI
Senior Business Intelligence Engineer (10+ years) to build a semantic layer using GCP Big Query 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 Big Query 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 Big Query and Strategy (formerly Micro Strategy).
The engagement supports a high-visibility reporting modernization initiative within a complex enterprise data environment.
Contract:
12 months
Hybrid (3 days a week, on Tuesdays, Wednesdays and Thursdays), Queen Street West, Toronto,
Working Hours:
EST
- 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 Big Query
, semantic layers, dimensional data models, and enterprise reporting models - Experience with Strategy (formerly Micro Strategy),
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.
- 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
- Design and maintain the central semantic layer within GCP Big Query 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 Micro Strategy) 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.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).