Business Intelligence Architect Developer

EXL; Canada; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading analytics firm in Canada is seeking a highly skilled Business Intelligence Architect/Developer with over 5 years of experience. The role involves designing and developing enterprise BI solutions using Power BI and Tableau, with a focus on the insurance domain. Candidates should have proficiency in data modeling, ETL processes, and Python, as well as the ability to collaborate with business stakeholders effectively. This position offers the opportunity to impact analytics and reporting solutions significantly.

Qualifications

• 5+ years of experience in business intelligence or analytics roles.
• Strong expertise in Power BI and Tableau for data visualization.
• Hands-on experience with modern data platforms and ETL processes.

Responsibilities

• Design, develop, and maintain BI reports and dashboards.
• Partner with stakeholders to analyze business needs and translate them into solutions.
• Build and optimize data models and ETL processes.

Skills

Power BI

Tableau

Python

SQL

Data modeling

Tools

Snowflake

Microsoft Fabric

Power Automate

Job description

Business Intelligence Architect Developer

We are seeking a highly skilled Business Intelligence Architect/Developer with 5+ years of experience to design, develop, and support enterprise BI solutions. The ideal candidate will have strong expertise in Power BI and Tableau, hands‑on experience with modern data platforms, and solid insurance domain knowledge to deliver impactful analytics and reporting solutions.

Key Responsibilities

• Design, develop, and maintain BI reports, dashboards, and visualizations using Power BI and Tableau, with exposure to Microsoft Fabric (semantic models, Lakehouse/Warehouse concepts, and Fabric-enabled Power BI workloads).
• Partner with business stakeholders to gather requirements, analyze business needs, and translate them into scalable BI and analytics solutions, leveraging insurance domain expertise (policy, claims, underwriting, premiums, loss ratios).
• Build, optimize, and maintain data models, ETL/ELT processes, and semantic layers to support enterprise reporting and self‑service analytics.
• Develop and optimize M (Power Query) and DAX for advanced data transformations, calculations, and performance tuning in Power BI.
• Create and maintain Python scripts for data processing, automation, and analytical workflows.
• Integrate and automate data and reporting workflows using Power Automate to improve efficiency and reliability.
• Collaborate with data engineering and platform teams to support reporting and analytics using Snowflake and other modern data warehouse platforms.
• Write and optimize complex SQL queries while adhering to relational database design principles and best practices.
• Troubleshoot issues, tune performance, and ensure the accuracy, consistency, security, and governance of BI solutions.
• Provide ad‑hoc reporting and analytics support while enabling self‑service BI for business users.