Senior Data Analyst, Management Data Analysis

Company: NATIONAL GRID CO USA (NE POWER)
Location: Hicksville
Posted on: January 16, 2023

Job Description:

About us
National Grid is one of the largest investor-owned energy companies in the world - covering Massachusetts, New York, Rhode Island and the UK. We are at the heart of one of the greatest challenges facing our society, delivering clean energy to support our world long into the future. Every day we work with stakeholders to promote the development and implementation of sustainable, innovative and affordable energy solutions.

Job Purpose
National Grid is hiring a Technology Business Manager working within the National Grid Information Technology organization, located within the United States.
Every day we deliver safe and secure energy to homes, communities, and businesses. We are there when people need us the most. We connect people to the energy they need for the lives they live. The pace of change in society and our industry is accelerating and our expertise and track record puts us in an unparalleled position to shape the sustainable future of our industry.
To be successful we must anticipate the needs of our customers, reducing the cost of energy delivery today and pioneering the flexible energy systems of tomorrow. This requires us to deliver on our promises and always look for new opportunities to grow, both ourselves and our business.

Key Accountabilities
We are seeking a dynamic and energetic Technology Business Management Analyst with strong technical and analytical skills; to help us drive the next phases of our cost transparency roadmap and maturity. This role will report to the Technology Business Management Platform Manager.
Technology Business Management helps to optimize business performance through the provision of highly accurate and actionable cost transparency insights across National Grid's complex IT cost base. Our goal is to collaborate with key stakeholders on the Total Cost of Ownership (TCO) across our IT Applications and IT Services.
We are in the early phases of redeveloping our Apptio Cost Transparency Platform; to better inform how costs should be allocated to our regulated and non-regulated businesses (across the United States). Our goal is to develop a consumption driven cost allocation model that more accurately reflects the true consumption of IT resources to enable our businesses and IT organization to better understand, control and optimize their costs.

JOB OVERVIEW
The successful candidate will be responsible for globally owning or supporting the following key duties:

Perform BAU tasks for Apptio, including:
o Loading, validating, and reviewing data on timely basis
o Analyze and create dropout cost reports
o Resolve dropout through stakeholders or configuration updates needed in Apptio
o Categorization of vendor invoice line items/products
o Management of TBM office mailbox (access requests, stakeholder questions, etc.)
o Update any SOPs, data dictionaries, or model documentation as changes are made

--- Find opportunities for process improvements
--- Map and transform large sets of data
--- Develop an understanding of our TCO model and data sources from bottom to top
--- "Reverse engineer" the allocations and data relationship tables to determine data flows and/or solve issues
--- Provide adhoc cost reporting & analysis for our stakeholders
--- Stay current with Apptio's new functionalities
--- Identify improvements needed in data quality and work with the data owners to implement governance

Develop our TCO model to meet roadmap requirements:
o Creating & developing new allocation rules and objects
o Updating & creating new formulas and tables
o Building new reports for users

Qualifications
--- Ability to work in a team environment
--- Process oriented, logical problem solver
--- Excellent skills in MS Excel (If statements, vlookup, pivot tables, etc)
--- Bachelor's Degree, related to computer information systems, or equivalent experience
--- Basic financial understanding including budgeting, variance analysis, and financial statements
--- RTBMA Certified
Desirable
--- Basic programming knowledge
--- Power BI knowledge preferred
--- Apptio experience (migration, configuration, coding, reporting) is a plus
--- Technology Business Management Analyst Certification

Keywords: NATIONAL GRID CO USA (NE POWER), Hicksville , Senior Data Analyst, Management Data Analysis, Executive , Hicksville, New York