Onsite BI Analyst - Power BI & Data Insights

Pathlion; Edmonton; On-site; CAD 70,000 - 95,000; Full time

Job summary

Pathlion is seeking an Intermediate Business Intelligence Analyst onsite in Edmonton to design and develop dashboards and data models using Power BI to support the Oil Sands Monitoring Data Services program. You will translate business questions into BI solutions, work with data architects and engineers, and publish datasets with scheduled refreshes across the organization.

Proficiency in DAX, Power Query, and Azure data sources is preferred, with strong communication skills for stakeholder

Qualifications

• Experience designing and delivering dashboards and reports using Power BI.
• Ability to translate business questions into BI solutions and actionable insights.
• Experience with data modeling, ETL, and semantic modeling for enterprise reporting.

Responsibilities

• Design and develop complex dashboards, scorecards, and visual analytics using Power BI.
• Design, develop, and maintain data models and visualizations using Microsoft Power BI.
• Data Modeling & ETL Development; build optimized data models using DAX and Power Query M.
• Create dashboards and reports tailored to business needs and KPIs.
• Publish datasets in Power BI Service with scheduled refreshes and security controls.

Skills

Power BI

Data Visualization

DAX

Power Query

ETL Development

Data Modeling

Requirements gathering

Stakeholder communication

Tools

Azure

Power BI Service

Azure SQL (on-prem)

Job description

Pathlion is seeking an Intermediate Business Intelligence Analyst onsite in Edmonton to design and develop dashboards and data models using Power BI to support the Oil Sands Monitoring Data Services program. You will translate business questions into BI solutions, work with data architects and engineers, and publish datasets with scheduled refreshes across the organization.

Proficiency in DAX, Power Query, and Azure data sources is preferred, with strong communication skills for stakeholder