Business Intelligence Consultant

Akkodis; Alberta; On-site; CAD 80,000 - 100,000; Full time

Job summary

A global digital engineering company is seeking a Business Intelligence Analyst in Alberta, Canada. The role involves creating dashboards, translating business goals into actionable insights, and working closely with stakeholders. Ideal candidates should have hands-on experience with Power BI, data modeling, and SQL, along with a strong ability to communicate findings effectively. This position offers an opportunity to tackle complex datasets and drive data-driven decisions.

Qualifications

• Hands-on experience translating business requirements into analytical solutions.
• Experience designing, developing, and optimizing advanced Power BI solutions.
• Proficiency in SQL for data transformations and querying.

Responsibilities

• Design and develop dashboards and visual analytics using Power BI.
• Gather reporting requirements and KPIs from business units.
• Conduct deep-dive analytics to uncover trends and anomalies.

Skills

Power BI

Data Visualization

SQL

Azure Databricks

Data Modeling

Tools

Microsoft Power BI

Azure

Job description

About Akkodis:

Akkodis is a global digital engineering company and Smart Industry leader. Smart Industry is where engineering, IT and digital converge into a connected world. Akkodis tackles the world’s toughest challenges by deploying best-in-class engineering talent and cutting-edge technology practices that drive purposeful innovation.

About the role:

Our enterprise client is looking to fill the role of the Business Intelligence Analyst. BI Analyst will work on Translating data into actionable business insights supporting strategic decisions by creating dashboards, reports and business KPI’s.

Working with multiple stakeholder and users, BI Analyst will also understand the business goals and clearly communicate insights to stakeholders.

Duties:

• Design and develop complex dashboards, scorecards, and visual analytics using Power BI
• Design, develop, and maintain data models and visualizations using Microsoft Power BI and Azure-based data platforms
• Data Modeling & ETL Development
• Create optimized, reusable data models using DAX and Power Query M for enterprise-wide reporting
• Build interactive dashboards and reports tailored to business needs using Microsoft Power BI
• Integrate Power BI with various Microsoft Azure data sources and on-premises databases
• Work closely with Business users, data architects and data engineers to manage data pipelines, staging areas, and semantic models.
• Work with business units to gather reporting requirements and KPIs.
• Translate ambiguous business questions into concrete BI solutions.
• Present insights and findings in clear, executive-friendly formats.
• Provide end-user training and support to ensure adoption of BI tools
• Maintain and publish datasets and dashboards in Power BI Service with scheduled refreshes and alerts
• Optimize dashboards and reports for performance
• Implement security and user access controls within PowerBI
• Implement incremental data refresh, row-level security (RLS), and performance tuning strategies in Power BI.
• Conduct deep-dive analytics to uncover trends, anomalies, and business opportunities.
• Ensure data accuracy, consistency, and security compliance across all reporting assets

Required Experience (Mandatory)

• Hands-on experience translating business requirements into analytical solutions and communicate findings effectively to both technical and non-technical stakeholders to deliver end to end BI solutions.
• Hands-on experience designing, developing, and optimizing advanced Power BI solutions that transform regulated and complex datasets into actionable insights for policy, operations and executive reporting.
• Hands-on experience with a comprehensive set of visualization techniques and features that demonstrate both technical depth and storytelling skill using Power Bi.
• Hands-on experience with Azure Databricks leveraging Medallion Architecture and Unity catalog for data governance and secure access management.
• Hands-on experience in analyzing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools.
• Hands-on experience in SQL for data transformations querying, and analytical processing in large scale environments.

Candidates who are interested are welcome to submit their updated resumes either through the LinkedIn job posting or by emailing [e-mail].