Job Description

Title: Business Intelligence Analyst - Intermediate
Location: Edmonton, AB (Remote)
Duration: 7 months with possible extension
:

• Post-Secondary degree, diploma or certificate in Computer Science or related field of study. Yes/No
• 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 with Azure Databricks leveraging Medallion Architecture and Unity catalog for data governance and secure access management. 1 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
• Direct experience building data products in Government of Alberta cloud environment. 1 years
• 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 government organization. 4 years
• Experience working with Government of Alberta datasets particularly Environmental Data (Water Licensing, Ambient Water monitoring), Transportation (Heavy permit loads) and Consumer licensing. 1 years
• Proven experience in building and delivering data products using Synapse Analytics including development of curated dataset and Power Bi integration. 2 years