IT Business Analyst II

Applications will be accepted until there are a sufficient number of highly qualified applicants from which to make a selection. Candidates should submit their materials online as soon as possible to ensure consideration. However, interviews may be conducted throughout the recruitment process and this opening may close at any time. Applicants must attach any required certifications/licenses to the application.

This recruitment is for the IT Business Analyst II level.

$111,113.60 – $148,907.20 Annually

Hybrid remote/office schedule may be available after passing the introductory period.

DEFINITION

Under general supervision, performs a variety of professional level information systems work including analyzing business processes and identifying user needs; designing, coding, installing, and testing of software applications and interfaces; performing database maintenance; and related duties as required.

CLASS CHARACTERISTICS

IT Business Analyst I is the entry level position in this series, performing routine programming and project planning in support of District software applications. 

IT Business Analyst II is the experienced level non-supervisory class, responsible for the maintenance, support, and integration of District software applications, including financial, human resources, payroll, billing, and computer maintenance management systems and other business applications. It is distinguished from the Information Technology Supervisor, which oversees all functions of the department.

SUPERVISION EXERCISED AND RECEIVED

This position is supervised by the Chief Technology Officer and does not supervise any staff. At the II level, may provide training and guidance to IT Business Analyst I.

Essential Functions

Essential functions include, but are not limited to, the following:

• Performs system analysis and design, including reviewing, documenting, and mapping business processes and system requirements; interviews users to determine system needs; recommends work process and/or operating changes to complement system functionalities; consults with managers on system and technology alternatives capable of addressing and resolving business needs; works directly with internal staff and vendors to coordinate technological integration between software and database systems;
• Maintains, administers, optimizes, enhances, and provides support for District business systems, including financial systems, human resources systems, computer maintenance management systems (CMMS), billing systems, and other computer applications used to assist District personnel; coding and scripting routines for business systems applications; tests and evaluates business systems functionality;
• Consults with end users to determine reporting needs; develops end user reports querying data from business systems; plans and analyzes system changes, including determining impact of existing systems and processes; coordinates and effectively guides cross-functional project teams, including managing objectives, timelines, and budget;
• Creates application and database test environments and performs application software upgrades and conversions; plans and prepares integration of new and upgraded technology; installs, updates, maintains, configures, tests, and secures software, peripherals and related equipment;
• Contributes to development of long-term plans, goals, and objectives to achieve District and department technology and business priorities; provides input for the annual budget; develops and recommends policies, systems, and procedures applicable to areas of assigned responsibilities;
• Writes program code, using appropriate software development tools and programming languages; tests and installs fixes to correct errors and optimize program performance; prepares and updates user manuals and documentation, training materials, and user guides;
• Trains users on business systems and interfaces; develops user program and interface documentation; responds to user requests and provides solutions to operational issues where applicable;
• Maintains, optimizes, enhances, and administers District’s database management systems; supports database applications; writes coding and scripting routines for database applications; develops procedures to ensure optimum stability, integrity, access, and response of the business systems applications;
• Participates in maintaining the District’s web-based systems; supports web-based applications; coding and scripting routines for web-based applications;
• Operates copiers and a variety of office equipment;
• Performs duties in a professional manner and works well with others or in a team setting;
• Establish and maintain cooperative working relationships with co-workers, outside agencies, and the public;
• Regular attendance and adherence to prescribed work schedule to conduct job responsibilities; may work outside of regular work hours as necessary, including weekends for system maintenance or emergency situations;
• Observes safe work practices and safety methods; performs other duties as assigned.

Typical Qualifications

Ideal Candidate Traits

• Extensive knowledge and experience with SQL, including JavaScript/PowerShell scripting
• Strong written and verbal communication skills, collaborative mindset
• Has project management experience and has led cross-functional teams in the workplace
• Capable and experienced in data analytics
• Eager to learn District programs and be our next reliable subject matter expert

Knowledge, Skills, and Abilities

Knowledge of:

• Principles and methods of system analysis and design, including business processes, methods and database administration; 
• Coding and scripting routines for business systems applications, including SQL database design, theory and methods; object-oriented methodology;
• Javascript and Powershell scripting and SQL programming; scripting; XML; SSRS;
• Joint Application Development (JAD) and Joint Requirements Planning;
• Financial, Payroll and HR software applications;
• Customer Service and billing applications;
• Computer Maintenance Management Systems.
• Configuration Management
• Business Intelligence & Reporting platforms (e.g., Power BI, SSRS)
• Data visualization techniques, and best practices for data-driven decision making

Ability to:

• Understand and apply the analysis of functional requirements to the development of systems proposals, program enhancements and recommendations to improve business systems;
• Read, interpret, explain and apply technical information on business processes, software and hardware for technical and non-technical users;
• Analyze user interviews to develop strategies and recommendations for improved system processes; clearly report findings and suggestions to management;
• Develop improved processes and procedures related to data management systems and business systems applications; create and test changes within the applications; manage upgrades for minimal disruption of business;
• Meet deadlines and handle multiple projects and priorities with minimal supervision to ensure timely, high quality results; evaluate alternatives and make independent decisions within established guidelines;
• Create technical documentation; write and execute test cases;
• Communicate clearly and effectively to diverse audiences of technical and non-technical staff orally and in writing.
• Lead and manage project teams.

Education & Experience

Any combination of education or experience that would likely provide the necessary knowledge and abilities is qualifying. A typical way to obtain these knowledge and abilities would be: 

• IT Business Analyst I: two years of professional level experience in business systems analysis, design, development, and programming is required. An associate’s degree in computer science or related field highly preferred.
• IT Business Analyst II:f our years of professional experience in business systems design, development, and programming is required. A bachelor’s degree in computer science, information systems, or a related field highly preferred.

Licenses, Certificates, and Special Requirements

• Microsoft certification, preferably SQL, desired.