Project Controls

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

Under the direction of the Director, Research & Development, the Project Controls Analyst will: Data and Reporting

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. Maintaining and check contact information for all R&D supplier program managers, contract officers, lead authors, and/or their managers. Provide regular reports to R&D Director, Program Managers, Members, and Business Services, as well as external reports to Suppliers and Members. Ensure all published performance figures reconcile to the system of record; dashboards consume the values the source system calculates rather than re-implementing earned value formulas. Maintain current written procedures for the R&D project control and reporting processes, sufficient for another person to run a full cycle. Project Control

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. Interfaces with the Suppliers, Technical Committee Members, and various Conexus Departments (e.g. Business Services) by providing status reports on budgets, deliverables, schedules, and funding shares. Maintain real-time record of all current approved work package budgets and cross reference with the business service department and website records. Maintain monthly Financial Holdback reports for Program Manager’s review and approval, and forward these reports and data to the