Lead Analyst, Finance Services

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.

• Design and develop new billing charges and rates into the National Grid billing system, as mandated by the Public Service Commission. Requires knowledge of the billing system's tariff modelling tables and billing formulas.
• 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 records
• 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.

Knowledge & Experience Requirements:

• A bachelor's degree in business, information systems, data analytics, computer science or finance; or equivalent work experience.
• 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:

• Analytical Thinking: Analyzes and interprets operational procedures, activities, and pertinent business documents toward logical conclusions and expected outcomes (identifying several likely causes or consequences of a situation)
• Impact and Influence: Uses direct persuasion to influence others, using basic data, logic or a solid business case
• Customer Orientation: Takes personal responsibility for correcting problems promptly and communicates customer expectations
• Attention to Detail: Reviews accuracy of own work and checks that all details are completed
• Conceptual Thinking: Sees patterns or trends in data or situations, notices when something is similar to a past situation
• Information Seeking: Establishes the facts by digging deeper, asking probing questions and challenging initial responses from different sources