Business Analyst; Finance

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.

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.

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.

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.

• 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)

• 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

• 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

• 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…