Business Intelligence Engineer

Arobas Personnel is seeking a Business Intelligence Engineer for a mandate with one of its clients located in Toronto. This role is ideal for a data-driven professional who enjoys bridging business needs and technical solutions, while building scalable analytics and reporting environments in the cloud. Remote : Hybrid Key Responsibilities Semantic Layer Design & Data Modeling Support the design, development, and maintenance of a centralized semantic layer within Google Big.

Query , establishing a trusted source of business data. Translate and consolidate business rules from legacy reports into standardized database logic to ensure consistent KPI definitions and reporting across departments. Document business metrics, KPIs, dimensions, hierarchies, and calculation methodologies. Develop reusable data models that support both operational and executive reporting requirements.

Data Engineering Collaboration Partner with Data Engineering teams to ensure data quality, lineage, governance, and performance standards. Support the integration and transformation of data from multiple business systems while maintaining clear end-to-end data lineage documentation. Contribute to the design, documentation, and maintenance of SQL transformations, data models, and business logic supporting enterprise analytics.

Implement automated validation and reconciliation processes to improve data reliability. Business Intelligence & Self-Service Analytics Build and maintain semantic models that support enterprise BI and reporting platforms. Collaborate with BI Developers to enhance reporting usability and performance. Enable self-service analytics through governed datasets and reusable business metrics.

Support data security standards, including role-based and row-level access controls. Business Analysis & Stakeholder Engagement Gather and translate business requirements into functional and technical specifications. Work closely with stakeholders across Finance, Sales, Revenue Operations, Product Management, and other business functions to understand reporting needs.

Facilitate discussions regarding KPI definitions, business rules, and reporting standards. Document business processes, data definitions, and technical requirements. Maintain business glossaries, metadata definitions, and documentation supporting data governance initiatives. Required Qualifications Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related discipline.

3+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a similar role. Advanced SQL skills, including complex joins, aggregations, and performance optimization. Experience working within large-scale enterprise data environments. Strong expertise in dimensional modeling and analytics-focused data architectures.

Solid understanding of semantic layer concepts, data marts, and enterprise reporting frameworks. Knowledge of ETL/ELT processes and data integration methodologies. Experience with cloud analytics platforms, preferably Google Cloud Platform (GCP) . Experience with enterprise BI tools such as Strategy (formerly Micro. Strategy) or comparable reporting platforms.

Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

Hands-on experience with Big. Query , dbt , Dataflow , Airflow , or related cloud data technologies. Experience designing and maintaining enterprise semantic layers and governed analytics environments. Background in media, advertising, digital revenue, or high-volume transactional reporting environments is considered an asset.

Experience supporting financial reporting and reconciliation processes. Knowledge of data governance, metadata management, and master data management (MDM) principles. Technical Skills Data & Analytics Advanced SQL Dimensional Data Modeling Fact & Dimension Tables Star Schema Design Semantic Layer Architecture Data Warehousing ETL / ELT Processes Cloud & Engineering Google Cloud Platform (GCP) Big.

Query Data Pipelines Data Integration & Transformation BI & Reporting Strategy (Micro. Strategy) or equivalent BI platforms Semantic Models

• • Enterprise Reporting Solutions