Intermediate BI Analyst (onsite)

Vantix Systems Inc.; Edmonton; On-site; CAD 65,000 - 90,000; Full time

Job summary

Vantix Systems Inc. is seeking a qualified business intelligence professional to deliver BI capabilities for internal and external stakeholders. You will work with data from education, apprenticeship, finance, and census datasets to create actionable insights.

Responsibilities include designing Power BI solutions, gathering requirements, and ensuring QA across BI deliverables. Collaboration with in-house and contract resources is essential to success.

Qualifications

• Experience in data analysis and business intelligence.
• Ability to translate technical language for non-technical customers.
• Experience creating dashboards and reports for policy, operations, and executives.

Responsibilities

• Deliver business intelligence capabilities to support stakeholders.
• Work with diverse datasets including education, finance, and census data.
• Develop Power BI solutions to transform complex data into actionable insights.
• Gather and document requirements for BI products and controls.
• Design and construct information products and metadata.
• Ensure QA on BI deliverables and meet timelines.
• Respond to ad-hoc information inquiries and perform data quality checks.
• Collaborate in a multi-vendor/staff environment.

Skills

Data analysis

Requirements gathering

Stakeholder communication

Problem solving

Tools

Power BI

SAP

Job description

Description:

• 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) education, post-secondary education, apprenticeship, finance and census data.

• Work with a selection of technology products (such as SAP, Power BI) 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
  

• Experience with articulating and translating technical language for non-technical customers both verbally and in writing.

• Experience with presenting data in queries, dashboards, and reports in a way that is easy to understand.

• 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

• Experience planning, conducting, and analyzing findings from, creating representations of, and reporting on co-design workshops with service users.