data analyst in energy and materials

Wood is a global leader in consulting, engineering, and operations for the energy and materials sectors. It supports clients across the full asset lifecycle, delivering safe, predictable outcomes while enabling resilient operations and a lower carbon future.

• Maintain traceability and consistency between project documents, databases, and cutover tracking tools;
• Perform cross-checks and reconciliation across engineering lists, schedules, registers, databases, turnover packages, and cutover tracking databases;
• Identify missing, duplicate, inconsistent, conflicting, and orphaned records;
• Establish and maintain a single source of truth for project data;
• Develop and execute automated validation processes for tag consistency across project documentation;
• Validate equipment, cable, feeder, source, and destination relationships;
• Verify MCC feeder assignments and load mappings;
• Ensure consistency between engineering databases and project deliverables;
• Generate exception reports highlighting discrepancies requiring engineering review;
• Support data readiness assessments for cutover execution;
• Develop and maintain advanced Excel-based tools for data validation, reconciliation, reporting, and cutover readiness;
• Develop Power Query solutions for automated data extraction, transformation, and consolidation;
• Build Power Pivot models for analyzing relationships between engineering datasets;
• Develop VBA-based validation tools and automated reconciliation reports;
• Develop dashboards showing data quality, cutover readiness, and project progress;
• Create validation tools and configurable templates for engineering data self-validation;
• Develop automated tools for processing and validating large drawing packages and associated datasets;
• Compare drawing tags and revisions against master databases and identify changes affecting construction, commissioning, and cutover activities;
• Validate document cross-references and linked datasets;
• Generate discrepancy reports and engineering punch lists;
• Perform automated consistency checks across engineering deliverables;
• Develop dashboards and project performance metrics;
• Monitor and report data quality KPIs;
• Prepare management reports and exception summaries;
• Support cutover readiness reviews with data-driven reporting;
• Maintain visibility of outstanding data discrepancies and corrective actions;
• Identify opportunities to eliminate manual data validation activities;
• Develop reusable tools and templates across project workstreams;
• Standardize data validation methodologies and reporting practices;
• Improve the efficiency and accuracy of project data management processes;
• Support digitalization and automation initiatives within the Project Team.

• KZ passport holder;
• Extensive experience in the oil and gas petrochemical industry;
• Knowledge of electrical engineering documentation and equipment tagging systems;
• Familiarity with Load Lists, MCC Load Lists, Cable Schedules, Cable Splicing Schedules, and Turnover Packages;
• Experience supporting commissioning, system completion, cutover, or execution-readiness activities;
• Experience with XLOOKUP, INDEX/MATCH, FILTER, UNIQUE, LET, LAMBDA, Dynamic Arrays, Pivot Tables, Data Models, Power Query, Power Pivot, VBA, Power BI, Power Automate, SQL, SharePoint, and dashboard development;
• Ability to work with large engineering datasets, manage relationships between registers, and maintain traceability across source documents;
• Structured and detail-oriented, with the ability to work independently;
• Ability to convert repeated manual checks into reusable tools and templates.

• Office-based role in Atyrau, Kazakhstan.