Business Intelligence Analyst

Government of Alberta; Edmonton; On-site; CAD 68,000 - 91,000; Full time

Job summary

Join a dynamic team as a Business Intelligence Analyst within a forward-thinking government agency. This role is pivotal in transforming raw data into actionable insights, aiding decision-making across various departments. You'll lead projects, mentor junior staff, and develop forecasting models to enhance supply chain efficiency. With a focus on report design and visualization, your expertise will drive significant initiatives in a collaborative environment that values diversity and innovation. If you're passionate about data analysis and want to make a meaningful impact in public service, this opportunity is perfect for you.

Qualifications

• University degree in Business with Supply Chain specialization and 2 years of related experience.
• Certification in Supply Chain Management is an asset.

Responsibilities

• Analyze raw data and develop actionable insights to support business decisions.
• Lead process automation initiatives to improve efficiency.

Skills

Data Analysis

Statistical Analysis

Business Intelligence

Project Management

Mentorship

Education

University Degree in Business

Specialization in Supply Chain Management

Tools

Microsoft Office Suite

Robotic Process Automation

Power Apps

Excel Macros

SharePoint

Job description

Job Information
Job Title: Business Intelligence Analyst
Job Requisition ID: 64854
Ministry: Health
Location: Edmonton
Full or Part-Time: Full-Time
Hours of Work: 36.25 hours per week
Permanent/Temporary: Temporary (1 Year)
Scope: Open
Closing Date: February 10, 2025
Classification: Program Services 3 Market Adjustment
Salary: $2,626.89 to $3,448.73 bi-weekly ($68,561 - $90,011/year)

The Government of Alberta is committed to a diverse and inclusive public service that reflects the population we serve to best meet the needs of Albertans. Consider joining a team where diversity, inclusion, and innovation are valued and supported.

The Ministry of Health works to ensure Albertans receive the right health care services, at the right time, in the right place, provided by the right health care providers and teams. The Procurement & System Optimization Secretariat focuses on procurement efficiencies and system optimization as part of health care refocusing.

The Business Intelligence Analyst plays a crucial role in the division by leading projects, understanding requirements, analyzing, and transforming raw data into meaningful insights, thereby helping the division make informed decisions and increasing efficiencies throughout a large and diverse cross-functional area.

Focusing on report design and visualization coupled with extensive experience in statistics and data analysis, the Business Intelligence Analyst will show their expertise in the business of supply chain and finance and help push large initiatives. They will also support the development of business intelligence systems to store reporting data through their familiarity with business analysis and data warehousing concepts and tools.

Responsibilities

• Partner with various departments to gather data, negotiate vendor cost recovery agreements, and present findings through clear, actionable reports and presentations tailored for non-technical stakeholders.
• Provide mentorship and guidance to junior staff and effectively delegate tasks to promote efficient project execution and learning opportunities.
• Analyze raw data from various sources, identifying trends, inconsistencies, and improvement areas to develop actionable insights and support business decisions.
• Develop forecasting models and provide recommendations to enhance supply chain resiliency, optimize contract performance, and support strategic sourcing decisions for spend analysis.
• Lead process automation initiatives using tools such as Robotic Process Automation, Excel Macros, SharePoint Workflows, and Power Apps to streamline repetitive tasks, improve efficiency, and support solution implementation.
• Gather requirements and lead the setup of data warehouses, extracting, transforming, and loading data to support reporting, analytics, and new business processes while supporting change management activities.
• Collaborate with cross-functional teams to design dashboards and create data visualizations using business intelligence (BI) tools, effectively communicating key insights and solution recommendations to non-technical stakeholders and leaders.
• Conduct regular audits to ensure data accuracy, consistency, and security, identifying discrepancies and implementing corrective measures while maintaining up-to-date dashboards.
• Lead process improvement initiatives by identifying current and future requirements for continual improvement.
• Recommend and present purchase category changes to management after collaborating with stakeholders and conducting thorough analyses.

Qualifications

University Degree in Business with specialization in Supply Chain Management, Materials, Computer Sciences, or related discipline supplemented by two years related experience. Related experience or education may be considered as an equivalency on a one-for-one basis.

Assets

• Certification in Supply Chain Management through a professional association.
• Finance experience.
• Solid understanding of basic programming languages including advanced skills using Microsoft Office Suite, including Excel, SharePoint, and Power Apps.
• Project management experience and leading initiatives.
• Proven experience gathering business requirements and supporting change management activities.
• Proven experience with data administration and data management.
• In-depth knowledge of data management software, data operations, and analytical tools.
• Exceptional data analysis and research skills.

Hours of Work:
Monday to Friday from 8:15 AM – 4:30 PM

Location:
Working location is ATB Place, 10025 Jasper Avenue

How To Apply
Applicants are advised to provide information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies.

This competition may be used to fill future vacancies, across the Government of Alberta, at the same or lower classification level. We thank all applicants for their interest. All applications will be reviewed to determine which candidates' qualifications most closely match the advertised requirements. Only individuals selected for interviews will be contacted.