Financial Analyst 1 (Finance Department)

City of Detroit Logo
City of Detroit
Detroit, MICHIGAN, United States
64600 - 97000 USD / Year
  • Healthcare
  • FlexTime
  • FullTime
  • Seasonal
  • Shift
  • Applications have closed

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.Examples of Duties REQUIRED KNOWLEDGE, SKILLS AND ABILITIES KNOWLEDGE OF:

  • 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 schedules for audits, and quarterly reconciliation of noncapital projects

SKILL TO:

  • Identify, synthesize, and evaluate complex budget related issues and assignments,

consolidating information from a variety of sources, and selecting appropriate analyticalapproaches.

  • Present concise financial and operational information (orally, written, and/or using PowerPoint

or Word) to a variety of audiences.

  • Use Microsoft Office (i.e. Word, Excel, Access, PowerPoint, and / or other office suite

software packages).

  • Use Excel (e.g. Pivot Tables, Vlookup, Hlookup, charts, tables, and / or other related software

packages) functionality.

  • Communicate in writing clearly and effectively, demonstrate this skill by rendering technical

details and reports in a form readily understandable to management and the public.ABILITY TO:

  • Work effectively with minimal supervision
  • Complete specialized, technical assignments
  • Develop effective working relationships with other business units as well as external vendors and customers
  • Conduct Research
  • Partners with City Agencies to oversee the development of multi-year operating and capital plans, reserve forecasts, and long-range financial strategies
  • Manage the strategic financial modeling, annual target setting, and annual business planning process for City Agencies to assess financial implications and support complex business decisions
  • Recommend, develop, implement, and monitor financial and operational policies, guidelines, processes, procedures, internal controls, and performance measures
  • Analyzes and evaluates the financial and business operations and transactions engaged in by

many different departments/agencies

  • Communicate effectively, both verbally and in writing

  • Understand and follow verbal and written instructions

  • Establish and maintain effective working relationships with others

  • Communicate frequently with team members and other units across the Department about process, equipment or potential problems

  • Effectively utilize appropriate security and safety equipment and procedures

  • Maintain regular and reliable attendance

  • Develop proficiency in unit specific operations and software

  • Direct team activities or to work as a team member

  • Collect, quickly interpret, and analyze information from a variety of sources, apply criteria, draw conclusions and develop recommendations, guidelines, and policies

  • Read, interpret, and effectively analyze professional and technical reports

  • Choose the right mathematical methods or formulas to solve a problem

  • Plan, coordinate, set priorities, and supervise staff and others engaged in diversified fiscal analysis and forecasting activities

  • Develop cost-benefit and business case analyses by consolidating information, identifying relevant data, and making logical assumptions to provide insight and recommendations with minimal errors regarding cost savings, optimal organization and financial structure, and program offering

  • Participate in decision-making sessions, by interpretation of data, potential roadblocks, and program improvements through analysis of monthly reports and special analysis

  • Communicate information and ideas clearly and effectively both orally and in writing

  • Work tactfully and effectively with employees, supervisors and managers, and with elected and appointed officials and senior staff in assigned Departments and Agencies

  • Take initiative to acquire additional knowledge and education to remain current in field

  • Work as part of a team

Minimum Qualifications REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)

  • Bachelor’s degree; with specialization in Account or Finance ONLY, or equivalent experience
  • MBA – Preferred
  • Minimum of 1-3 years of experience related to the field of (economics, finance, accounting) and/or related job assignment

ESSENTIAL REQUIREMENTS Physical Requirements: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties. This position requires the ability to remain sedentary and requires extensive computer use and extended time seated in meetings.EMPLOYMENT BENEFITS The City of Detroit offers a competitive and comprehensive employee benefit package. We pride ourselves on the longevity of our employees. Part of the reason for the low turnover rate is the exceptional benefit package listed below. Benefits include, but are not limited to the following:HEALTH

  • Medical – Eligible for hospital, surgical, and prescription drug benefits.
  • Dental
  • Vision

INSURANCE

  • Life Insurance – Optional group insurance available to employee and their family. The City pays 60% of premium for first $12,500 of employee life insurance. Employee may purchase, at own expense, life insurance for spouse and each dependent.
  • Long-Term Disability Insurance (Income Protection Plan) – The City offers disability insurance through payroll deductions for persons who become disabled and who are not yet eligible for a service retirement.

PAID TIME OFF

  • Sick Leave
  • Vacation
  • Holidays

OTHER LEAVE BENEFITS
The City also has the following paid and unpaid leaves; funeral leave, Family and Medical Leave, jury duty, military duty leave, unpaid personal leave,RETIREMENT BENEFITS
City Employees Retirement System
As a regular City employee you automatically become a member of the General Retirement System. This entitles you to a retirement allowance after:

  • Completion of thirty (30) years of service;
  • At age sixty (60) if you have at least ten (10) years of service, or- At age sixty-five (65) with eight (8) years of service. • In the event of disability, other eligibility rules apply);- An early, actuarially reduced, retirement is offered after you have attained at least twenty-five (25) years of service; • Employees are vested after ten (10) years of service, regardless of age.ADVANCEMENT OPPORTUNITIES – Employees have many opportunities for growth and career advancement throughout all City departments and divisions.Have a successful career with the City of Detroit. Always remember that you are a part of a team with a common Vision of delivering excellent service to the citizens of the City of Detroit.

City of Detroit

Apply for job