Data Analyst - Power BI, ETL & Azure (Edmonton)

Alberta; Edmonton; On-site; CAD 70,000 - 95,000; Full time

Benefits offered by this job

Employee ownership opportunities

Annual discretionary performance bonus

RRSP, TFSA, Pension Contribution

Flexible medical, dental and vision

Life, AD&D and disability insurance

Job summary

PCL Constructors Inc. in Edmonton, Alberta seeks a Data Analyst to support CraftStream with data, analytics and continuous improvement. You will develop Power BI reports, maintain ETL processes, troubleshoot data quality, and deliver reliable data to support business decisions.

You will work closely with stakeholders, use SQL, Boomi, Azure Synapse, Fabric and Azure DevOps to implement effective technical solutions and drive improvements across data systems.

Qualifications

• Postsecondary degree or diploma in computer technology or a related discipline.
• 3+ years of progressive experience in a related field.
• Ability to think logically and analytically, and constructively express ideas and concepts.
• Intermediate to advanced experience with:
• Analytic tools and technology (Power BI)
• Data storage technologies (Fabric, OneLake, Data Lake, SQL)
• Data movement and transformation technologies (Boomi, Data Bricks, Data Factory, etc.)
• Azure DevOps Boards and Pipelines
• Scripting languages (SQL or Python)
• Effective communication and collaboration skills, with the ability to build stakeholder relationships and communicate complex concepts clearly.

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Develop and maintain ETL processes using Boomi, Azure Synapse, and Power BI.
• Creates, maintains, and enhances analytics, data integrations, and data repository solutions.
• Investigates, troubleshoots and resolves bugs, particularly related to data quality between systems.
• Build and maintain dashboards, reports, and data visualizations that support business decision-making.
• Use SQL to manipulate, transform, and analyze data.
• Translate business requirements and architectural designs into effective technical solutions.
• Conduct iterative testing with clients and stakeholders to ensure solutions meet business needs.
• Research and recommend new data and analytics technologies, enhancements, and best practices.
• Create and maintain technical documentation and track development progress in Azure DevOps.

Skills

Analytical thinking

Data visualization

Communication

SQL

Python

Azure DevOps

Education

Postsecondary degree or diploma in computer technology

Tools

Power BI

Fabric

OneLake

Data Lake

Boomi

Databricks

Data Factory

SQL

Python

Azure DevOps

Job description

PCL Constructors Inc. in Edmonton, Alberta seeks a Data Analyst to support CraftStream with data, analytics and continuous improvement. You will develop Power BI reports, maintain ETL processes, troubleshoot data quality, and deliver reliable data to support business decisions.

You will work closely with stakeholders, use SQL, Boomi, Azure Synapse, Fabric and Azure DevOps to implement effective technical solutions and drive improvements across data systems.