Lead Analyst

About us

National Grid is hiring a Lead Analyst for Billing Operations Department in Syracuse, NY.

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.

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 that the bills are accurate 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

- 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 for IT with detailed analysis and recommended fix. Create queries (SQL) to find all impacted accts 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 interview 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

Employees are expected to have the knowledge & experience listed below.

- A bachelor’s degree in business, information systems, data analytics, computer science or finance; or equivalent work experience.

- Knowledge of National Grid’s billing system, CSS (Customer/1) required.

- Experience and proficiency in writing SQL against the CSS (Customer/1) database is required.

- Proficient in Microsoft Office products, especially in Excel and Microsoft Access.

- 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

More Information

Salary

$99k - $117k a year

This position has a career path which provides for advancement opportunities within and across bands as you develop and evolve in the position; gaining experience, expertise and acquiring and applying technical skills. Candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.

National Grid utilizes an assessment that evaluates the job qualifications/characteristics using AI or statistically based scoring. For more information, please view NYC Local Law 144.

National Grid is an equal opportunity employer that values a broad diversity of talent, knowledge, experience and expertise. We foster a culture of inclusion that drives employee engagement to deliver superior performance to the communities we serve. National Grid is proud to be an affirmative action employer. We encourage minorities, women, individuals with disabilities and protected veterans to join the National Grid team.