Business Intelligence Analyst

Role Responsibilities

The Business Intelligence Analyst plays a crucial role in the division by leading projects, understanding requirements, analyzing, and transforming raw data into meaningful insights, or preforming systems optimization, 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 helps 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.

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.

This link will assist you with understanding competencies:
https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.
 

• Agility: Actively anticipates, prepares and adapts to new priorities. Is flexible in planning and design of system structures in anticipation of potential changes.
• Develop Networks: Ability to develop, maintain and leverage trusting working relationships with divisional representatives and ensures that our division's end users are satisfied with our outputs.
• Build Collaborative Environments: Able to communicate and collaborate with multiple departments and stakeholders.
• Creative Problem Solving: Ability to access resources, information and technology from other areas, and use it to analyze issues, resolve problems and improve performance.
• Systems Thinking: Ability to accurately analyze, identify and define Ministry initiatives and priorities to ensure alignment with larger government strategies.

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.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. 

Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards.

Notes

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

Location:
Working location is ATB Place, 10025 Jasper Avenue
 
Other information: 
A cover letter outlining how your experience relates to the qualifications of this role is recommended.     
 
Final candidates will be required to undergo a security screening.
 
Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in. 

What we offer:
Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx.
Public Service Pension Plan (PSPP) - https://www.pspp.ca.
Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits.
Professional learning and development - https://www.alberta.ca/professional-development-support-directive.
Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca.
Positive workplace culture and work-life balance.
Opportunity to participate in flexible work arrangements such as working from home up to two days per week and modified work schedule agreement.
Leadership and mentorship programs.