BI Analyst - Intermediate

Vantix Systems Inc.; Edmonton; On-site; CAD 80,000 - 120,000; Full time

Job summary

Vantix Systems Inc. is seeking a BI Analyst to design, develop, and optimize Power BI solutions that transform large datasets into compelling visual narratives for Alberta's public services.

You will analyze trends, build data models with DAX, and present insights to executives, while ensuring data quality and alignment with the organization's analytics strategy. This role requires a Bachelor’s degree and strong SQL and Azure analytics skills, with the ability to translate complex findings for

Qualifications

• Bachelor's degree or equivalent in CS/Data Analytics/related field
• Experience with Power BI, data modeling, and DAX
• Experience with large, complex datasets and predictive analytics
• Excellent communication to translate findings for non-technical audiences

Responsibilities

• Design, develop, and refine Power BI dashboards, reports, and KPIs
• Analyze large datasets to identify trends, forecast patterns, and support predictive analytics
• Collaborate with teams to gather and understand business requirements
• Develop data models, measures, and calculated columns using DAX
• Present insights to executives and business users clearly
• Perform data quality reviews, data mining, and statistical analysis
• Support development of data products and services aligned with data strategy

Skills

Analytical skills

Clear communication

Team collaboration

Problem solving

Data storytelling

Education

Bachelor's degree in Computer Science / Data Analytics or related field

Tools

Power BI

SQL

Azure analytics tools

Job description

Our Client is seeking aBI Analystto drive strategic decisions by designing, developing, and optimizing advanced Power BI solutions that turn large, intricate datasets into compelling visual stories. Your work will support making data-driven choices that benefit citizens across Alberta.

Bring your data expertise to a role where your insights will directly influence strategic decisions and public service improvements.

Responsibilities

• Design, develop, and refine Power BI dashboards, reports, and KPIs for diverse stakeholders.
• Analyze large datasets to identify trends, forecast future patterns, and support predictive analytics.
• Collaborate with teams to gather and understand business requirements for analytical projects.
• Develop and implement complex data models, measures, and calculated columns using DAX.
• Present insights to executives and business users clearly and effectively.
• Perform data quality reviews, data mining, and statistical analysis to ensure accuracy and integrity.
• Support the development of data products and services aligned with the organization’s data strategy.

Qualifications

• Bachelor’s degree in Computer Science, Data Analytics, or a related field; equivalent experience considered.
• Proven hands-on experience with Power BI, including visualization techniques, data modeling, and DAX.
• Strong analytical skills with experience working on large and complex datasets.
• Experience in trend analysis, forecasting, and predictive analytics using Power BI and Azure analytics tools.
• Excellent communication skills, capable of translating technical findings for non-technical audiences.
• Experience in SQL for data transformations and querying large-scale environments is a plus.
• Knowledge of government data sets or working in a regulated environment is advantageous.

We believe diverse teams build stronger companies, and we welcome applicants from all backgrounds, experiences, and perspectives.

To be considered, applicants must be legally entitled to work in Canada, including holding any required permits.

Accommodation is available upon request throughout all stages of the recruitment process.