Business Intelligence Analyst - Intermediate - Remote / Telecommute

Job Title: Business Intelligence Analyst - Intermediate - Remote / Telecommute

Job Location: Edmonton, AB

Job Type: Contract

Job Overview:

Requirement/Must Have:

• Post-Secondary degree, diploma or certificate in Computer Science or related field of study.
• Direct 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 (4 years).
• Direct 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 (4 years).
• Direct hands-on experience with a comprehensive set of visualization techniques and features that demonstrate both technical depth and storytelling skill using Power Bi (4 years).
• Direct hands-on experience in analyzing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools (4 years).
• Direct hands-on experience in SQL for data transformations querying, and analytical processing in large scale environments (4 years).

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.
• 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 Power BI.
• 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.

Nice to Have:

• Direct experience building data products in the client's cloud environment (1 year).
• Experience developing complex measures, calculated columns, advanced time intelligence using DAX (Data Analysis Expressions) in Power Bi (4 years).
• Experience implementing Power BI Service features such as data refresh, workspaces and row-level security (RLS) (2 years).
• Experience in presenting and storytelling to effectively communicate data-driven insights to executives and business users within a client's organization (4 years).
• Experience working with client's datasets particularly Environmental Data (Water Licensing, Ambient Water monitoring), Transportation (Heavy permit loads) and Consumer licensing (1 Year).