IT Analyst II

Alberta Health Services; Calgary; Hybrid; CAD 58,000 - 78,000; Full time

Job summary

Alberta Health Services is seeking an IT Analyst II to support information technology applications and enterprise analytics within the Corporate Data, Health Information Exchange team. You will translate business needs into technical requirements and lead project delivery to ensure reliable IT operations.

The role focuses on building analytics solutions using Microsoft Fabric, developing pipelines, and enabling enterprise reporting with Power BI.

Qualifications

• Completion of bachelor's degree in Computer Science or Information Technology or equivalent.
• Experience with Corporate Data: Workforce, Finance, CPSM.
• Hands-on experience developing analytics solutions using Microsoft Fabric or closely related Microsoft data platforms.
• Strong knowledge of data modeling concepts (e.g., dimensional modeling, star schemas, semantic models).
• Proficiency in SQL and Python for querying and transforming data.
• Experience with Power BI, including dataset development and performance optimization.
• Familiarity with data integration concepts, ELT/ETL patterns, and pipeline orchestration.
• Strong analytical and problem-solving skills.
• Ability to communicate technical concepts to non-technical audiences.

Responsibilities

• Provide technical IT analysis and support to users and service delivery functions.
• Develop and maintain analytics solutions using Microsoft Fabric components and Power BI.
• Build and optimize data pipelines for diverse data sources; implement ELT/ETL patterns.
• Troubleshoot data models and semantic layers to support enterprise reporting.
• Manage tickets and collaboration with vendors to resolve complex issues.

Skills

SQL

Python

Power BI

Data modeling

ETL/ELT

Education

Bachelor's degree in Computer Science or IT

Tools

Azure Data Factory

Azure Synapse

Azure SQL

ADLS

Spark

Job description

This is a 6 month temporary position until the end of March 2027. You will be working with the Corporate Analytics Team within HIE to support eLeader, a Microsoft Fabric analytic tool.Your tasks will include, build, and maintain analytics solutions using Microsoft Fabric components, including Lakehouse, Data Analytics, Data Factory, Data Warehouse, Real‑Time Analytics, and Power BI.Develop and optimize data pipelines for ingesting, transforming, and loading data from a variety of structured and semi‑structured sources.Implement ELT/ETL patterns using Fabric notebooks, pipelines, SQL, Python and Spark as appropriate.Troubleshoot and maintain curated data models and semantic layers to support enterprise reporting and analytics.Data Validation and troubleshooting to support business inquiries and tickets.Support of Service Now ticket queue as well as MS ADO ticket triage.

Description:

As an IT Analyst II, you will provide technical support related to information technology applications either directly to users of the systems or to service delivery functions. You will ensure reliable operations of information systems, resolve complex technical problems, find solutions to customer needs, and lead projects and program initiatives. You will be responsible for more advanced application, telecom or technology support duties. You will investigate, diagnose, and resolve complex problems that have typically been escalated several levels before assignment to this position, and will translate business requirements into technical requirements for a solution and recommend a potential approach to the vendor. You will analyse the solution provided to ensure that it fits both technical requirements and business needs. You will also spend time on project or initiative leadership and delivery.

• Transition Company: Health Shared Services
• Classification: IT Analyst II
• Union: AUPE GSS
• Unit and Program: Corporate Data, Health Information Exchange
• Primary Location: Quarry Crossing
• Location Details: Eligible to work hybrid (on/off site) within Alberta
• Multi-Site: Not Applicable
• FTE: 1.00
• Posting End Date: 01-OCT-2026
• Temporary Employee Class: Temporary Full Time
• Date Available: 11-OCT-2026
• Temporary End Date: 31-MAR-2027
• Length of Shift in weeks: 2
• Shifts per cycle: 10
• Shift Pattern: Days
• Days Off: Saturday/Sunday
• Minimum Salary: $42.12
• Maximum Salary: $56.86
• Vehicle Requirement: Not Applicable

• Transition Company: Health Shared Services
• Classification: IT Analyst II
• Union: AUPE GSS
• Unit and Program: Corporate Data, Health Information Exchange
• Primary Location: Quarry Crossing
• Location Details: Eligible to work hybrid (on/off site) within Alberta
• Multi-Site: Not Applicable
• FTE: 1.00
• Posting End Date: 01-OCT-2026
• Temporary Employee Class: Temporary Full Time
• Dates Available: 11-OCT-2026
• Temporary End Date: 31-MAR-2027
• Hours per Shift: 7.75
• Length of Shift in weeks: 2
• Shifts per cycle: 10
• Shift Pattern: Days
• Days Off: Saturday/Sunday
• Minimum Salary: $42.12
• Maximum Salary: $56.86
• Vehicle Requirement: Not Applicable

Required Qualifications:

Completion of bachelor's degree in Computer Science or Information Technology or equivalent.

Additional Required Qualifications:

Experience with Corporate Data: Workforce, Finance, CPSM.Hands‑on experience developing analytics solutions using Microsoft Fabric or closely related Microsoft data platforms.Strong knowledge of data modeling concepts (e.g., dimensional modeling, star schemas, semantic models).Proficiency in SQL and Python for querying and transforming data.Experience with Power BI, including dataset development and performance optimization.Familiarity with data integration concepts, ELT/ETL patterns, and pipeline orchestration.Strong analytical and problem‑solving skills.Ability to communicate technical concepts to non‑technical audiences.Well‑organized, detail‑oriented, and capable of managing multiple priorities.Collaborative mindset with a focus on continuous improvement and learning.

Preferred Qualifications:

Experience with Azure data services (e.g., Azure Data Factory, Azure Synapse, Azure SQL, ADLS).Familiarity with Spark, Python, or notebooks for data transformation and analysis.Experience supporting self‑service analytics and data democratization initiatives.Knowledge of DevOps or CI/CD practices for analytics solutions.Microsoft certifications related to data, analytics, or Power BI.

Please note:

All postings close at 23:59 MT of the postingend date indicated.

Security Screening:

A satisfactory criminal record check and/or Vulnerable Sector Search is required prior to your first day of work. Additionally, all employees have an ongoing duty to disclose any charges or convictions that may occur during their employment with AHS.

Healthy Albertans. Healthy
Communities. Together.

We’re passionate about what we do. Our team of skilled and dedicated health care professionals, support staff, and physicians promote wellness and provide health care all across Alberta.

Everything we do at AHS reflects a patient and family centred approach; it’s about putting patients’ and families’ experiences, priorities and trust first.

We are an equal opportunity employer. AHS values the diversity of the people and communities we serve and is committed to attracting, engaging and developing a diverse and inclusive workforce.

Create and manage profiles for future opportunities.