Business Intelligence Analyst

Job Title: Business Intelligence Analyst - Intermediate

Duration: 12 months (Maximum Extension Term: 12 months)

Location: Edmonton, AB (This resource will primarily work remotely; however, the resource may be required to attend meetings or work sessions in office on reasonable notice from the Province. Frequency of meeting could be up to 3-4 times per fiscal year)

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.

• RESOURCE REFERENCES

o Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource.

QUALIFICATIONS
:

Must Have

Education

Post-Secondary degree, diploma or certificate in Computer Science or related field of study

Work Experience

Direct hands-on experience with a comprehensive set of visualization techniques and features that demonstrate both technical depth and storytelling skill using Power Bi.

Experience developing complex measures, calculated columns, advanced time intelligence using DAX (Data Analysis Expressions) in Power Bi

Direct hands-on experience in analyzing large complex datasets to perform trend analysis, predictive analytics, and forecasting using Power BI and Azure analytics tools

Experience in creating and implementing business intelligence requirements.

Experience preparing visualizations, dashboards, and analytical models.

Experience understanding and developing requirements for analytical projects.

Experience with Contact Centre as a service (CCaaS) solutions and understanding of client interaction data is required

Nice to Have

Work Experience

Experience with dimensional modeling techniques.

Experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services.

Experience with relational database modeling techniques.

Experience working in a data warehouse/business intelligence or relevant data environment in either a development or support role.