Infrastructure & Capital Projects – Data & Analytics Consultant, COM (12 Months Fixed Term Contract)
$95,000–$135,000 year
Hybrid · Toronto, Ontario, Canada
Job Summary
Infrastructure & Capital Projects – Data & Analytics Consultant will serve as the primary BI/data liaison between client business teams (Engineering, Construction, Procurement) and the technical data team, translating business needs into technical specifications, designing and delivering interactive Power BI dashboards, building robust Snowflake data models, validating data integrity, and coordinating with agile teams to ensure timely, accurate reporting for capital projects. Responsibilities include leading requirements workshops, creating KPI-aligned reporting, developing and validating data models, performing complex SQL transformations, overseeing CI/CD pipelines, and ensuring trusted data aligned with business rules for executive decision-making.
Required Qualifications
- Bachelor’s degree in Computer Science, Engineering, or a related field
- 5+ years of experience in Business Intelligence, Project Controls, Data Analytics, or Analytics Engineering
- Power BI mastery (DAX, data modeling, UI/UX for executive reporting)
- Strong SQL skills in Snowflake or similar
- Experience with data translation from disparate systems (CSV, Excel, JSON) into cohesive business stories (Star schema, dimensional modeling)
- Experience with Agile (JIRA, Git)
- PM certifications (CAPM, PMP)
- Knowledge of capital project controls, scheduling, or construction management
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.