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.