Project Controls & Data Analyst in Toronto

The Project Controls & Data Analyst is responsible for providing integrated R&D project control, database management, reporting and analytical support to ensure projects are effectively monitored, documented and delivered. The role supports data integrity, performance tracking, process improvements and timely reporting to management and stakeholders. By leveraging advanced SQL proficiency and integrating AI-driven tools for automation and analysis, the incumbent will transform raw project data into actionable intelligence, enabling precise forecasting, risk mitigation, and data-informed decision-making for R&D.

Key Accountabilities

• Project Controls and Performance Management: Apply earned value management (CPI/SPI/BPI, EV/PV/AC, variance and estimate at completion), through the monthly cost and schedule reporting cycle and other analysis as required.
• Program Reporting and Analysis: Produce the recurring R&D reporting suite, monthly cost and schedule status, financial holdback, quarterly technical progress, metrics for R&D leadership, Program Managers, Technical Committee members, suppliers, members and Business Services.
• Self-Service Reporting and Analysis: Build and maintain the R&D reporting suite with Power BI and Grafana dashboards and ad-hoc analysis across budgets, commitments, deliverables and performance; working directly against approved read-only data sources, without depending on IT for routine report production. Ensure published figures reconcile to the system of record. Generate reports and data extracts to support business and project requirements. Identify opportunities to improve data management processes and reporting efficiency. Support adhoc analysis and reporting requests as required.
• Supplier and Stakeholder Coordination: Act as the day-to-day point of contact for supplier project managers, contract officers, lead authors and/or their managers, maintaining accurate contact and relationship records, driving on-time submission of cost reports, technical progress reports and deliverables, and challenging reported performance where it does not stand up to scrutiny.
• Database Administration and Maintenance: Manage the integrity, accessibility, and routine maintenance of R&D databases, including data imports/exports, backup/recovery strategies, and alignment with authorized Conexus procedures. Perform data validation, reconciliation, and quality checks to identify and resolve discrepancies.
• Strategic Data Integration and Automation: Leverage advanced SQL proficiency and AI-driven tools to automate administrative tasks, integrate corporate databases with Conexus Online systems (e.g., SharePoint, COMS), and transform raw project data into actionable intelligence for leadership decision-making.

General Responsibilities

• Perform data extraction, transformation and report production across R&D data sources. Use advanced SQL to interrogate and reconcile R&D data across systems, and to build and maintain the department's own Power BI and Grafana dashboards against approved read-only data sources.
• Align and maintain the R&D database with authorized Conexus procedures and processes.
• Coordinate, administer data processing for R&D deliverables and budget tracking.
• Act as SPOC for the R&D project control processes within COMS; cost and schedule reporting, work package budgets, change control and purchase orders: maintain reference data and configuration, specify changes to IT, and test and sign off releases.
• Maintain current written procedures for the R&D project control and reporting processes, sufficient for another person to run a full cycle.
• Collect, analyze, and maintain monthly cost and schedule status reports (CSSR) from suppliers transfer data into the database, and generate performance statistics as required for periodic and/or monthly reporting cycle.
• Maintain real-time record of all current approved work package budgets and cross reference with the business service department and website records.
• Adjust all records to incorporate approved CCRs (Change Control Request) and web applications (BMS, COMS, SharePoint).
• Exercise judgment on earned value where progress is not directly measurable, including assessing percent complete from technical progress reports for universities and smaller suppliers who do not self-report performance indices.
• Set up the reporting cycle at the start of each fiscal year in COMS.
• Assist the Director/Program Managers in setting up, maintaining quarterly data reports for use in Annual Reports, Quarterly Technical Progress Reports, and create necessary graphics and metrics.
• Prepare monthly analysis/report on project management performance measures (CPI/SPI) and provide input to the Balance Score card metrics every quarter.

Requirements

• Diploma or Degree in database Management, Data Analytics, Computer science or related area.
• 5+ years in project controls, cost control or financial analysis, ideally on multi-supplier R&D, engineering or capital programs; or an equivalent blend of finance and project delivery experience.
• Demonstrable earned value management experience: CPI/SPI, planned and earned value, variance analysis, estimate at completion.
• Advanced Microsoft Excel, including handling large supplier workbooks.
• Proficient with Microsoft Office software including Word, Outlook and PowerPoint.
• Confident in Power BI and/or Grafana, including connecting directly to a SQL data source, designing the query behind a panel, and maintaining a dashboard suite over time.
• Comfortable using AI assistants to accelerate query writing, reconciliation and drafting with the judgment to verify every figure before it reaches a financial report.
• Advanced SQL: a core working tool of this role.
• Experience working within an established business system (ERP, project control or finance platform) as a business owner or power user.
• Good organization, communication, and interpersonal skills.
• Good time management and organizational skills to handle multiple tasks of varying priorities at any given time.
• Ability to work in a team environment.
• Self-starter able to work with minimal supervision.
• Strong numeracy and financial rigour; comfortable owning figures that leadership and members will act on.
• Meticulous attention to detail where money is concerned.

Success Indicators/KPI’s

• Accurate and Timely Project Controls: Monthly cost, schedule, budget, commitment, deliverable and supplier performance data is maintained accurately and completed within established reporting timelines.
• Reliable Management Reporting & Data Integrity: R&D reporting is delivered accurately and on schedule, with published figures reconciling to the system of record.
• Effective Self-Service Reporting & Analytics: Power BI/Grafana dashboards and SQL-based analysis provide reliable, accessible insight into budgets, commitments, deliverables and performance.
• Supplier & Stakeholder Accountability: Supplier reports and deliverables are received accurately and on time, discrepancies are identified and challenged appropriately.
• Continuous Improvement & Automation: Reporting and project-control processes are continuously improved through SQL, automation and approved AI tools.

This role is based at the Conexus office in Toronto with the opportunity to work remotely 1-3 days per week. Onsite presence is expected around the monthly reporting close and the quarterly and annual reporting cycles, when workload peaks.

Conexus employees are expected to consistently demonstrate our core values of Integrity, Collaboration, Innovation, Sustainability and Agility.

At Conexus, we recognize that supporting our valued employees' wellbeing extends beyond compensation. We offer a total rewards program that includes a pension plan, an annual health spending account, a fitness subsidy as well as life, health, dental and disability benefits, complemented by a truly flexible, hybrid work arrangement.

Conexus has earned recognition as a diversity leader in the nuclear industry, particularly for our work advancing women in engineering. We are committed to employment equity and diversity in the workplace, and we welcome applications from women, members of racialized groups/visible minorities, Indigenous persons, persons with disabilities, persons of any sexual orientation, and persons of any gender identity or gender expression.