City Of London, England
Job Summary
Role :
Perform cross-system lookups to align unique identifiers across various datasets
Assist in defining "parent-child" relationships between assets to build a logical network model.
Identify gaps or inconsistencies in existing data extracts—such as missing coordinates or naming mismatches—and work with stakeholders to resolve them.
Create and maintain a master mapping sheet that links engineering metadata with operational data points.
Documentation of methods adopted for items as above.
Skillsets :
5–8 years of experience working in an industrial or utility-based environment
Advanced Excel skills are essential (XLOOKUP, Power Query). Proficiency in VBA/Macros and SQL for data joining and cleansing is highly preferred.
Key Responsibilities
Role :
Perform cross-system lookups to align unique identifiers across various datasets
Assist in defining "parent-child" relationships between assets to build a logical network model.
Identify gaps or inconsistencies in existing data extracts—such as missing coordinates or naming mismatches—and work with stakeholders to resolve them.
Create and maintain a master mapping sheet that links engineering metadata with operational data points.
Documentation of methods adopted for items as above.
Skillsets :
5–8 years of experience working in an industrial or utility-based environment
Advanced Excel skills are essential (XLOOKUP, Power Query). Proficiency in VBA/Macros and SQL for data joining and cleansing is highly preferred.
Skill Requirements
Role :
Perform cross-system lookups to align unique identifiers across various datasets
Assist in defining "parent-child" relationships between assets to build a logical network model.
Identify gaps or inconsistencies in existing data extracts—such as missing coordinates or naming mismatches—and work with stakeholders to resolve them.
Create and maintain a master mapping sheet that links engineering metadata with operational data points.
Documentation of methods adopted for items as above.
Skillsets :
5–8 years of experience working in an industrial or utility-based environment
Advanced Excel skills are essential (XLOOKUP, Power Query). Proficiency in VBA/Macros and SQL for data joining and cleansing is highly preferred.
Other Requirements
Role :
Perform cross-system lookups to align unique identifiers across various datasets
Assist in defining "parent-child" relationships between assets to build a logical network model.
Identify gaps or inconsistencies in existing data extracts—such as missing coordinates or naming mismatches—and work with stakeholders to resolve them.
Create and maintain a master mapping sheet that links engineering metadata with operational data points.
Documentation of methods adopted for items as above.
Skillsets :
5–8 years of experience working in an industrial or utility-based environment
Advanced Excel skills are essential (XLOOKUP, Power Query). Proficiency in VBA/Macros and SQL for data joining and cleansing is highly preferred.
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-
