Business Analyst (Finance)

City of Detroit•DWSD -735 Randolph Detroit MI 48226, MI

About The Position

The Business Analyst uses data to understand business processes, identify problems or opportunities, and assist with developing improvement plans. The role reviews consumption patterns and works with customers and third-party vendors to coordinate internal program-related efforts. The analyst works effectively with minimal supervision and reports to the billing management team. The position carries out program-related duties such as reviewing income documents and analyzing eligibility. It also supports data and systems analysis, business requirements definition, process and application improvements, deployment and integration of processes and applications, project cost-benefit analysis, testing, and end-user training. The analyst may direct project activities or work as a team member, advise on requirements and departmental practices, collaborate with other business units, and communicate with customers. The role requires a bachelor’s degree specializing in Finance, Business Administration, or a related field, and 1–3 years of related experience. Extensive experience may substitute for the education requirement at the discretion of the General Manager or designee. The position requires a valid Michigan driver’s license and the ability to drive a motor vehicle on all terrain. Work may take place in a plant or office environment, including areas near excessive noise and moving objects or vehicles. Employees must undergo alcohol and drug screening and are subject to a criminal background investigation.

Requirements

Bachelor’s degree with a specialization in Finance, Business Administration, or a related field of study; extensive experience may substitute at the discretion of the General Manager or designee.
Minimum of 1–3 years of experience related to the field or job assignment.
Valid Michigan Driver’s License and ability to drive a motor vehicle on all terrain.
Knowledge of business technology, data management systems and applications, including Oracle.
Knowledge of department-wide reporting tools, departmental mission, processes, policies, and procedures.
Ability to analyze business-system and process requirements and data, and create reports and presentations.
Advanced Microsoft Office skills, including Excel functionality such as PivotTables, VLOOKUP, HLOOKUP, charts, and tables; experience with Word, Excel, Access, PowerPoint, or other office-suite software.
Ability to use SQL to create reports and analyze data.
Ability to investigate accounts and identify high, negative, or historically inconsistent usage before billing.
Ability to work independently and collaboratively, prioritize competing requests amid frequent interruptions, and execute tasks under pressure.
Ability to exercise judgment, discretion, confidentiality, initiative, and professionalism when handling confidential data.
Strong customer-service orientation and ability to deliver quality service, reporting, and presentations.
Ability to understand and translate divisional needs and make recommendations.
Ability to understand procurement policies and assist with contract implementation.
Ability to write technical and non-technical documentation and communicate effectively verbally and in writing.
Ability to follow verbal and written instructions and establish effective working relationships.
Ability to apply departmental policies and processes in alignment with the department’s mission, goals, and strategies.
Ability to use appropriate security and safety equipment and procedures.
Ability to develop proficiency in division-specific operations and software.
Ability to maintain working knowledge of industry information, vendor direction, and emerging products and approaches.
Ability to remain sedentary, use a computer extensively, and sit for extended periods in meetings.
Must follow security and safety policies and procedures; employees are subject to alcohol and drug screening and criminal background investigation.

Nice To Haves

Knowledge of operational cost metrics, including operating expenses, general-ledger assignments, and activity-based costing concepts.

Responsibilities

Review consumption patterns and coordinate internal program-related efforts with customers and third-party vendors.
Review income documents and perform eligibility analysis and other program-related duties.
Analyze data and systems and prepare in-depth analysis reports.
Meet with key team members to define business requirements, application and system goals, and address related issues.
Review the effectiveness and efficiency of existing applications, processes, and systems and develop improvement strategies.
Assist with deployment of new processes and applications and delivery of enhancements to existing ones.
Perform application and 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 and on-the-job training.
Identify potential business-process risks and provide solutions.
Direct specific project activities or participate as a team member; advise on requirements, policies, procedures, and best practices.
Collaborate with other business units and communicate with customers as required.
Investigate accounts for accurate bill preparation and review accounts for unusually high or negative usage or usage inconsistent with account history before billing.
Create SQL reports that meet departmental needs and deliver quality reports and presentations.
Organize, perform, or coordinate divisional tasks and projects; provide customer service to users.
Write technical and non-technical documentation and apply divisional policies and processes in alignment with department goals.
Communicate and coordinate with team members, business-unit staff, and other department units.
Manage capacity planning, security planning, and data management.
Plan, design, and implement process-improvement initiatives.
Maintain regular and reliable attendance and perform related work duties as assigned.