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 HCMt least two years of business systems analyst experience with an emphasis on full-service ERP financials systemsPreferred Qualifications :
t 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 perspectivedvanced Microsoft Excel skillsProficiency in SQLExperience 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 requirementsKnowledge of HFWA, CARES Leave, and other leave policiesKnowledge of the principles and practices of governmental finance and budgeting; methods, techniques, and processes including budgeting and governmental accountingPrinciples and practices of applications development, maintenance services operations, and project managementPersonal computers and productivity applications, including Microsoft Office Suite productsccess database managementDatabase architecture and applicationsSystem security measures and controlProgram languages such as SQLSkills :
Problem solving, assessment, and project managementInterpersonal working relationshipsOperating city standard computer equipment and peripheral devicesTechnical writing and trainingSoftware including spreadsheets, database management, presentation applications and word-processingAbilities :
Demonstrate a high level of technical curiosity to learn and apply new technologiesThink independently and consider cross-functional / downstream impactsOrganize and prioritize work, including establishment and fulfillment of goals and objectivesWork in a team structurePrepare accurate reportsEstablish and maintain effective working relationships with the financial SME's, department managers, other employees, technology industry representatives, other agencies, and citizensssess user needs, document business process workflows, and apply technical knowledge to develop solutionsResolve technical support problems with vendorsPrepare training materials relating to technology applications and practicesPrepare ad hoc queries or reportsHandle 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-workOccasionally works nights and weekendEquipment 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.
