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

S.I. Systems Ltd.; Toronto; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

S.I. Systems Ltd. seeks a Senior BI Engineer with 10+ years of experience to design a semantic layer in GCP BigQuery and support enterprise BI reporting. The role sits in a large-scale ad revenue analytics initiative bridging BI, data engineering, and business analysis.

Hybrid work arrangement in Toronto (3 days on-site). You will develop SQL transformations, govern KPI definitions, and collaborate across Finance, Sales, and Executive stakeholders.

Qualifications

• 8+ years in BI/Analytics within enterprise data environments.
• Advanced SQL development, including joins, aggregations, window functions, and optimization.
• GCP BigQuery, semantic layers, dimensional models, and enterprise reporting models.
• Experience with Strategy (formerly MicroStrategy) and semantic models.
• Bachelor's degree in CS, Data Analytics, Information Systems, Engineering, or related field.
• Experience implementing governed analytics solutions and enterprise semantic layers.
• Ability to engage with cross-functional stakeholders and drive consensus.

Responsibilities

• Design and maintain the central semantic layer in GCP BigQuery for ad revenue reporting.
• Develop complex SQL transformations and centralized business logic for KPI consistency.
• Collaborate with Data Engineering to support data quality and lineage.
• Facilitate discussions on metric definitions and reporting standards.
• Support BI and reporting solutions powered by Strategy/MicroStrategy.
• Document business metadata, data definitions, and semantic artifacts.
• Develop dashboards and analytics-ready datasets for self-service reporting.

Skills

BI engineering

Advanced SQL

Cross-functional influence

Data modeling

Education

Bachelor's degree in Computer Science

Tools

GCP BigQuery

Strategy/MicroStrategy

Job description

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

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.