Business Analyst (Finance)

City of Detroit; Detroit (MI); On-site; USD 65,000 - 85,000; Full time

Job summary

Detroit Water and Sewerage Department is seeking a Business Analyst to review consumption patterns, analyze data, and support improvement plans. You will collaborate with customers and third party vendors to coordinate internal program efforts and report to the billing management team.

The role requires a Bachelor’s degree in Finance or Business Administration and 1–3 years of related experience. Proficiency in SQL, Oracle, and MS Office is expected to deliver quality reporting and data insights.

Qualifications

• Bachelor’s degree in Finance or Business Administration or related field.
• 1-3 years of experience in the field.
• Education may be substituted with extensive experience at GM’s discretion.

Responsibilities

• Review consumption patterns and analyze data to support program improvements.
• Develop reports and presentations for stakeholders.
• Coordinate with customers and third party vendors to align efforts.

Skills

Data analysis

SQL

MS Office

Presentation

Communication

Problem solving

Teamwork

Financial analysis

Education

Bachelor's degree in Finance or Business Administration

Tools

Oracle

SQL

Reporting tools

Job 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.

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

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.