Lead Analyst, Finance Services
Business Unit:
New England Jurisdiction
Requisition Number:
6571
About us
National Grid is hiring a Lead Analyst for our Billing & Collections 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 put 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 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 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
- 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.
Qualifications
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
More Information
Salary
$103,000 - $121,000 a year
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.
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 is committed to providing equal employment opportunities to all employees and applicants for employment
regardless of protected class. We do not discriminate on the basis of race, color, religion, sex (including pregnancy,
gender identity, and sexual orientation), national origin, age, disability, genetic information, or any other protected status
in accordance with applicable federal, state, and local laws. National Grid maintains affirmative action programs for
individuals with disabilities and protected veterans.
Our employment practices are designed to ensure that all individuals are treated fairly and with respect throughout the
hiring process and during employment. National Grid complies with all applicable federal, state, and local antidiscrimination laws. We are dedicated to fostering a workplace that is free from unlawful discrimination and harassment,
and we encourage a culture of respect for all.
#LI-AT2
Nearest Major Market: Syracuse