Business Intelligence Analyst

The project involves developing advanced analytics, reporting, dashboards, and data insights for the Government of Alberta's Digital Regulatory Assurance System (DRAS), supporting environmental and natural resource regulatory processes.

Location: Remote within Canada (Occasional onsite meetings in Edmonton, AB)

Responsibilities

• Design, develop, and maintain advanced dashboards, scorecards, and visual analytics using Microsoft Power BI.
• Build and optimize enterprise reporting solutions using Power BI, DAX, and Power Query.
• Develop and maintain data models, semantic models, and ETL processes.
• Integrate Power BI solutions with Azure-based data platforms and on-premises data sources.
• Collaborate with business stakeholders, data architects, and data engineers to understand reporting requirements and KPIs.
• Translate business requirements into scalable analytical and reporting solutions.
• Conduct data analysis to identify trends, patterns, anomalies, and business opportunities.
• Present analytical findings and recommendations to business and executive stakeholders.
• Implement and maintain Power BI Service features including scheduled refreshes, alerts, and workspace management.
• Configure Row-Level Security (RLS), incremental refresh, and performance optimization strategies.
• Ensure data quality, consistency, governance, and security compliance.
• Provide end-user support, training, and documentation.
• Leverage AI-assisted analytics tools to automate insights generation and enhance reporting capabilities.
• Perform other related duties as required.

Requirements

• Post-secondary Degree, Diploma, or Certificate in Computer Science, Information Technology, Data Analytics, or a related discipline.
• 5+ years of experience translating business requirements into analytical and reporting solutions.
• 5+ years of hands-on experience designing, developing, and optimizing advanced Power BI dashboards and reports.
• 5+ years of experience with SQL for querying, data transformation, and reporting.
• 5+ years of experience analyzing large and complex datasets.
• 5+ years of experience developing complex DAX measures, calculated columns, and data models.
• 4+ years of experience implementing Power BI Service capabilities including refresh schedules, security, and deployment.
• 4+ years of experience designing business intelligence and analytics solutions.
• 4+ years of experience using advanced data visualization and storytelling techniques.
• Strong experience working with Azure data platforms and enterprise reporting environments.

Additional Information

• Criminal Record Check may be required prior to project commencement.
• Successful candidate must complete mandatory Government of Alberta training, including: Freedom of Information and Protection of Privacy (FOIP), Security Awareness Training, Other required onboarding courses.