Connecting Odds
HCLTech

Senior Technical Lead

HCLTech
City Of London, United KingdomPosted about 1 month agoDiscoveredMatch locked
Full-time5+ years exp

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.

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.

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.

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.

Not included in the source posting: about the role, what you'll do, benefits.

Skills

excelsql

Who can apply

The employer didn't state any visa, work authorization, citizenship or clearance requirements in this posting. Confirm with the employer before applying.

Read automatically from the employer's posting text. Always confirm with the employer — requirements can change after a job is published.