FINAL FILING DATE: We are accepting applications until closing at 5 pm, February 11, 2020
IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.
THE POSITION
The Human Resources Department is accepting applications for the Regular and Full-time position of Business Systems Analyst II in the Information Technology Department. The normal work schedule is Monday through Friday, 8 –5 pm; a flex schedule may be available.
The City of Roseville promotes a no smoking atmosphere.
THE CITY
The City of Roseville (COR) incorporates the following CORe Competencies as part of the City’s culture:
- Focus on people: Develop and deliver service-oriented solutions that meet or exceed expectations.
- Build trust: Ensure honesty and integrity to gain confidence and support of others.
- Ensure accountability: Take responsibility for the outcomes of one’s own work and foster a sense of ownership in others.
- Communicate effectively: Deliver clear, concise messages and actively listen to ideas and questions.
- Collaborate inclusively: Build effective working partnerships, alliances, and teams.
- Make quality decisions: Make sound, timely decisions and recommendations.
- Be adaptable/agile: Change approach or methods to best fit the situation and effectively balance competing priorities.
DEFINITION
To perform professional level work in the analysis, design, programming, testing, installation and maintenance of business applications systems and databases.
DISTINGUISHING CHARACTERISTICS
This is the journey level class within the Business Systems Analyst series and is distinguished from the I level by the assignment of the full range of duties. Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.
This class is distinguished from the Senior Business Systems Analyst in that latter performs the most difficult and responsible types of duties assigned to classes within this series including assigned responsibilities for major project and program areas and exercising technical and functional supervision.
SUPERVISION RECEIVED AND EXERCISED
- Receives direction from an Information Technology Program Manager.
- May exercise technical and functional supervision over lower level professional, technical and administrative support personnel.
EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:
- Perform analytical and technical work through enterprise systems that support assigned City business applications.
- Conduct business analysis; evaluate business processes; determine business needs; identify requirements; and develop business plan analysis.
- Provide and/or ensure follow up on trouble calls and tickets; correspond with or meet customers and vendors as needed to understand and resolve concerns.
- Analyze data and information trends to support system capacity/performance planning or diagnose issues related to assigned systems; compile and prepare reports and documentation on analysis findings.
- Perform installation and configuration duties and related data migration, conversion, and maintenance and extraction work; implement and maintain databases, database tables and database objects; develop database scripts as needed for assigned systems.
- Perform configuration, testing and troubleshooting for network/communications devices and/or interfaces that support assigned systems.
- Provide project management; develop project plans and detailed project objectives; develop and guide project timelines; assess and manage risks; manage issues; develop and manage project budgets.
- Coordinate implementation of the system software, including conversion of data to new systems; work with application support personnel to resolve system problems.
- Assist departments in defining requirements for proposed business applications; review, analyze and evaluate business applications and user needs; translate business objectives into application requirements.
- Develop and participate in the development of Requests for Proposal, Quote, or Information; participate in the selection; and assist with the oversight of consultants and vendors.
- Perform reporting, testing and general maintenance of enterprise systems and identify alternative methods for better operation and use.
- Research, plan, install, configure and test new application systems and interfaces; maintain and upgrade existing application systems and interfaces; apply software updates to servers and schedule periodic server cycling
- Analyze and resolve technology related problems; resolve compatibility problems and troubleshoot system software, hardware and communication problems.
- Prepare and maintain documentation for each application; design backup procedures; and analyze problems with existing applications.
- Work closely with assigned City departments and divisions to understand and identify user computer system and equipment needs; analyze and evaluate present or proposed business procedures or problems to define enterprise application needs
- Create, record, and maintain user access and security; provide training to users regarding computer equipment and operating procedures.
- Monitor automated system processes; monitor logs and files for evidence of problems or system failures; ensure business resumption after system failures.
- Research, compile and prepare reports and documentation on program activities; analyze program and develop corrective action, maintain records of findings and corrective actions; prepare periodic status reports.
- May plan, assign, review the work of technical personnel assigned to functional area of assignment.
- Serve as liaison with system software and hardware suppliers and vendors; monitor contracted services for quality and compliance with City standards.
- Represent function on committees, outside organizations, and at staff subcommittees as necessary; coordinate technical support activities with other departments, divisions and outside agencies.
- Answer questions and provide information to the customers, via telephone, e-mail, and written correspondence related to the technical support program/operations; investigate complaints and recommend corrective action as necessary to resolve complaint.
- Build and maintain positive working relationships with co-workers, other City employees and the public using principles of good customer service.
- Perform related duties as assigned.
MINIMUM QUALIFICATIONS
Knowledge of:
- Principles and practices of business analysis.
- Principles and practices of computer systems and related analysis and design.
- Principles and techniques of programming, and business application documentation.
- Principles and practices of relational database techniques and design.
- Use, capability, characteristics and limitation of computers and related equipment.
- Network technology and environment.
- Principles and practices of project management.
- Records storage and handling techniques.
- Standards and methods related to computerized data systems and analysis use.
- Written documentation methods related to complex technical work.
- Principles and practices of interactive and batch programming.
- Application documentation; computer logic and mathematics.
Ability to:
- Perform professional work in support of enterprise systems for business applications.
- On a continuous basis, know and understand all aspects of the job. Intermittently analyze work papers, reports and special projects; identify and interpret technical and numerical information; observe and problem solve operational and technical policy and procedures.
- On a continuous basis, sit at desk for long periods of time. Intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 10 pounds or less.
- Conduct enterprise systems and procedures analysis and feasibility studies.
- Analyze data and develop logical solutions to enterprise application programming problems.
- Prepare work flow charts and code steps into programming language.
- Develop and manage information technology projects.
- Effectively lead cross-functional teams.
- Train or instruct on-line users in use of computer equipment and operating procedures.
- Prepare a variety of reports and maintain accurate records and files.
- Problem solve, make decisions, and give direction.
- Formulate, design, and implement process and product improvements and streamlining measures.
- Develop and recommend policies and procedures related to assigned operations
- Advocate on behalf of the department for change and process improvement.
- Identify new technology solutions to manage the workload of the department.
- Monitor the effectiveness of existing systems and procedures and make and implement recommendations for change.
- Work weekends, evenings or standby, as required.
- Maintain confidentiality as necessary.
- Communicate clearly and concisely, both orally and in writing.
- Establish and maintain effective working relationships with those contacted in the course of work.
- Independently perform professional work in support of business analysis.
- Analyze, design, program, install and maintain highly technical and complex programs.
- Analyze data and develop logical solutions to complex business systems application programming problems; implement computer systems.
- Develop and manage projects related to business systems applications, including establishing and maintaining schedules.
EXPERIENCE AND TRAINING
Experience:
Two years of responsible experience performing duties similar to that of a Business Systems Analyst I with the City of Roseville (To perform professional level work in the analysis, design, programming, testing, installation and maintenance of business applications systems and databases.)
AND
Training:
A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems, business management, accounting, business information systems, finance or a related field is desirable. Two years of relevant work experience may be substituted for two years of the required education.
License or Certificate:
Possession of a valid California driver’s license upon date of appointment by date of appointment.
SUPPLEMENTAL QUESTIONNAIRE
1. Your responses to questions 2-4, the applicant’s education, training and experience, will be scored using a pre-determined formula. Your responses to these questions must be consistent with your employment application information. This experience must also be described in the “Work Experience" section of this application. Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored. I understand and agree with the above instructions.
2. Was any of the work experience listed on your application an unpaid internship, or volunteer work? If so, please list below which ones.
3. How many years of experience do you have performing professional level work in the analysis, design, programming, testing, installation and/or maintenance of business applications systems and databases.
- Less than 1 years
- 1-2 Years
- 2-3 Years
- 3-4 Years
- 4+ Years
4. Please list your completed education from an accredited college or university. List the degree, major and institution.
5. Please describe a critical business system that you’ve supported, your role, your key responsibilities, the line of business, and the number of end-users.
6. Describe your knowledge and/or experience managing or overseeing the implementation of a new initiative or special project. Include your experience assessing project goals, setting deadlines, coordinating with stakeholders, and meeting project deliverables. Please describe your primary role, duties, and decision-making authority.
7. Describe your experience as a Project Manager for technology related projects. Include tasks performed, years of experience, and approximate number and types of projects managed.
SELECTION PROCESS
All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination. The applicant’s experience and education will be evaluated using a pre-determined formula. Scores from this evaluation will determine applicant ranking and placement on the Employment List. Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations. Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.
THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER. IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS. MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.
