Intermediate Business Intelligence Analyst

Please send your resume at if you are interested in this 12 month contract (01/07/2026 to 01/06/2027) contract role. Please feel free to forward if you are not interested. This is with Govt of Alberta.

Intermediate Business Intelligence Analyst - (GOAPRDJP

Work Status:
On-Site

Location:
ST NW, Edmonton, Alberta, T5K 2J6

Must Have: Education

• Post-Secondary degree, diploma or certificate in Computer Science or related field of study.

Must Have: Technical Skills

• 4 years experience with articulating and translating technical language for non-technical customers both verbally and in writing.
• 4 years experience with data concepts such as: Extract Transform Load (ETL), Operational Data Store (ODS), Online Transaction Processing (OLTP), etc.
• 4 years experience with presenting data in queries, dashboards, and reports in a way that is easy to understand.

Must Have: Work Experience

• 4 years direct hands-on experience designing, developing, and optimizing advanced Power BI solutions that transform regulated and complex datasets into actionable insights for policy, operations and executive reporting
• 4 years experience in creating and implementing business intelligence requirements.
• 4 years experience with dimensional modeling techniques.
• 4 years experience working in a data warehouse/business intelligence or relevant data environment in either a development or support role.

Nice to have: Soft Skills

• Ability to collaborate and work with various stakeholders.
• Ability to interact and communicate professionally with a diverse group.

Nice to have: Technical Skills

• Ability to think critically to select the most appropriate input data, modeling method, indicated variables, and techniques.

Nice to have: Work Experience

• 4 years experience using Microsoft SQL.
• 4 years experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services.
• 4 years experience with relational database modeling techniques.

Description

Business Intelligence in Category Management supports evidence-based decision-making by transforming procurement and contract data into actionable insights. The role analyzes spend, supplier, and market information to identify enhance performance reporting, ensuring the unit has reliable, timely, and meaningful data intelligence.

Contribute as part of a team, responsible for delivering business intelligence capabilities to support internal and external department stakeholders' information needs.

• Deliver work products based on various sets of data including (but not limited to) procurement, contracts, finance and market data.
• Work with a selection of technology products (such as SAP, Power BI, Alteryx) that must address the ever changing
• technology and increasing appetite for information from internal and external department stakeholders.
• Must be able to work effectively with a team made up of in-house staff and contract resources.
• Analyze data and prepare information results.
• Gather and document requirements.
• Design and construct information products.
• Capture business and technical metadata for information products.
• Gather requirements for control processes including schedule management, status reporting, issues, risk, and change management at the program level.
• Produce deliverables within specified quality standards and timeline.
• Define and performing quality assurance on business intelligence deliverables.
• Respond to ad-hoc information inquiries.
• Perform data analysis, data quality audits/reviews, statistical analysis and data mining.
• Escalate issues and risks, as appropriate.
• Work within a multi-vendor/staff environment.

Anticipated Interviews dates

• Interviews are estimated to start Dec 15th

Scoring Methodology:

Financial/Pricing: 10%

Resource Qualifications: 30%

Interview Process: 60%

ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB/PROJECT WHERE EXPERIENCE WAS ATTAINED.

EACH JOB/PROJECT MUST CONTAIN THE TERM OF THE JOB/PROJECT IN THE FORMAT MMM/YYYY to MMM/YYYY.