About the Role
Our public sector client is seeking an Intermediate Business Intelligence Analyst for a 6-month, full time contract, with the possibility of up to a 6-month extension. The Business Intelligence Analyst will be required on a full time basis (7.25 hour work day, 36.25 hours/week) and is being sought as a dynamic, self-starting Business Process Analyst who is ready to champion change and manage multiple project streams while engaging stakeholders effectively.
Responsibilities will include:
• Data Enhancement & Quality Management:
Lead initiatives to enhance business data quality, identify data gaps, and implement validation frameworks to improve data accuracy.
• Dashboard Development & Reporting:
Develop, enhance, and maintain Power BI dashboards and reports, ensuring accuracy, usability, and real-time insights through SharePoint List integration and optimized DAX formulas.
• Training & User Support:
Conduct training sessions and develop user guides for Power BI users and other process improvement tools.
• Process Optimization & Documentation:
Collaborate with stakeholders to define, document, and optimize process flows using tools like Microsoft Visio. Maintain clear documentation of stakeholder workflows and process maps.
• SharePoint Management:
Refine and organize SharePoint repositories for contracts and data, ensuring accessibility and permissions management. Optimize workflows and enhance user experience.
• Stakeholder Collaboration:
Work with cross-functional teams to onboard stakeholders for new IT service enhancement projects. Ensure smooth adoption of tools and processes while maintaining strong relationships.
• Presentations & Communication:
Prepare and deliver professional presentations to communicate project progress, findings, and recommendations to technical and non-technical stakeholders.
Technical Skills and Qualifications:
• Proficiency in Power BI, including DAX, data modeling, and integrating SharePoint Lists.
• Advanced expertise in Excel, including pivot tables, VLOOKUP, INDEX-MATCH, and macros.
• Experience in managing SharePoint repositories, workflows, and permissions.
• Strong skills in creating process flows, diagrams, and visual representations using tools like Microsoft Visio.
• Demonstrated ability to identify and address data quality issues and implement data validation frameworks.
• Excellent communication and interpersonal skills to support stakeholder onboarding and training.
• Proven ability to manage multiple projects, timelines, and deliverables simultaneously.
• Experience in developing professional presentations and communicating effectively with diverse stakeholders.
• Analytical mindset with a strong problem-solving orientation.
Equipment requirements:
The client shall provide the requisite office space, Computer, furniture and office supplies, as this an on-site role.
Working Hours
Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province. This is a On site role.
Requirements
The following are requirements:
Must Have | |
Education | |
Yes/No - Post-Secondary degree, diploma or certificate in Computer Science or related field of study | Yes |
Technical Skills | |
Duration - Exp with articulating and translating technical language for non-technical customers... | 3 years |
Duration - Exp with presenting data in queries, dashboards, and reports in a way that is easy to... | 3 years |
Work Experience | |
Duration - Experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services. | 5 years |
Professional Licenses/Certification | |
Yes/No - PMI Project Management Professional (PMP) certification | Yes |
Technical Skills | |
Duration - Exp with data concepts such as: Extract Transform Load (ETL), Operational Data... | 2 years |
Work Experience | |
Duration - (B)Direct, hands-on experience performing business requirement analysis, solution... | 2 years |
About the Company