Analytics Analyst building Power BI dashboards and data models for PCL Industrial Management, a construction company. Translating business needs into streamlined analytical solutions.
Responsibilities
Build and enhance Power BI dashboards, ensuring data accuracy, intuitive design, and performance optimization.
Create and maintain efficient data models within Power BI using Power Query and DAX for data transformations and calculations.
Maintain ERD models for reference outside of Power BI.
Work with line-of-business and project teams to gather requirements and translate business questions into actionable analytical solutions.
Partner with IT and data professionals to design technical backends and innovate on current practices.
Identify opportunities to simplify, streamline, and automate reporting.
Serve as the in-house Power BI expert by providing training sessions, documentation, and best practices to end users.
Stay current on Power BI updates, features, and industry trends to recommend and implement innovative solutions.
Write, review, and debug code supporting current or new development projects.
Participate in or lead estimation, design, and planning activities.
Requirements
Bachelor’s degree in business, Computer Science, Data Analytics, or a related field (or equivalent experience).
Proficiency in Power BI, including DAX, Power Query, and data modeling.
Comfortable with SQL and experience working with relational and nonrelational data stores.
Exposure to ETL processes, databases, and data governance practices.
Visual design and selection of most appropriate visualization techniques.
Exposure to a modern agile development workflow is an asset.
A track record of creating impactful dashboards and analytics solutions.
Business analysis: Experience working with cross-functional teams to translate business goals into analytical tasks.
Experience in construction or AEC fields is a benefit, but not necessary.
Strong communication and presentation abilities.
Strong problem-solving skills and analytical thinking.
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.