Job Title: Data Engineer, Project Controls Analytics
Location: Tiverton, ON (Hybrid)
Estimated Duration: 6 Months
Role Summary
The Data Engineer will support the design and implementation of an enterprise-wide Benchmarking, Estimating, and Performance Analytics Framework across Client's projects. This role will focus on building and improving the unified data architecture, integrating multiple project controls and execution systems, enabling semantic data models, and supporting Power BI reporting and KPI automation.
Key Responsibilities
- Integrate and validate data from EcoSys, Primavera P6, Maximo, timekeeping systems, Cleopatra, ARM, Skytrax, PMIS/Power Apps, and field execution sources.
- Assess current-state data warehouse interfaces and identify mapping gaps, structural misalignments, and data quality issues.
- Design and implement semantic data models that connect cost, schedule, and execution actuals for drill-down analysis to WBS, component, and activity level.
- Support KPI definition, data lineage, business rule implementation, and automated monitoring logic.
- Build and enhance Power BI dashboards across cost, forecasting, schedule, construction execution, risk, and vendor performance.
- Support development of data quality remediation plans and integration specifications.
- Partner with project controls, PMO, estimating, and business stakeholders to ensure reliable and scalable reporting outputs.
- Help establish sustainable data structures and governance to support repeatable analytics and future benchmarking.
Must-Have Qualifications
- Experience defining and implementing KPIs for capital projects.
- Semantic layer design and implementation experience.
- Power BI and reporting analytics expertise.
- Strong experience integrating multiple data streams into a data warehouse or data lake.
- Experience with Microsoft analytics stack.
Nice-to-Have Qualifications
- Exposure to Primavera P6, EcoSys, and Maximo.
- Experience in industrial or asset-intensive environments.
- Utilities, power generation, or construction background.
- Experience capturing and onboarding new data streams.
The pay range that the employer reasonably expects to pay for this position is between CA$60.00 and CA$90.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
This posting is for an existing vacancy.If you believe this post to be fraudulent, please report by clicking here Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!