Financial Analyst ; Finance Department

Description
SUMMARY: The Financial Analyst provides information and analysis to enable executives, managers, and supervisors to make informed strategic and tactical business decisions. The Financial Analysts focus is on financial and operational planning and analysis including strategic planning, budgeting, forecasting, financial modeling, and detailed financial analysis. The Financial Analyst will work effectively with minimal supervision and will report directly to the Chief Financial Officer.

This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates.

Applicants for open positions at the Detroit Water and Sewerage Department must be authorized to work for ANY employer in the U.S. The Detroit Water and Sewerage Department is unable to sponsor or take over sponsorship of an employment Visa at this time.

ESSENTIAL JOB FUNCTIONS: The Financial Analyst will prepare weekly, monthly, quarterly, and annual reports in which the analyst will compare financial and operational results using actual, historical, budget, and forecast data. The Financial Analyst monitors the implementation of DWSD’s budget to ensure compliance and develop financial and operational metrics to measure progress. The Financial Analysts also prepare reports and presentations and provide recommendations regarding the financial and operational risks and opportunities associated with specific decisions.

The Financial Analyst use enterprise resource planning systems, spreadsheet, and statistical software packages to analyze financial and operational data, identify trends, and develop forecasts.

RELATED

JOB FUNCTIONS:

The Financial Analyst uses cost studies and alternative analysis to assess efficiencies and priorities. Cost studies include evaluations of financial and operational results, grants management, capital projects, procurement initiatives, and other municipality standards. The Financial Analysts use spreadsheet and statistical software packages to prepare, present findings while utilizing benchmarking and comparison studies of similar organizations to assist in decision making.

• Financial theory and principles of business management operations and practices
• Operational cost metrics such as overtime, productivity, operating expenses, GL assignments, activity-based costing concepts
• Financial Planning and Analysis from running a day-to-day operation
• Budget Planning and Analysis
• Contracting cost and analysis
• Make versus Buy Analysis
• Concepts, principles, practices, and methods of budget formulation, enactment and execution,

accounting and finance functional area(s)

• Standardized bookkeeping processes, accounting terminology, generally accepted accounting

principles (GAAP), accounting techniques, and other financial rules and regulations

• Business technology, data management systems and applications
• Department-wide reporting tools
• Departmental mission, processes, policies and procedures
• Economic and accounting principles and practices, the financial markets, banking, and the

analysis and reporting of financial data

• Basic Geographic Information Systems
• CAPITAL ANALYST – Perform Construction Work-In-Progress tasks as needed (Reconciliation, Update and maintain project files, Capitalize projects, Approve projects in Oracle)
• CAPITAL ANALYST – Perform Fixed Asset Management tasks as needed (Review mass addition file, Perform Oracle tasks, Maintain equipment tags, Prepare acquisition forms, Prepare quarterly reconciliation fixed-asset and depreciation
• CAPITAL ANALYST – Prepare monthly bank and quarterly retainage reconciliation, manage common cash pool items, Perform fund analysis, Maintain arbitrage files for bond funds and maintain file of all meter purchases, installation and disposal
• CAPITAL ANALYST – Prepare year-end file of manual accruals and participate in fleet inventory
• CAPITAL ANALYST – Prepare journal entries, client…