Business Intelligence Analyst Goa0404

**Scope**:
**Project Overview**:
The Public Service Commission (PSC) is in search of an experienced Business Intelligence Analyst to strengthen our team. This role holds a pivotal position within our organization, focusing on developing a new dashboard to provide vital Human Capital Management (HCM) metrics. The aim is to empower the Government of Alberta and its departments to make well-informed decisions based on data-driven insights.

As a Business Intelligence Analyst, the position will be responsible for creating a consolidated workforce dashboard that integrates key Human Capital Management (HCM) data metrics to help Human Resources (HR) and management teams in the Alberta Public Service (APS), make data driven decisions for strategic workforce planning. This position will also be responsible for producing any technical and business documentation in support of this work. This will require close collaboration with cross-functional teams to understand their data needs, gather feedback, and implement solutions that provide alignment with strategic decisions. Collaboration with team members will be key to implement data visualization enhancements on existing dashboards.

**Duties**:
**General 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. This includes 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.

**MUST HAVE**
- **The proposed resource must meet or exceed one of the following**:
**- University graduation in business, management or a related discipline and 2-yr Business Analyst (BA) experience;**
**OR**
**- 2-yr diploma in business, management or a related discipline and 4-yr BA experience;**
**OR**
**- 1-yr certificate in business, management or a related discipline and 5-yr BA experience;**
**OR**
**- 6-yr BA experience**
- **Proposed resource has agreed to a Criminal Records Check and Enhanced Security Clearance prior to commencement.**

**WORK EXPERIENCE (At least 5 years)**
- Experience creating data visualizations, dashboards, and other information products for clients using BI/analytics software, including any or all: SAS Visual Analytics, SAS Visual Investigator, MS Power BI, Tableau, Looker, R, Python.
- Experience in facilitating business workshops.
- Experience in gathering requirements from a diverse group of stakeholders across ministries or departments.
- Experience with BI and advanced data analytics in an organization of equivalent size and complexity as the Government of Alberta.
- Experience with Power BI reporting and SQL Server Analysis Services/Integration Services/Reporting Services
- 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.
- Experience dealing with clients and explaining complex data principles in a thoughtful manner.
- Experience in building analytical and quantitative analysis models.
- Experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity
- Experience using human capital data for workforce analytics and reporting

Pay: $60.00 per hour

Expected hours: 36.25 per week

Additional pay:

- Retention bonus

**Benefits**:

- Dental care
- Flexible schedule
- Work from home

Flexible language requirement:

- French not required

Schedule:

- Monday to Friday

Work Location: Hybrid remote in Edmonton, AB T5K 2P7