Finance - Financial Analyst

Job Title: Financial Analyst Department: Finance Hiring Range: $73,100-$80,400 Pay Grade: 6 FLSA Status: Exempt Hybrid: Yes

The incumbent will utilize technology and other associated software to prepare, maintain, analyze, and update financial data in support of the finance department and its stakeholders.

RESPONSIBILITIES

• Assist the finance department in preparing, administering, and reporting on budgets to both internal and external stakeholders
• Identify and recommend process improvement, create ad-hoc reports, tools, and Excel dashboards and data visualizations
• Forecast, research, and analyze budget histories for various departments
• Recommend actions by analyzing and interpreting data; make comparative analysis, study proposed changes, and create standard operating procedures
• Prepare reports, summaries, and presentations on data, progress, and performance metrics
• Track and monitor changes to capital improvement plans, report findings, and financial planning issues; monitor spending to ensure alignment with approved budgets
• Coordinate and help facilitate the annual budget development process by guiding departments through budget preparation, reviewing and analyzing funding requests and budget submissions, as well as organizing and maintaining all annual budget documentation to ensure accuracy and consistency.
• Review and approve project requests (New Project Creations, Purchase Requisitions, Change Orders, Budget Transfers, etc) within Trimble Unity Construct system (TUC).
• Take action to reflect TUC requests in SAP, ensuring SAP financial software is in agreement with TUC project management platform.
• Create and maintain reporting on expenses for Distribution System Improvement Charge (DSIC) eligible projects.
• Identify trends in financial performance and provide recommendation for improvements
• Develop automated reporting and forecasting tools for more efficient use of data
• Operate as department liaison by providing information to all departments on budget preparation and management; participate in quarterly budget meetings
• Maintain records and prepare accurate reports, correspondence, etc. utilizing financial, database, and spreadsheet software applications
• Facilitate training of employees within Pittsburgh Water regarding budget procedures
• Apply mathematical or statistical techniques to address practical issues
• Attend job-related trainings to expand knowledge and increase productivity
• Perform other related tasks as assigned or required

KNOWLEDGE, SKILLS & ABILITIES

• Knowledge of the principles and practices of municipal/utility financial analysis
• Thorough understanding of accounting and budgeting principles and practices, generally accepted accounting principles, and generally accepted auditing standards
• Time management, organizational, and communication skills
• Strong technical and analytical skills
• Knowledge of software applications used for accounting, budgeting, financial reporting, word processing, database management and presentation, like SAP, Trimble Unity Construct (TUC), Microsoft Office Suite.
• Analyzing information and using logic to address work-related issues and problems
• Considerable knowledge in data analysis and statistical forecasting
• Excellent mathematical ability
• Ability to communicate effectively both orally and in writing
• Ability to manage multiple tasks and responsibilities effectively at the same time

EDUCATION / EXPERIENCE REQUIREMENTS The following requirements list the minimum education/training/experience required to qualify for this job. An equivalent combination of education and/or experience may be accepted.

• Bachelor’s Degree in Finance, Accounting, or a related field
• Three (3) to Five (5) years of professional experience

GENERAL REQUIREMENTS Applicant must present a current, valid Class C (Class 1) PA Motor Vehicle Operator’s License at the time of application or prior to appointment. A valid driver’s license must be maintained throughout employment.

Applicant must have permanent residency within one of the following Pennsylvania counties at the time of appointment and remain a resident within one of the noted counties throughout employment with the Pittsburgh Water: Allegheny, Armstrong, Beaver, Butler, Fayette, Greene, Lawrence, Indiana, Washington, or Westmoreland.

SUPERVISION EXERCISED / RECEIVED No direct reports / Will receive supervision directly from the Senior Manager, Capital Budget & Special Revenue.

PHYSICAL DEMANDS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; and see, talk and hear. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand; walk; and stoop, kneel, crouch, or crawl on even and uneven surfaces. The employee must frequently lift and/or move up to 25 pounds.

CONDITIONS While performing the duties of this job, the employee is regularly exposed to a moderate or quiet noise level in the office work environment. Subject to remain on duty beyond normal hours and/or recalled during emergency situations or other extensive periods.

MEDICAL EXAMINATION Employment may be contingent upon the results of a post-offer (initial employment or promotion) physical examination performed by the Authority's examining physician.

DRUG TESTING Employment may be contingent upon the results of a post-offer (initial employment or promotion) drug screening. Continued employment may be subject to randomized drug and alcohol testing conducted without advance notice and for reasonable suspicion.

PRE-EMPLOYMENT BACKGROUND INVESTIGATION Ability to successfully pass a thorough investigation consisting of a criminal history check, verification of prior employment and performance, reference, and credentials checks, and in some cases credit history.

Applicants are subject to a System for Award Management (SAM) or any successor system search as maintained by the General Services Administration (GSA) to ensure compliance with federal procurement and non-procurement programs.

Applications: You may be considered for other available positions based on qualifications provided on your employment application. If you have questions regarding your application, please contact the Human Resources Department at:

Pittsburgh Human Resources Department 1200 Penn Avenue Pittsburgh, PA 15222 412-255-8800 hr@pgh2o.com

An Equal Opportunity Employer: Pittsburgh Water is proud to be an Equal Employment Opportunity Employer. We do not discriminate based on any legally protected statuses, including, but not limited to race, color, ancestry, religion, national origin, sexual orientation, age, marital or family status, disability, gender, gender identity or expression, pregnancy status, or veteran status. Pittsburgh Water is committed to providing candidates with reasonable accommodations for those with disabilities during our recruiting process; if you need assistance, please contact us at hr@pgh2o.com or 412-255-8800.