Graduate Project Engineer in Dundee

The Graduate Project Engineer supports the Design Delivery Manager in making informed, data-driven decisions across the Design and Engineering (D&E) delivery of the Emmock 400 kV Substation project under the ASTI Scheme. The role centres on three core areas: Engineering Programme management and reporting, Commercial reporting and analysis, and Procurement Support gathering data for Technical Bid Evaluation. By collecting, analysing and visualising project data, the Graduate Project Engineer enables the Design Delivery Manager to monitor progress against milestones, identify risks early, manage resources effectively, and maintain clear communication with internal and external stakeholders. The role bridges the gap between raw project data and the actionable insights needed for timely delivery decisions.

Responsibilities & Duties

• Data Analysis and D&E Programme Updates: Maintain and enhance the D&E Management Report by extracting and analysing data from the Project Deliverables Tracker, design registers and scheduling tools. Produce weekly and monthly programme dashboards (Power BI / Excel) that give the Design Delivery Manager real-time visibility of deliverable status, slippage trends and critical-path items. Monitor incoming deliverables, internal review cycles and submission milestones; flag deviations and forecast completion dates using trend analysis. Support the development and updating of the D&E Programme, including dependency mapping and resource-loading analysis. Perform variance analysis between planned and actual progress, identifying root causes and recommending corrective actions.
• Commercial Reporting & Analysis: Assist the Design Delivery Manager with commercial performance tracking, including cost-to-complete forecasts, budget variance analysis and earned-value metrics. Consolidate data from multiple commercial sources into clear, consistent reports that support monthly commercial reviews. Maintain registers for Early Warnings (EWNs), Compensation Events (CEs) and Project Manager Instructions (PMIs), analysing trends and financial exposure. Develop automated reporting templates and dashboards (Excel / Power BI) to reduce manual effort and improve data accuracy.
• Procurement Support & Technical Bid Evaluation: Support the Design Delivery Manager in the procurement process by compiling and structuring technical evaluation criteria for equipment and subcontract packages. Gather, organise and compare technical and commercial data from bid submissions to facilitate objective supplier evaluation. Prepare bid comparison matrices, scoring summaries and recommendation reports for review by the Design Delivery Manager and project stakeholders. Track procurement milestones and lead times, highlighting schedule risks to the engineering programme. Maintain a procurement tracker linking package status to the overall D&E Programme.
• Interface & Communication: Act as an analytical link between Design Engineers, commercial teams and the Design Delivery Manager, translating data into clear narratives. Support stakeholder communication by preparing data packs, briefing notes and visual summaries for internal and external audiences. Assist in ensuring design intent and programme status are communicated clearly to construction and project management teams.
• Risk & Safety Support: Support the Design Delivery Manager in identifying and documenting design risks through data-driven risk analysis.
• Continuous Improvement: Identify opportunities to automate repetitive data collection and reporting processes through scripting (Python) or tool configuration. Promote the adoption of data-driven practices across the D&E team. Support lessons learned collection, analysis and dissemination to improve future project delivery.

Key interfaces: Design Delivery Manager (primary reporting line), Design Teams, Commercial and Procurement Teams, Project Managers and Planning Team.

Person Specification

Qualifications and Experience: The jobholder shall hold a Master’s degree in Data Science, Data Analytics, Engineering, Finance or a related quantitative discipline. A combination of analytical skills and business awareness is essential. Strong academic background in data analysis, statistics or quantitative methods. Demonstrable interest in applying data science to real-world decision-making in engineering or project environments. International experience or exposure to multidisciplinary working environments is desirable. Experience in finance, commercial analysis or project controls is an advantage. Excellent team ethic and ability to work on own initiative. Ability to communicate complex analytical findings to non-technical audiences at all levels. Ability to work accurately and methodically under pressure and strict deadlines, managing multiple tasks effectively.

Essential: Mandatory Omexom training courses.

Desirable: Professional certification in data analytics.

Competencies:

• Data Analysis & Visualisation: Proficiency in Power BI and Excel for creating interactive dashboards, KPI tracking and automated reports. Ability to explore datasets, identify patterns and translate findings into actionable insights.
• Programming & Automation: Working knowledge of Python (pandas, matplotlib, scripting) and R for data manipulation, statistical analysis and process automation. Familiarity with Shiny for building interactive data applications is desirable.
• Applied Analytics: Understanding of machine learning concepts and their practical application to forecasting, classification and anomaly detection in project data.
• Commercial Awareness: Ability to interpret financial and commercial data, including earned-value analysis, cost forecasting and budget variance reporting.
• Prompt Engineering: Skills in prompt engineering for Large Language Models (LLMs) to support document analysis, data extraction and report drafting.
• Detail-Oriented Mindset: Commitment to data accuracy, quality assurance and methodical working practices.
• Stakeholder Communication: Ability to present data clearly to diverse audiences, putting the customer at the centre of decision-making.

Values:

• Team Spirit & Generosity – able to work effectively within and contribute to the Omexom team to deliver results, provide support and drive performance.
• Trust and Empowerment – enjoy managing their responsibilities and time to ensure work is completed efficiently and professionally.
• Integrity and Responsibility – enjoy taking responsibility for their duties and managing these effectively to ensure efficient high quality results.
• Innovation & Entrepreneurship – continually strive to improve processes and introduce new initiatives to improve efficiency.