Overview
The incumbent will support the financial analytics for Customer Programs. The incumbent will assist to develop budgets, monitor, and analyze actual spending against budget; report on actual performance and key performance indicators to support business decisions. The incumbent will provide financial and contractual support for both the Customer Connections and the Service Line Inspection program. In addition, may provide support for the Gas Interruptible program initiatives including regulatory filings, customer billing, notifications, and other program work.Responsibilities
Core Responsibilities* Gather, review, analyze and report spending data. Investigate drivers for cost variance
•Develop and maintain reports in either Excel, Power BI or Tableau for data visualization and performance tracking
•Support budget development process, particularly with the quantification of the work plan (e.g., unit cost trend analysis)
•Responsible for updating all relevant systems that support the department's projects
•Managed schedules, organize resources, and maintain records
•Support financial forecasting processes with analyses and update forecasting information system
•Implement tracking system to increase operational efficiency and work with operating areas to identify mischarges and recommend solutions
•Participate in special projects as assigned
•Assist the Program Manager with identification of any program discrepancies by developing and using various tracking systems such as Power BI, Tableau, Excel and work closely with internal stakeholders to correct any unit or financial discrepancies
•Perform other related tasks and assignments as required.
Qualifications
Required Education/Experience* Bachelor's Degree and 2 years' relevant experience or
•Associate's Degree and 4 years' relevant experience
Relevant Work Experience* Demonstrated quantitative experience and critical thinking capabilities, is required.
•Previous experience of querying data from multiple internal systems, performing variance analyses and communicating the results, is required.
•Proficient in MS Word, Power Point and have advanced Excel skills, is required.
•Understanding of basic accounting principles and Company accounting (e.g., income statement, balance sheet), is preferred.
•Experience using internal systems (BI, CPMS, GIS, CIS and other work and financial management systems and budgeting tools), is preferred.
•Bachelors degree in Finance/Accounting/Business/Economics/Computer Science, is preferred.
Skills and Abilities* Demonstrated analytical skills
•Assumes personal responsibility for actions
•Strong written and verbal communication skills
•Well organized, detail oriented and flexible to handle multiple assignments
•Proactively approaches responsibilities
•Possesses a high degree of initiative
Licenses and Certifications* Driver's License Required
Physical Demands* Sit or stand to answer a phone for the duration of the workday
•Sit or stand to use a keyboard, mouse, and computer for the duration of the workday
Additional Physical Demands* Must be able to respond to Company emergencies by performing a System Emergency Assignment to restore service to our customers.
•Travel to company locations through the service territory as needed.