Arobas Personnel is seeking a Senior Business Intelligence Engineer for a mandate with one of its clients located in Toronto.
This role is ideal for an experienced BI qualified with strong expertise in data modeling, semantic layer architecture, cloud analytics, and enterprise reporting. You will play a key role in establishing governance standards, modernizing analytics capabilities, and delivering trusted business insights across the organization.
Remote : Hybrid*
Key Responsibilities Semantic Layer Design & Data Modeling Design, develop, and maintain a centralized semantic layer within Google BigQuery to serve as the organization's trusted source of business data.
Consolidate business rules from legacy reporting systems into standardized database logic, ensuring consistency in KPIs and reporting metrics.
Define and maintain business metrics, dimensions, hierarchies, and calculation methodologies.
Create scalable and reusable data structures that support operational, analytical, and executive reporting requirements.
Data Engineering Collaboration Work closely with Data Engineering teams to ensure data quality, governance, lineage, and performance.
Develop and maintain complex SQL transformations and business logic.
Support data ingestion, integration, and end-to-end lineage mapping across multiple business domains.
Implement automated reconciliation, auditing, and validation processes.
Business Intelligence & Self-Service Analytics Develop and maintain semantic models that power enterprise BI and reporting solutions.
Partner with BI Developers to optimize report performance, scalability, and user experience.




Enable self-service analytics through governed datasets and reusable business metrics.
Business Analysis & Stakeholder Engagement Collaborate with stakeholders from Finance, Revenue Operations, Sales, Product Management, and other business units to understand reporting and analytics needs.
Lead discussions around KPI definitions, business rules, and reporting standards.
Provide governance and leadership for the definition, standardization, and ongoing maintenance of enterprise metrics and data definitions.
Data Governance & Quality Provide oversight for business glossaries, data dictionaries, metadata repositories, and semantic layer documentation.
Promote best practices in data governance, data quality, and enterprise reporting standards.
Ensure consistency and accuracy of business definitions across analytics solutions.
Required Qualifications Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field.
5+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or related disciplines.
Advanced SQL expertise, including complex joins, aggregations, window functions, and query optimization.
Experience working in large enterprise data environments.
Strong expertise in dimensional data modeling and analytics architecture.




Experience designing and maintaining enterprise semantic layers, data marts, or reporting frameworks.
Deep understanding of ETL/ELT processes and data integration methodologies.
Experience with cloud analytics platforms, preferably Google Cloud Platform (GCP).
Hands-on experience with enterprise BI solutions such as Strategy (formerly MicroStrategy) or equivalent platforms.
Excellent analytical, problem-solving, stakeholder management, and communication skills.
Preferred Qualifications Experience with BigQuery and modern cloud-based data platforms.
Proven experience implementing enterprise semantic layers and governed analytics solutions.
Experience in media, advertising, digital revenue, or similar high-volume reporting environments is considered an asset.
Experience supporting financial reporting and reconciliation activities.
Knowledge of data governance, metadata management, and master data management (MDM) principles.
Technical Skills Data & Analytics Advanced SQL Development
Dimensional Data Modeling
Semantic Layer Design
Data Warehousing
Enterprise Reporting Architecture
Cloud & Engineering Google Cloud Platform (GCP)
BigQuery
Data Pipelines
Git / Source Control
Data Integration & Transformation
BI & Reporting Strategy (MicroStrategy) or similar enterprise BI platforms
Semantic Models
Self-Service Analytics
Report Performance Optimization
KPI & Metrics Governance
Id 10033
Emplacement Toronto
Durée De L'emploi Temps Plein
Nombre D'emplois Vacants 1
Date Limite De Dépôt Dernière mise à jour:
26-10-06 15:18

#J-18808-Ljbffr

📌 Senior Business Intelligence Engineer (Ontario)
🏢 Arobas Personnel
📍 Ontario