Intermediate BI Analyst with a background in procurement or supply chain to work with large gov[...]

S I Systems; Edmonton; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading consulting firm is seeking an Intermediate BI Analyst to work in Edmonton. The role involves building PowerBI and SQL reporting for large government datasets. The ideal candidate has over 4 years of experience in BI analysis, a strong background in procurement, and skills in data visualization. This is an onsite position with specific working hours.

Qualifications

• 4+ years experience as a BI Analyst.
• Experience articulating technical language for non-technical customers.
• 2+ years in public sector procurement processes.

Responsibilities

• Deliver BI capabilities for internal and external stakeholders.
• Analyze data and prepare reports.
• Manage control processes and ensure quality standards.

Skills

Power BI

Analytical skills

SQL Reporting

Data visualization

Communication

Education

Post-Secondary degree or diploma in Computer Science or related field

Minimum 2-year diploma in supply chain or procurement

Tools

PowerView

Microsoft SQL Reporting

SAP

Job description

Intermediate BI Analyst with a background in procurement or supply chain to work with large government data sets to build PowerBI, PowerView, and SQL Reporting and Analytical Services (657)

Our client is seeking an Intermediate BI Analyst with a background in procurement or supply chain to work with large government data sets to build PowerBI, PowerView, and SQL Reporting and Analytical Services.

This is an onsite role which requires onsite work from 8:15-4:30 in Edmonton

Must Haves:

• 4+ years as a BI Analyst with experience in:
• Articulating and translating technical language for non-technical customers, both verbally and in writing.
• Presenting data in queries, dashboards, and reports that are easy to understand.
• Designing, developing, and optimizing advanced Power BI solutions that transform complex datasets into actionable insights for policy, operations, and executive reporting.
• Planning, conducting, and analyzing findings from co-design workshops with service users.
• Post-Secondary degree, diploma, or certificate in Computer Science or a related field.

Additional experience required includes:

• 2+ years in public sector procurement processes
• 4+ years with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services
• 2+ years working with large government datasets
• Relevant post-secondary education in supply chain, procurement, business, or related fields (degrees, diplomas, or certificates, minimum 2-year diploma).

Key Responsibilities:

• Contribute to a team delivering business intelligence capabilities to support internal and external stakeholders.
• Deliver work products based on various data sets, including education, finance, census, etc.
• Work with technology products like SAP and Power BI to meet evolving information needs.
• Collaborate effectively with in-house staff and contractors.
• Analyze data and prepare reports.
• Gather and document requirements.
• Design and develop information products.
• Capture metadata for information products.
• Manage control processes, schedules, and reporting.
• Ensure quality standards and timely delivery.
• Perform quality assurance on BI deliverables.
• Respond to ad-hoc data inquiries.
• Perform data analysis, quality audits, statistical analysis, and data mining.
• Escalate issues and risks appropriately.
• Work within a multi-vendor/staff environment.