Lead Analyst, Finance Services

About us

Job Purpose

National Grid bills over 6 million accounts per month in its customer billing system, CSS (Customer/1). The Billing Operations Department monitors and updates the customer billing system; ensuring bill accuracy and implementing new billing programs. National Grid is seeking a Lead Analyst to support, analyze, and report on the existing billing programs, as well as design, test, and implement new billing system enhancements. Position requires existing knowledge of National Grid’s billing system (CSS, Customer/1), the underlaying data model, and ability to write SQL to query and update the database.

Key Accountabilities

• .
Analyze technical issues with accounts in the customer billing system. Identify root cause and create a ticket to engage IT with detailed analysis and recommended fix. Create queries (DB2/SQL) to find all impacted accounts and identify short-term fix or data repairs until underlying code issue is fixed
• .
Create adhoc queries on the billing system database (DB2/SQL) to order to extract reporting data, analyze data, or update/insert data record
• s
Perform bill verifications to ensure the accuracy of the generated bills. Report and analyze any deviations
• .
Write requirement documents for billing system enhancements, based on interviews with the end users and regulatory staff to understand the business needs
• .
Create test plans for billing system enhancements. Execute the test plan, documenting the test results. Document and prioritize any defects. Track and report on progress of testing
• .
Create an implementation plan to deploy new IT solutions by identifying impacted business units, creating process flows, and identifying required training. Monitor the implementation and escalate any issues
• .
Create procedure documents on newly developed programs for the billing system
• .
Challenge existing ways of working and continuously seek ways to do things better
• .

Qualifications

Knowledge & Experience Requirements:

• .
Experience and proficiency in writing SQL
Proficient in Microsoft Office products, especially in Excel and Microsoft Access and Power BI
• .
Able to manage one’s own work, especially when having multiple tasks and duties
• .
Knowledge of National Grid's business operations, company policies, and business systems preferred, but not required
• .

Capability Requirements:

• )
Impact and Influence: Uses direct persuasion to influence others, using basic data, logic or a solid business cas
• e
Customer Orientation: Takes personal responsibility for correcting problems promptly and communicates customer expectation
• s
Attention to Detail: Reviews accuracy of own work and checks that all details are complete
• d
Conceptual Thinking: Sees patterns or trends in data or situations, notices when something is similar to a past situatio
• n
Information Seeking: Establishes the facts by digging deeper, asking probing questions and challenging initial responses from different source
• s

More Information