Address
Form of workSalary : $66,331.20 - $92,684.80 Annually
Location : Idaho Falls, ID
Job Type: Full-Time
Job Number: 2023-1011
Department: Municipal Services
Division: Information Technology
Opening Date: 10/11/2023
Closing Date: Continuous
General Purpose
The City of Idaho Falls is accepting applications for a Business Intelligence Analyst I or II depending on years of experience and education.
This position is responsible for many complex technical duties related to the day-to-day operations of the city's ERP software and associated reporting. Installation and maintenance of City Information Technology systems and operations; including, software deployment, database maintenance, and reporting tools. This position may be required to take scheduled on-call for the city IT help desk rotating schedule.
Hiring Manager and the Human Resources Office will evaluate candidate experience/education to determine which level of pay candidate falls into:
Level I pay range = $31.89 - $44.56
Level II pay range = $39.02 - $54.52
Essential Functions
Provide an outstanding level of IT customer service to City Departments and consultants both with call-in, email, and on-site support.
Maintain and support city database operations including ERP software and reporting tools.
Develop and execute database queries and conduct analyses.
Evaluate and improve existing BI systems.
Create visualizations and reports for requested projects.
Gather feedback from end users about system performance and implement changes as necessary.
Collaborate with teams to integrate systems.
Coordinate developers to build and implement technology solutions.
Assists in maintaining City Server and related equipment and software.
Develop and update technical documentation.
Trains City users in PC hardware and software and related functions through business critical applications, networking, PowerPoint presentations and other related training activities.
May be required to provide after hours on-call support when needed for systems maintenance and/or system outages.
Work with web API's and services.
Performs other duties as assigned.
Minimum Qualifications
1. Education and Experience:
Level I
A. Completion of two (2) years of technical college studies in computer science, computer programming, or related fields; AND B. Four (4) years of progressively responsible experience in database operations; OR C. An equivalent combination of education and experience.
Level II
A. Completion of a bachelor's degree in computer science, computer programming, or related field. Completion of information technology professional certifications in the area of Microsoft, SQL, database management and networking can be credit towards the bachelor's degree; AND B. Five (5) years of progressively responsible governmental experience in database operations and programming; OR C. An equivalent combination of education and experience.
2. Knowledge, Skills, and Abilities:
Database querying and report writing. Networking (LAN/VLAN) system management concepts; information system management concepts; hardware configurations and capabilities; operating system fundamentals; data communication concepts; NetWare/Windows Servers systems, PC operating systems, applications and programs, networking documentation procedures; technical writing. Some knowledge of telecommunication equipment technology; system networking procedures and typical maintenance processes; various types of inter-related equipment, specifications and compatibilities; system programming requirements and software contingencies.
Ability to communicate effectively, verbally and in writing; make decisions where established procedures do not always apply; perform complex analytical functions; keep sensitive information confidential; operate personal computer and apply various program applications related to word processing, spread sheets and presentations; develop effective working governmental administrators, programmers, and system maintenance personnel; effectively manage workplace stress related to time deadlines, work pace demands, shifting priorities, and rapid changes within the information technologies industry; learn new systems as they are deployed.
3. Special Qualifications:
Fingerprint and law enforcement background check will be required of final candidate.
Microsoft SQL DBA certification.
IBM Cognos report writing experience.
IBM iSeries knowledge and RPG programing is desirable.
Work Environment
Incumbent of the position performs in a typical office setting with appropriate climate controls. Tasks require variety of physical activities, not generally involving muscular strain, such as walking, standing, stooping, sitting, reaching, and lifting. Common eye, hand, finger dexterity required. Mental application utilizes memory for details, verbal instructions, emotional stability, discriminating thinking and creative problem solving. Periodic domestic and international travel required in normal course of job performance.
The City of Idaho Falls offers a highly competitive benefits package including membership in the Public Employee Retirement System of Idaho, vacation, holiday, and sick leave as well as medical, dental, vision and life insurance. For further information regarding City of Idaho Falls benefits, visit the Benefits section of our web page.
Temporary jobs and part-time positions that regularly work less than 20 hours per week typically do not qualify for benefits.
01
What best describes your level of education?
02
Select the option that best describes your years of related work experience. Make sure your answer is supported in the Employment History section of the job application.
03
What best describes your years of report writing?
04
Please briefly describe the report writing experience you have.
05
Have you worked with an IBM iSeries?
06
If you have worked with IBM iSeries before, please briefly describe your experience.
07
Have you worked with Cognos BI?
08
If you have worked with Cognos BI, please briefly describe your experience.
Required Question
Location : Idaho Falls, ID
Job Type: Full-Time
Job Number: 2023-1011
Department: Municipal Services
Division: Information Technology
Opening Date: 10/11/2023
Closing Date: Continuous
General Purpose
The City of Idaho Falls is accepting applications for a Business Intelligence Analyst I or II depending on years of experience and education.
This position is responsible for many complex technical duties related to the day-to-day operations of the city's ERP software and associated reporting. Installation and maintenance of City Information Technology systems and operations; including, software deployment, database maintenance, and reporting tools. This position may be required to take scheduled on-call for the city IT help desk rotating schedule.
Hiring Manager and the Human Resources Office will evaluate candidate experience/education to determine which level of pay candidate falls into:
Level I pay range = $31.89 - $44.56
Level II pay range = $39.02 - $54.52
Essential Functions
Provide an outstanding level of IT customer service to City Departments and consultants both with call-in, email, and on-site support.
Maintain and support city database operations including ERP software and reporting tools.
Develop and execute database queries and conduct analyses.
Evaluate and improve existing BI systems.
Create visualizations and reports for requested projects.
Gather feedback from end users about system performance and implement changes as necessary.
Collaborate with teams to integrate systems.
Coordinate developers to build and implement technology solutions.
Assists in maintaining City Server and related equipment and software.
Develop and update technical documentation.
Trains City users in PC hardware and software and related functions through business critical applications, networking, PowerPoint presentations and other related training activities.
May be required to provide after hours on-call support when needed for systems maintenance and/or system outages.
Work with web API's and services.
Performs other duties as assigned.
Minimum Qualifications
1. Education and Experience:
Level I
A. Completion of two (2) years of technical college studies in computer science, computer programming, or related fields; AND B. Four (4) years of progressively responsible experience in database operations; OR C. An equivalent combination of education and experience.
Level II
A. Completion of a bachelor's degree in computer science, computer programming, or related field. Completion of information technology professional certifications in the area of Microsoft, SQL, database management and networking can be credit towards the bachelor's degree; AND B. Five (5) years of progressively responsible governmental experience in database operations and programming; OR C. An equivalent combination of education and experience.
2. Knowledge, Skills, and Abilities:
Database querying and report writing. Networking (LAN/VLAN) system management concepts; information system management concepts; hardware configurations and capabilities; operating system fundamentals; data communication concepts; NetWare/Windows Servers systems, PC operating systems, applications and programs, networking documentation procedures; technical writing. Some knowledge of telecommunication equipment technology; system networking procedures and typical maintenance processes; various types of inter-related equipment, specifications and compatibilities; system programming requirements and software contingencies.
Ability to communicate effectively, verbally and in writing; make decisions where established procedures do not always apply; perform complex analytical functions; keep sensitive information confidential; operate personal computer and apply various program applications related to word processing, spread sheets and presentations; develop effective working governmental administrators, programmers, and system maintenance personnel; effectively manage workplace stress related to time deadlines, work pace demands, shifting priorities, and rapid changes within the information technologies industry; learn new systems as they are deployed.
3. Special Qualifications:
Fingerprint and law enforcement background check will be required of final candidate.
Microsoft SQL DBA certification.
IBM Cognos report writing experience.
IBM iSeries knowledge and RPG programing is desirable.
Work Environment
Incumbent of the position performs in a typical office setting with appropriate climate controls. Tasks require variety of physical activities, not generally involving muscular strain, such as walking, standing, stooping, sitting, reaching, and lifting. Common eye, hand, finger dexterity required. Mental application utilizes memory for details, verbal instructions, emotional stability, discriminating thinking and creative problem solving. Periodic domestic and international travel required in normal course of job performance.
The City of Idaho Falls offers a highly competitive benefits package including membership in the Public Employee Retirement System of Idaho, vacation, holiday, and sick leave as well as medical, dental, vision and life insurance. For further information regarding City of Idaho Falls benefits, visit the Benefits section of our web page.
Temporary jobs and part-time positions that regularly work less than 20 hours per week typically do not qualify for benefits.
01
What best describes your level of education?
- Some High School
- High School Diploma or GED
- Some College/Vocational Training
- Associate's Degree
- Bachelor's Degree
- Master's Degree or Higher
02
Select the option that best describes your years of related work experience. Make sure your answer is supported in the Employment History section of the job application.
- None
- 1-23 Months
- 2-3 Years
- 4-5 Years
- 6-7 Years
- 8-9 Years
- 10 Years or More
03
What best describes your years of report writing?
- Less than 1 year
- 1 to 2 years
- 3 to 4 years
- 5 or more years
04
Please briefly describe the report writing experience you have.
05
Have you worked with an IBM iSeries?
- Yes
- No
06
If you have worked with IBM iSeries before, please briefly describe your experience.
07
Have you worked with Cognos BI?
- Yes
- No
08
If you have worked with Cognos BI, please briefly describe your experience.
Required Question
