Business Analyst (Finance)

Salary : $71,000.00 - $106,400.00 Annually
Location : DWSD -735 Randolph Detroit MI 48226, MI
Job Type: Classified- Regular (DWSD Only)
Job Number:
Department: Water Department
Opening Date: 10/13/2026
Closing Date: 10/16/2026 11:59 PM Eastern
Bargaining Unit: 9031-Non Union Appointees (DWSD)

Description

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.
SUMMARY:

Business Analysts use data to understand business processes, identify problems and/or opportunities and assist with developing improvement plans. The Business Analyst will review consumption patterns, and work with customers and third party vendors to coordinate internal program related efforts.

The Business Analyst will work effectively with minimal supervision and will report to the billing management team.

ESSENTIAL JOB FUNCTIONS:

The Business Analyst will carry out program related job functions such as income document review, eligibility analysis and other program related duties. Assist in analyzing data and systems to provide in-depth analysis reports. Meet with key team members to define business requirements, applications and systems goals, and to identify and resolve business, applications and systems issues.
Review and analyze the effectiveness and efficiency of existing applications, processes and systems, and develop strategies for improving or further leveraging these processes, applications and systems. Assist in the deployment of new processes, applications and in delivering enhancements to existing processes and applications. Perform application and/or process design, configuration, and integration. Conduct cost-benefit and return on investment analyses for projects as needed. Coordinate and perform tests for existing and new applications and processes. Provide training to end users. Identify potential risks with business processes and provide solutions.

RELATED JOB FUNCTIONS:

Position may be called upon to direct specific project activities, or to work as a team member. Advise on requirements, policies, procedures and best practices to accomplish business relevant to provision of departmental services. Collaborate with other business units. Position may require communication with customers. Perform related work duties as assigned.

Examples of Duties
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

KNOWLEDGE OF:

• Job assignment and/or expertise area
• Business technology, data management systems and applications (Oracle)
• Department-wide reporting tools
• Departmental mission, processes, policies and procedures
• Budget Planning and Analysis
• Operational cost metrics such as operating expenses, GL assignments, activity-based costing concepts (Preferred)

SKILL TO:

• Independently, and as part of a team providing timely, high-quality customer-focused services and data analytics as well as data analysis
• Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
• Work in a professional manner with access to confidential and other data types
• Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
• Analyze the requirements of business systems and processes
• Analyze data and create presentation as required
• Use advanced technology
• Work in a team-oriented and collaborative environment

SKILL TO: continued

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

software packages)

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

packages) functionality

• Use of SQL to create reports and analyze data
• Highly self-motivated and directed

• Strong customer service orientation
• Prioritize and execute tasks while under pressure.
• Deliver quality reporting and presentations, including the ability to articulate the problem or the request
• Understand and translate the needs of the division and make recommendations
• Understand Procurement policies and assist the division with the implementation of contracts

ABILITY TO:

• Investigate accounts to ensure accurate preparation of bills; Review accounts for high usage/negative usage, or usage that is inconsistent with account history prior to billing.
• Create reports using SQL that meet departmental needs

• Organize, perform and or coordinate divisional tasks and projects
• Deliver quality customer service to users
• Write technical and non-technical documentation
• Apply divisional policies and processes in a manner aligned with the Department mission, goals, and strategies
• Effectively utilize appropriate security and safety equipment and procedures
• 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
• Develop proficiency in division specific operations and software
• Direct team projects or to work as a team member
• Maintain regular and reliable attendance
• Consult, coordinate and communicate with business unit staff as required
• Responsible for capacity planning and management, security planning and management and data management
• Plan, design, and implement process improvement initiatives
• Maintain working knowledge of current industry information, vendor direction, new and emerging products, and approaches related to current and future organizational needs

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

• Bachelor's degree; with specialization in Finance or Business Administration or related field of study
• Minimum of 1-3 years of experience related to the field and/or job assignment
• Education requirement can be substituted with extensive experience, at the discretion of the General Manager or designee.

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.

A valid Michigan Driver's License and the ability to drive a motor vehicle on all terrain. Follow security and safety policies and procedures in carrying out work duties. Provide on the job training.
Environmental Working Requirements:

Work may be performed in the plant or office environment. Work may be performed near excessive noise and moving objects/vehicles.

OTHER REQUIREMENTS
Valid Michigan Driver's License

The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.
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.