Business Intelligence Engineer (5+ years) to develop semantic layer solutions and analytics-ready datasets using GCP BigQuery and Strategy - 010375

S.I. Systems Ltd.; Toronto; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

S.I. Systems Ltd. in Toronto seeks a Business Intelligence Engineer with 5+ years of BI/Data Engineering to craft semantic layers and analytics-ready datasets on Google Cloud BigQuery.

You will bridge analytics, finance stakeholders, and BI developers to deliver governable data assets and AI-ready reporting. The role is contract, based at Queen Street West with hybrid work (3 days on-site). You will design dimensional models, implement complex SQL, and collaborate across enterprise data

Qualifications

• 5+ years in BI, Data Engineering, or Analytics Engineering.
• Advanced SQL development using BigQuery with complex joins/aggregations.
• Hybrid BI Developer and Data Engineer experience in large enterprise data environments.
• Design of dimensional data models, semantic layers, and enterprise reporting structures.
• Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or related field.
• Experience with Strategy (MicroStrategy) or similar enterprise BI platforms.
• Experience with cloud-based analytical platforms, preferably Google Cloud Platform.

Responsibilities

• Support design/maintenance of the enterprise semantic layer within GCP BigQuery.
• Extract business rules from legacy reports and centralize KPI definitions into the database layer.
• Document business metrics, hierarchies, metadata definitions, and calculation logic.
• Collaborate with Data Engineering teams on data quality, lineage, and performance initiatives.
• Develop and maintain SQL transformations, data models, and business logic for reporting datasets.
• Gather business requirements and translate them into technical specifications.
• Develop semantic models supporting Strategy and enterprise reporting solutions.

Skills

5+ years BI/Data Analytics

Advanced SQL

BigQuery

Hybrid BI/Data Engineer

Education

Bachelor's degree in CS/Data Analytics/IS

Tools

Google Cloud BigQuery

Strategy (MicroStrategy)

dbt

Dataflow

Airflow

Job description

Business Intelligence Engineer (5+ years) to develop semantic layer solutions and analytics-ready datasets using GCP BigQuery and Strategy - 010375

Our TMT client is seeking a Business Intelligence Engineer (5+ years) to develop semantic layer solutions and analytics-ready datasets using GCP BigQuery and Strategy.

Join a high-visibility Consolidated Advertising Revenue Reporting initiative supporting enterprise reporting and self-service analytics. This role bridges Data Engineering, Business Intelligence, and Business Analysis to transform complex advertising revenue data into governed datasets and semantic models. The position works closely with Data Engineering teams, Finance stakeholders, and BI developers to support trusted analytics and AI-ready reporting solutions. The engagement supports ongoing enterprise data initiatives with strong potential for continued project work.

Contract, Queen Street West, Toronto, Hybrid(3x/week, on Tuesdays, Wednesdays and Thursdays), Working Hours: EST

Must Haves

• 5+ years in Business Intelligence, Data Engineering, or Analytics Engineering roles
• Advanced SQL development using BigQuery with complex joins and aggregations
• Hybrid BI Developer and Data Engineer experience within large enterprise data environments
• Design of dimensional data models, semantic layers, and enterprise reporting structures
• Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or a related field
• Experience with Strategy (formerly MicroStrategy) or similar enterprise BI platforms
• Experience working with cloud-based analytical platforms preferably Google Cloud Platform (GCP)

Nice to Have

• Experience with dbt, Dataflow, Airflow, or similar cloud data technologies
• Background in advertising, media, broadcast, or digital revenue reporting
• Experience supporting Finance reporting and reconciliation processes
• Understanding of data governance, metadata management, and master data management concepts

Responsibilities

• Support the design and maintenance of the enterprise semantic layer within GCP BigQuery
• Extract business rules from legacy reports and centralize KPI definitions into the database layer
• Document business metrics, hierarchies, metadata definitions, and calculation logic
• Collaborate with Data Engineering teams on data quality, lineage, and performance initiatives
• Develop and maintain SQL transformations, data models, and business logic for reporting datasets
• Gather business requirements and translate them into technical specifications
• Develop semantic models supporting Strategy and enterprise reporting solutions

Disclaimer: AI may be used in evaluating candidates. This posting is for an existing vacancy.