Skip to content
×

Senior Business Intelligence Engineer; to build semantic layer using GCP BigQuery and enterprise BI

Job in Toronto, Ontario, M5A, Canada
Listing for: S.i. Systems
Part Time, Contract position Listed on 2026-11-22

Job Description & How to Apply Below

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

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

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 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.
  • 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 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
  • Position Requirements

    10+ Years work experience
    To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
    (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).
    View / Apply for Jobs
    Matching My Jurisdiction

    Search for further Jobs Here:

    SEARCH JOBS: 10+ Million Listings
    (Try combinations for better Results! Or enter less keywords for broader Results)
    Job language:
    Education Level
    Experience Level (years)
    Posted in last:
    Salary