Business Intelligence Analyst – Intermediate

GuuZ Consulting Services Inc; Alberta; On-site; CAD 80,000 - 100,000; Full time

Job summary

A consulting firm is seeking a Business Intelligence Analyst in Alberta, Canada. The role involves developing a PowerBI dashboard for Human Capital Management metrics. Candidates should have substantial experience in BI/Analytics software and effective stakeholder communication skills. This position offers a 6-month contract with a potential for extension.

Qualifications

• 2 years of Business Analyst experience or equivalent
• 4 years of experience in creating data visualizations and dashboards
• 5 years of experience in facilitating business workshops
• 4 years of experience with Power BI reporting

Responsibilities

• Design and build a new PowerBI workforce insights dashboard.
• Collaborate with cross-functional teams for data reporting requirements.
• Maintain documentation of business and technical information.
• Develop training materials and strategies for end-users.

Skills

Data visualization

SAS Visual Analytics

MS Power BI

SQL Server Analysis Services

Stakeholder engagement

Project management

Data governance

Communication

Education

University graduation in business or related discipline

2-year diploma in business or related discipline

1-year certificate in business or related discipline

Tools

Tableau

Looker

R

Python

Job description

Overview

Our government client is looking to contract a Business Intelligence Analyst to join their team. This role focuses on developing a new dashboard to provide vital Human Capital Management (HCM) metrics, empowering the public sector and its departments to make well-informed, data-driven decisions.

As a Business Intelligence Analyst, the position will be responsible for creating a consolidated workforce dashboard that integrates key HCM data metrics to help Human Resources (HR) and management teams across the public sector make data-driven decisions for strategic workforce planning. This role will also involve producing technical and business documentation in support of the work, requiring close collaboration with cross-functional teams to understand data needs, gather feedback, and implement solutions aligned with strategic decisions. Collaboration with team members will be key to implementing data visualization enhancements on existing dashboards.

Responsibilities

• Design and build a new PowerBI workforce insights dashboard which consolidates HCM data metrics. Responsibilities will include project planning, stakeholder engagement, prototype design, testing, and release.
• Collaborate with cross-functional teams, both internal and external, to ensure alignment with business objectives and data reporting requirements, including collaboration with both technical and non-technical resources.
• Capture and maintain documentation of business and technical information, ensuring transparency and traceability.
• Develop training materials and strategies to enable end-users to effectively use the new dashboard. Provide training to the internal team as needed.
• Identify and escalate issues and risks as appropriate, and work to resolve them to ensure smooth project progression.
• Manage tasks, action items, and timelines for the project. Follow up on outstanding items and escalate as needed.
• Effectively communicate findings, insights, and project progress to stakeholders in a clear and understandable manner for both technical and non-technical audiences.
• Prepare presentations and demonstrations for engagement with stakeholders.
• Ensure data governance and data quality practices are adhered to in the creation and maintenance of the new dashboard.
• Ensure that data security and privacy guidelines are followed in all aspects of the work.

Deliverables

• A consolidated, user-friendly dashboard which provides key workforce metrics and aligns with existing dashboards.
• Technical and business documentation, including an updated data warehouse data and definitions catalogue.
• Dashboard user guides.
• Status reports - weekly and monthly.

Experience Requirements

Must Have

• The successful candidate must meet or exceed one of the following:
• University graduation in business, management or a related discipline and 2-year Business Analyst (BA) experience; OR
• 2-year diploma in business, management or a related discipline and 4-year BA experience; OR
• 1-year certificate in business, management or a related discipline and 5-year BA experience; OR
• 6-year BA experience
• 4 years of experience creating data visualizations, dashboards, and other information products for clients using BI/Analytics software, including SAS Visual Analytics, SAS Visual Investigator, MS Power BI, Tableau, Looker, R, Python.
• 5 years of experience in facilitating business workshops.
• 5 years of experience in gathering requirements from a diverse group of stakeholders across various departments.
• 4 years of experience with BI and advanced data analytics in an organization of a size comparable to the public sector.
• 4 years of experience with Power BI reporting and SQL Server Analysis Services/Integration Services/Reporting Services.

Nice to Have

• 5 years of direct, hands-on experience performing business requirement analysis, solution architecture and design, and deployment related to data management, acquisition, preparation, quality and data lineage/provenance.
• 5 years of experience dealing with clients and explaining complex data principles in a thoughtful manner.
• 5 years of experience in building analytical and quantitative analysis models.
• 5 years of experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents.
• 2 years of experience using human capital data for workforce analytics and reporting.
• 3 years of experience working on enterprise applications used across a large organization.

Contract

6 months contract with a potential of another 12 months extension