- Salary
- $71k – $106k/yr
- Location
- DWSD -735 Randolph Detroit MI 48226, MI, MI, US
- Department
- Finance
- Experience
- 1+ years
- Visa
- Not sponsored
- Source
- GovernmentJobs
Description
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.