Financial Analyst

Department: Budget & Finance Salary: $3,333.00 – $5,000.00 per month (commensurate with experience) How to Apply: Applications are submitted online until the position is filled and/or the posting is closed. After reviewing this job announcement, please click on the link at the bottom of the page to apply online. A resume is required with the application. Further instructions on submission of documents are available in the online application. A resume may not be substituted for an application. Minimum Requirements:

Bachelor’s degree in Accounting, Finance, Mathematics, Business

Administration or a related field AND one to three (1-3) years of professional experience in accounting or financial administration. Must have exceptional MS Excel skills and

working knowledge of statistics. CPA/MBA preferred. An equivalent combination of education and

experience may be substituted.

It is the policy of Allegheny County that in

order to receive a final offer of employment, candidates must successfully pass

background check and drug screening/medical examinations as required for the

position.

• Successful applicants for this position may be

considered for Financial Analyst openings in various County Departments* Position Summary: Reporting to Department Management, the Financial

Analyst is responsible for supervision and management of the budget. This

position is responsible for analyzing financial transactions within all areas

of the Department including payroll, accounting, budgeting, payment processing,

purchasing and contracting to drive business

decision making across the department. Duties:
Directs, coordinates, monitors and evaluates accounting and

financial controls to ensure adherence to policies and procedures related

to financial operations of the Department; reviews and revises existing

processes and procedures as necessary.

In consultation with Department Management and County

Administration, develops and implements fiscal policies and other

management planning tools; prepares, monitors and evaluates financial

forecasts and reports.

Assists in developing, coordinating and preparing the Department’s

annual operating, grant, special revenue and capital budgets for

submission as part of the County’s annual budgeting process.

Monitors and oversees departmental expenditures and revenues to

ensure compliance with operating and grant budgets; evaluates and

investigates unusual discrepancies and submits adjusting entries as

necessary.

Oversees the processing of department’s contracts and agreements

including the preparation of Executive Actions; prepares vouchers for

invoices; ensures payments are made in accordance with all required

federal, state and local provisions; monitors payments for compliance with

all applicable contract terms

Responsible for all fiscal activities related any grant and

special accounts within the Department including application, budgeting,

disbursements, deposits, monitoring, reporting, audit requirements.

Coordinates and manages responses to audits by internal and

external auditors; performs internal fiscal and procedural audits to

ensure proper internal controls.

Develop short-term and/or long-range financial plans for the

Department.

Conduct studies and analyses to determine the financial

feasibility of activating proposed or potential projects, evaluate the

adequacy of the revenue available, and determine the need for interim cash

flow until potential revenue is received.

Analyze financial statements, operating and capital reports, cash

flow, management practices, and other related elements to determine the

financial soundness of the Department and/or proposed project.

Maintain a current knowledge of the progress of approved projects

or activities through the review of reports, operating data and/or

personal observation.

Prepare financial reports, charts, tables and other exhibits as

requested by Management.

Analyze data to ensure proper accounting procedures have been

followed, investigate and report to the Manager any inconsistencies or

improprieties.

Responsible for the day-to-day general ledger accounting and

reconciliation, financial reporting and analysis for assigned functional

areas of the Department.

Responsible for performing special projects to improve process

efficiency and performance projects as assigned by Management.

Provide timely, relevant and accurate reporting & analysis of

the results of the Department’s performance against historical, budgeted,

forecasted and strategic planning results to facilitate decision-making

toward the achievement of the budget and strategic plan.

Maintain and develop various financial models and standard

templates to be distributed for use during the budget planning processes,

ensuring quality, accuracy and focused analytic review.

Identify non-value added processes within the Department and seek

solutions

Conduct cost-benefit analysis on all functional areas of the Department.

Review capital budgeting proposals and make acceptance

recommendations to Management.

Create forecasts of future business conditions using multiple

scenario analysis.

Create financial models using Excel and create PowerPoint

presentations summarizing the results of analyses and present the results

to Management.

Performs related tasks and other duties as assigned.

Knowledge, Skills, and Abilities: Knowledge of:
Principles and practices of budgeting, accounting and fiscal

management in the public sector

Finance and accounting processes, procedures and techniques used

in budget preparation and control

Generally Accepted Accounting Principles

Federal, state and local funding programs, and principles and

processes related to purchasing, grant administration and auditing

JDE Accounting system and/or other ERP systems

Human Resources functions (i.e. leave programs, workers

compensation, employee discipline, etc.)

Ability to:
Establish and maintain a process of financial management which meets acceptable professional standards

Develop, implement, monitor and forecast operational, capital, and grant budgets

Develop, revise, implement, monitor and evaluate fiscal and accounting policies, procedures and practices to accurately and efficiently oversee all department funds

Analyze financial reports and make sound recommendations for change or initiation of new programs; establish, monitor and enforce effective internal controls

Negotiate, implement, interpret and monitor for fiscal compliance contracts with vendors, consultants and contractors

Collate, analyze and interpret data, and prepare and disseminate financial reports

Strong organization skills and attention to detail

Analytical thinker with excellent written and verbal communication skills

Establish and maintain effective working relationships with supervisors, associates, outside agencies and the general public

Utilize appropriate computer programs proficiently in the accomplishment of the work (JDE, Microsoft Word, Outlook, Excel, Access, OnBase, Action Tracker, etc.)

Efficiently and accurately organize and maintain records and files, both automated and manual; and develop recordkeeping systems as necessary

Residency:Allegheny County within 1 year. Veterans’ Preference:
Will be awarded to eligible candidates.