Business Systems Analyst II

Business Systems Analyst

OVERVIEW OF POSITION / DEPARTMENT

The Financial Systems Analyst provides technical expertise and support to the Finance Department for the Finance ERP, Budget, and other ancillary systems. This position will begin by supporting finance related special projects, primarily the implementation of the Paid Time Off (PTO) initiative. The PTO project will require new configuration to the Workday ERP therefore, strong knowledge and understanding of Workday is required, and in depth understanding of Time Tracking and Absence modules is preferred. This position will act as a supporting member of the ERP transition team, who are the subject matter experts (SME) and are currently implementing the Workday Financials platform. 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.

PRIMARY DUTIES & RESPONSIBILITIES

• Collaborate with employees on technical projects, including the PTO initiative, to clarify user needs and develop new or updated business processes

• Document and track PTO initiative requirements for the team to stay on track and focused on next steps

• Document PTO initiative decisions made, justification for decisions, background information

• Document issues and risks related to the PTO initiative and facilitate discussions to resolve risks and issues

• Test PTO system requirements and functionality

• Define, coordinate/build and deliver reports to meet operational needs

• Define, test and implement changes for financial systems

• Design, document, and maintain financial system processes, primarily related to the PTO initiative

• 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

• Report on technical issues or questions to ERP team and/or Finance Management and make recommendations for fixes or enhancements

• 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 PTO functionality and processes

• Performs other related duties as assigned

Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.

MINIMUM QUALIFICATIONS

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:

• Strong understanding and knowledge of Workday Payroll, and the Time Tracking and Absence modules. Good understanding of Workday HCM

• At least two years of business systems analyst experience with an emphasis on full-service ERP financials systems

Preferred Qualifications:

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

Knowledge:

• Knowledge of Payroll practices related to paid time off, compensated absences, and general payroll requirements

• Knowledge of HFWA, CARES Leave, and other leave policies

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

Licenses and Certifications Required:

WORKING CONDITIONS

Essential Personnel:

• When a local announcement of emergency or disaster is declared by the City, all City of Aurora employees may be required to work as essential personnel.

Physical Demands:

• Sedentary physical work requiring ability to lift a maximum of 10 pounds.

• Occasional walking and standing.

• Some lifting and carrying of materials for presentations and displays.

• Hand/eye coordination for operation of computer.

• Foot/eye for operation of motor vehicle to presentation sites.

• Vision to read and interpret reports and other written documents.

• Speech communication and hearing to maintain communication with employees and citizens.

Work Environment:

• Works primarily in a clean, comfortable environment.

• Work includes combination of in-office and remote-work

• Occasionally works nights and weekend

Equipment Used:

• Uses standard office equipment including personal computer.

• This position may require the incumbent to use personal equipment (e.g. vehicle, cell phone, tools, etc.) in the course of their employment.