Business Intelligence Analyst
Job Title: Business Intelligence Analyst - Intermediate
Duration: 5 months (Maximum Extension Term: 6 months)
Location: Edmonton, AB (Resource will work remotely, though must be available for onsite meetings when required.)
Description:
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.
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
QUALIFICATIONS:
Must Have
Education
Yes/No - 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
Other
Other - Eligibility for Enhanced Security Clearance – Yes/No
Work Experience
Duration - 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.
Duration - Experience in facilitating business workshops.
Duration - Experience in gathering requirements from a diverse group of stakeholders across ministries or departments.
Duration - Experience with BI and advanced data analytics in an organization equivalent size to Company
Duration- Experience with Power BI reporting and SQL Server Analysis Services/Integration Services/Reporting Services
Nice to Have
Work Experience
Duration - (C) 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.
Duration - Experience dealing with clients and explaining complex data principles in a thoughtful manner
Duration - Experience in building analytical and quantitative analysis models.
Duration - Experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity
Duration - Experience using human capital data for workforce analytics and reporting
Duration - Experience working on enterprise applications, i.e., applications used by all or most departments in a large organization, rather than applications used by just one or a few departments.