Business Systems Analyst II

City of Aurora

About The Position

Aurora Water is responsible for the operation and maintenance of the drinking water, sanitary sewer and storm drainage systems, treatment of drinking water and non-potable reclaimed wastewater for irrigation, billing and collection, public outreach and water conservation, acquisition and development of future water rights, major capital projects programs, and quality control for regulatory compliance and public health. The Business System Analyst administers and coordinates technical and business process support for multiple technology initiatives for all city departments. Acts as Department Budget Coordinator. The analyst will be the primary liaison between the ERP provider, the SMEs within each accounting area, the ancillary software firms, and the Information Technology (IT) Department. Additionally, the Financial Business Systems Analyst will perform system testing, provide end-user support, address business user inquiries, and assist in development, design, and analysis activities. Additional responsibilities will include development of procedures and documentation. This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.

Requirements

An equivalent combination of education, training, and experience that demonstrates required knowledge, skills, and abilities may be considered.
Education: Bachelor's Degree in a Finance or IT related field.
Experience: At least two years of business systems analyst experience with an emphasis on full-service ERP financials systems
Knowledge of the principles and practices of governmental finance and budgeting; methods, techniques, and processes including budgeting and governmental accounting
Principles and practices of applications development, maintenance services operations, and project management
Personal computers and productivity applications, including Microsoft Office Suite products
Access database management
Database architecture and applications
System security measures and control
Program languages such as SQL
Skills: Problem solving, assessment, and project management
Interpersonal working relationships
Operating city standard computer equipment and peripheral devices
Technical writing and training
Software including spreadsheets, database management, presentation applications and word-processing
Abilities: Demonstrate a high level of technical curiosity to learn and apply new technologies
Think independently and consider cross-functional/downstream impacts
Organize and prioritize work, including establishment and fulfillment of goals and objectives
Work in a team structure
Prepare accurate reports
Establish and maintain effective working relationships with the financial SME’s, department managers, other employees, technology industry representatives, other agencies, and citizens
Assess user needs, document business process workflows, and apply technical knowledge to develop solutions
Resolve technical support problems with vendors
Prepare training materials relating to technology applications and practices
Prepare ad hoc queries or reports
Handle sensitive situations with tact and diplomacy.
Communicate effectively both orally and in writing and synthesize complex information into a more useful format for decision-makers and system users.
Establish and fulfill goals and objectives.

Nice To Haves

At least four (4) years progressively responsible analytical/administrative experience in areas such as control of complex governmental accounting systems, financial analysis, productivity improvements, work systems review, and complex spreadsheet development.
Experience with Microsoft Access from a development perspective
Advanced Microsoft Excel skills
Proficiency in SQL
Experience in effective financial analysis including all related modules/activities for a governmental agency (state, county, or local level)
Experience with enterprise-wide ERP system implementations with state or local government is preferred.

Responsibilities

Collaborate with employees on technical projects to clarify user needs and develop new or updated business processes
Define, coordinate/build and deliver reports to meet operational needs
Define, test and implement changes for financial systems
Design, document, and maintain financial ERP system processes
Determine system enhancement priorities and manage workflow to meet deadlines
Develop relationships with the financial SME’s, vendors, and other city departments to optimize and enhance financial systems
Maintain technical proficiency and working knowledge concerning financial systems
Manage assigned projects within the scope of needs assessment, timelines, budget, and city standards
Prepare test plans, coordinate users, perform critical testing and coordinate upgrades
Present data and interpretations from technology assessments and projects both orally and/or written to a wide varying audience
Report on technical issues or questions to ERP team and/or Finance Management and make recommendations for fixes or enhancements
Serve as Administrator of the financial ERP system
Troubleshoot user application issues, document and report problems, and work to resolve issues with the SME’s, vendors and IT as needed
Train end users on systems, including enhancements and upgrades
Performs other related duties as assigned

Benefits

Make a difference in the lives of real people every day
Diverse community
Competitive total compensation package
Well-Funded General Employees Retirement Plan
Light rail station minutes away
On-site fitness center and overall employee well-being programs
Internal educational programs to assist with career advancement
Access to innovation workspaces
Rewarding public sector work impacting a large and diverse community
Growing city and employee population
Rich benefits package with low employee costs
Generous paid leave program
100% funded Employee and Family Care Leave Program
Retirement pension plan and 457b plans available
Subsidized recreation center pass, on-site fitness centers and wellness programs
Continued education and career advancement opportunities