Cost Control Data Analyst

Trillium Rail Partners; Mississauga; On-site; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Employer Matching Retirement Program

Life insurance

Job summary

A leading infrastructure development firm in Mississauga is seeking a Cost Control Data Analyst to enhance financial forecasting and project performance. You will transform project cost data into actionable insights, ensuring data consistency and developing automated reporting tools. The ideal candidate has a bachelor's degree, at least 5 years of relevant experience, and advanced skills in Excel and SQL. The position offers benefits including medical, dental, and retirement programs.

Qualifications

• Minimum 5 years of experience in data analysis, project controls, or cost control within construction or infrastructure projects.
• Advanced proficiency in Excel; strong experience with SQL and data manipulation.
• Understanding of cost control principles, budgeting, and forecasting in project environments.

Responsibilities

• Cost forecasting through data-driven models and predictive insights.
• Develop and maintain automated cost reporting tools and dashboards.
• Integrate and reconcile data from multiple sources to ensure consistency.

Skills

Data analysis

Cost control

Excel

SQL

Data visualization (Power BI, Tableau)

Analytical skills

Education

Bachelor’s degree in engineering, Data Analytics, Finance, Economics or related field

Job description

The Eglinton Crosstown West Extension will bring the Eglinton Crosstown LRT another 9.2 kilometers farther west, creating a continuous rapid transit line from the east end of Toronto into Mississauga. The Stations, Rail, and Systems (SRS) package encompasses the design, construction, integration, and commissioning of key project components.

Position Overview

The Cost Control Data Analyst plays a key role within the Commercial department by transforming project cost data into actionable insights. This role focuses on data integration, analysis, and visualization to enhance cost forecasting accuracy, monitor financial performance, and support strategic decision-making.

Working cross-functionally with Finance, Procurement, Project Controls, and Construction Management, the analyst ensures data consistency across systems and develops scalable reporting solutions to improve cost visibility and project outcomes.

Key Responsibilities

• Cost forecasting through data-driven models, scenario analysis, and predictive insights.
• Design and optimize data structures aligned with the Cost Breakdown Structure (CBS) to improve reporting efficiency and traceability.
• Develop and maintain automated cost reporting tools, dashboards, and data models to support project performance tracking.
• Ensure data quality, governance, and standardization across project control systems.
• Analyze cost data (actuals, commitments, forecasts) to identify trends, variances, and financial risks.
• Integrate and reconcile data from multiple sources (ERP systems, procurement tools, scheduling platforms) to ensure consistency and reliability.
• Collaborate with project teams to translate business requirements into analytical solutions and reporting outputs.
• Monitor key performance indicators (KPIs), including earned value metrics, and provide insights on project performance.
• Support change management analysis by quantifying cost impacts using historical data and trend analysis.
• Track and allocate project expenses, ensuring proper cost code assignment and alignment with budgeted work items.

Qualifications

• Minimum 5 years of experience in data analysis, project controls, or cost control within construction or infrastructure projects.
• Bachelor’s degree in engineering, Data Analytics, Finance, Economics, or related field.
• Advanced proficiency in Excel; strong experience with SQL and data manipulation.
• Experience with data visualization tools (e.g., Power BI, Tableau).
• Understanding of cost control principles, budgeting, and forecasting in project environments.
• Familiarity with earned value management (EVM) and project scheduling concepts (CPM).
• Strong analytical and problem-solving skills with the ability to interpret complex datasets.

What TRP Can Offer You

• Medical, dental, and vision insurance
• Employer Matching Retirement Program
• Life insurance

At TRP, we are committed to providing an environment of mutual respect where equal opportunities are available to all applicants and teammates. Accommodation is available upon request for applicants throughout the recruitment and selection process.

We thank all applicants for their interest. However, only those selected for an interview will be contacted.