Job Information
Middlesex Water Company Capital Program Administrator in Iselin, New Jersey
Are we RIGHT for you?
The word RIGHT stands for what we VALUE: Respect, Integrity, Growth, Honesty and Teamwork.
Why join our team?
Middlesex Water Company (NASDAQ:MSEX) has been an industry leader since 1897. We promote professional and personal development in a work environment that is supportive and responsive. We understand the importance of our services and the individuals who uphold our reputation.
Joining our team means that you have a multitude of benefits that support you in and out of the workplace such as- full medical, dental, and vision benefits, 401k, paid time off, tuition assistance, learning and development opportunities, employee assistance program, and more. To learn more, please visit www.middlesexwater.com
Job Summary:
The Enterprise Capital Program Coordinator/Administrator (PA) works with Directors of Engineering (Capital Program Owners - CPO), Accounting Staff and Project Managers (PM’s), with the Enterprise Resource Planning (ERP) Information Systems and other tools to administer/report/track the overall status and progress of capital projects throughout the Enterprise. Has the overall responsibility to monitor and report on project financial and control goals/objectives thru review and preparation of reports and submittals for individual projects and overall capital program . The PA work includes periodic and on demand ad hoc reporting including updates to the Enterprise Project Information System (PIMS) and stakeholders. The successful candidate will be passionate about supporting and driving the Company’s Values, RIGHT: Respect, Integrity, Growth, Honesty and Teamwork.
Work Performed:
Support Annual Capital Program/Budget development process
Consistent with established policies and procedures and under the guidance of the CPO create/update forms and templates used in the annual process for the compilation of the Capital Budget and Program submissions.
Support and participate in process to oversee and prepare the consolidated budgets and support information.
Actively review and prepare supporting materials and analysis to facilitate the preparation of the budget and submittal to management for approval. This includes:
Distribute Capital Request documents to Enterprise Staff
Collect and perform cursory completeness review for compliance with procedures and standards.
Compile request into summary and consolidated Capital Program Documents.
Preparation for implementation of approved Capital Program and Budget
Prepare updates to ERP and PIMS systems with approved capital budget and year end expenditure information for all projects in the capital program. This includes the year end reconciliation process for updated authorization for projects at the beginning of the budget year.
Support the ongoing process for project manager preparation and submission of Non Budget Authorization (NBA) requests as needed based on established procedures.
Oversee and update project authorization information into ERP WAM and PIMS systems
Monthly Capital Project Reports preparation, review and issuance
Work with Accounting Department staff to complete the monthly Capital Projects Report in excel format for Enterprise companies. This involves compiling and checking exported information from ERP and PIMS systems to the report format
Review monthly reports for completeness and errors including financial, PM updates, approvals, and anomalies of information that need to be verified and corrected/updated.
Review reports for trends in non charges inconsistent with PM updates indicating project completion or inactivity. Assess whether account / project adjustments are necessary based on project status (completed), account change (Preliminary to construction), or other anomalies.
Analyze projects financial transactions and trends for impact to overall project stated goals.
Review monthly reports to assure compliance with Standard Operating Procedures (SOP)’s
Develop and distribute individual project reports providing PM’s with updated information on project status’
Provide established monthly reports to PM’s on transaction details on projects in PE/Design/Construction
Create and provided established monthly summaries of charges made to all individual projects/blankets to the respective Project Manager for review.
Participate in Reforecast Process for major projects
Initiate, oversee and accumulate updates to project cost projections to compile overall capital budget reforecasts for budget year.
Capital Project Records Creation and Administration
Administrate the information system records for new and updated information for projects including assigning project ID’s to new project requests, create/open ERP/PIMS records, electronic and hard copy record folders in accordance with SOP’s.
Preparation, review and processing of Capital Project Completion Phase Reports
Assist and support final project accounting tasks with project managers and staff for necessary Completion Phase documents and reports including Utility Plant in Service (UPIS) transfer reports, support information for Project completion Asset Management Plans (PCAMP)
Once a completed project has been identified, oversee and perform closeout and archive processes for the project data in the InVizion PIMS, WAM and project folders in accordance with MSEX standards/procedures.
Miscellaneous Reports and Analyses
Provide support for rate case exhibits and analyses as needed for rate cases
Exhibits (P-2) and relative updates for capital expenditures
Miscellaneous Discovery requests
Project listing and reports for Distribution System Improvement Charge (DSIC) submissions and support
Prepare monthly Enterprise Non-Revenue Water Report
Collecting from operational production and demand records, in accordanc ewtih standard procedures prepare the monthly Enterprise Non-Revenue water worksheet for distribution to senior management
Prepare monthly Enterprise Capital Expenditure vs. Budget report
Prepare the monthly Enterprise Capital Construction Work In Progress Report presenting actual vs. authorization for Senior Management Information and review using established procedures
Backup to Engineering personnel for miscellaneous reports including accumulation of information, preparation of reports, and review / quality assurance of reports. This includes accumulation of asset information and statistics for internal and external reporting (Excise Tax Report, BPU Asset Information (Blue Book), Revenue calculation reports for public fire charges)
Miscellaneous
Serve as backup to Engineering Department Personnel as needed for additional clerical / administrative tasks
Provide support to Accounting and Engineering Department in miscellaneous financial activities including
Operating Budget Preparation support for Depreciation and AFUDC (based on Annual Capital Budget)
Liaison with External Auditors (Capital Expenditure selections, follow up questions, etc.)
Repairs and Maintenance Expenditure Analyses for major programs and projects
Act as InVizion PIMS subject matter expert.
Essential Functions:
Financial Assessment and accounting to Company standards
Ability to interact and represent the Company with coworkers, customers, peers, contractors and officials.
Computer and organizational skills including an overall understanding of data manipulation and processing.
Capability for light physical work.
Good problem solving ability and analytical skills.
Qualifications:
High school diploma with high level of accounting / spreadsheet work competency
2-3 years’ experience with Project Accounting and Enterprise Information System use and capability, or equivalent experience.
Capital Project accounting experience .
New Jersey driver’s license.
Computer experience in database and spreadsheet usage and systems setup and modification including Word, Excel, and Access.
GIS capabilities
Excellent organization skills and ability to perform work independently.
Good communication (verbal and written) skills.
Ability to read, interpret, and edit financial accounting reports, transactional data, and enterprise information systems.
Physical Requirements:
This position requires constant operation of a computer and other office equipment such as printers, copiers, calculators.
Must have the ability to visually inspect and review hard copy and online documents.
Must be able to communicate, detect, converse with, discern, convey, express oneself, discuss and exchange information.
Use written, verbal and audio communication and information sources.
Must be able to occasionally move about inside the office and use stairs to access file cabinets, office machinery, etc.
Must be able to remain in a stationary position 50 % of the time
Americans With Disabilities Act:
Climbing ability.
Visual acuity.
Manual dexterity.
Heavy lifting.
Normal hearing.
Walking ability.
Must be able to smell.
Candidates must possess authorization to work in the United States.
Middlesex Water Company and its' subsidiaries are an Equal Opportunity Employer.
Candidates must be able to pass a drug screen, pre-employment physical, background check, and have a valid driver’s license in good standing.
No phone calls please. We thank all applicants in advance for their interest; however, only those applicants who are being considered for the position will be contacted.
