IT & Software

Business Intelligence Architect Developer

EXL

Canada · Nationwide · Canada

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.

#J-18808-Ljbffr

Reference: WJ-291_9238412

Find more on GigBlows

This role is listed on GigBlows for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.