Data Analyst improving PCL Construction’s CraftStream application for PCL Construction, a construction company. Developing Power BI dashboards, ETL processes, and reliable data integrations.
Responsibilities
Support CraftStream, an internally built application, with a focus on data, integrations, analytics, and continuous improvement
Develop and maintain Power BI reports and dashboards
Develop and maintain ETL processes using Boomi, Azure Synapse, and Power BI
Create, maintain, and enhance analytics, data integrations, and data repository solutions
Investigate, troubleshoot, and resolve bugs, particularly those 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
Work closely with business and technical stakeholders to ensure CraftStream and connected systems provide reliable, meaningful data
Requirements
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)
Intermediate to advanced experience with data storage technologies (Fabric, OneLake, Data Lake, SQL)
Intermediate to advanced experience with data movement and transformation technologies (Boomi, Data Bricks, Data Factory, etc.)
Intermediate to advanced experience with Azure DevOps Boards and Pipelines
Intermediate to advanced experience with scripting languages (SQL or Python)
Effective communication and collaboration skills, with the ability to build stakeholder relationships and communicate complex concepts clearly
Benefits
Employee ownership opportunities that build long-term value
Annual discretionary performance bonuses
RRSP, TFSA, Pension Contribution Options
Flexible medical, dental and vision benefits
Prescription drug coverage and virtual care services
Life, AD&D and disability insurance
Paid parental leave and family care support
Health and lifestyle spending account options
Mental health and wellness support, including Employee Assistance Programs
Career growth pathways, leadership development and mentorship programs
Access to world-class training through PCL's College of Construction and professional development courses
Ongoing opportunities to learn new skills, explore different roles and grow your career across sectors and regions
Senior Data Analyst owning supplier - data quality, source linking, and monitoring at Supplier.io. Building dashboards and insights for procurement, finance, and compliance teams.
Senior risk manager building credit and fraud models for Jobber's small - business fintech platform. Shaping risk strategy, loss prevention, and decision analytics across financial products.
Data analyst consulting on Fire and EMS data for Darkhorse Emergency’s custom analytics SaaS. Building analyses, visualizations, reports, and client solutions.
Senior BI analyst turning scientific and operational data into KPI insights for Sutherland Healthcare Solutions. Leading analytics, stakeholder requirements, SQL, visualization, and testing.
Senior Data Analyst transforming scientific and operational data into actionable healthcare insights at Sutherland. Developing KPI analytics, data solutions, and stakeholder - driven requirements for life - science services.
Automotive Data Analyst compiling, testing, and coding vehicle, pricing, and technical data. Supporting JD Power’s automotive analytics products with accurate manufacturer information.
Senior Data Analyst monitoring AI personalization models and building scalable diagnostics for Movable Ink’s marketing personalization platform. Developing GCP/BigQuery pipelines and Tableau reporting for global brands.
Marketing analytics analyst supporting B2B program reporting, dashboards, tracking QA, and data quality at Marketbridge. Remote role serving global brands across North America and Europe.
Marketing analytics analyst supporting Marketbridge’s B2B clients with data preparation, dashboards, and tracking QA. Turning marketing data into accurate reporting and measurement insights.