IT Business Intelligence Developer I/II

Salary : $66,401.00 - $89,365.00 Annually

Location : Visalia, CA

Job Type : Full-Time

Job Number : 24-015920

Department : Information Technology

Opening Date : 02 / 22 / 2025

Closing Date : 3 / 7 / 2025 11 : 59 PM Pacific

This recruitment will establish an employment list to fill current and any future vacancies for those County departments that have this position, which are the District Attorney, and Tulare County Information and Communications Technology Departments. The anticipated life of the employment list is six months. If interested in employment for this position for current or future vacancies within these departments, please submit an online application for consideration.

Current vacancy is with the Tulare County Information and Communications Technology Department (TCICT) located in Visalia.

Typical Duties

Work under supervision with end users and management from all County departments and other IT Business Intelligence Developers to analyze business intelligence needs. This analysis is used to provide current and predictive views of business operations; responsible for gathering, analyzing, interpreting data, testing, validating and communicating relevant results by collaborating with end user clients; produce reports with tools such as Microsoft SQL Reporting Tools (SSRS), Microsoft Power BI, SAP Crystal Reports for Enterprise, and / or SAP Web Intelligence; work under supervision with end users, other County department staff, and IT staff to analyze business intelligence needs; develop, document, and support standardized and / or customized reports from the customer's information database producing results in various forms such as : Analytic and operational reports, graphs, and charts to help optimize operational processes, generate revenue, and predict future business results; produce reports with tools such as SAP Crystal Reports, SAP Crystal Reports for Enterprise, SAP Web Intelligence, and / or Microsoft SQL Reporting Tools (SSRS); understands different data models like normalized, de-normalized, stars, and snowflake models; perform daily and weekly processes to insure updates to databases, delivery of reports to outside agencies, and updates to the BI Platform; e ssential job duties may be assigned that are not listed above but are relative to this job classification. (Reasonable accommodation will be made when requested and determined by the County to be appropriate under applicable law.)

Minimum Qualifications

MINIMUM QUALIFICATIONS

Minimum qualifications are used as a guide for establishing the education, training, experience, special skills and / or license which are required and equivalent to the following.

Education : Education equivalent to a Bachelor's degree from an accredited college or university with a major in Business Intelligence, Geographic Information Systems, or other Computer Sciences.

Education Equivalency : Business Intelligence related experience may be substituted for the educational requirement on a year-for-year basis if applicable.

Experience : Level I : One (1) year of direct experience in report writing using tools such as : SSRS, PowerBI, SAP Crystal Report Writer, SAP Webi, Microsoft Report Builder, and writing SQL queries; working knowledge of data extraction and analysis. Level II : Two (2) years of direct experience in report writing using tools such as : SSRS, PowerBI, SAP Crystal Report Writer, SAP Webi, Microsoft Report Builder, and writing SQL queries. Working knowledge of data extraction and analysis. One year working experience with designing dashboards using tools such as SAP Dashboard Designer, Tableau, etc. One year working experience with Universe Design.

Knowledge of : Principles and practices in business intelligence including data organization, statistical and planning analysis; organizational and management analysis methods; principles, capabilities, and limitations of information and communication technology systems; management information systems or information technology terminology; math to perform statistical analysis of data gathered; research and report writing methods.

Skill / Ability to : Work and communicate effectively with people of various education and socioeconomic backgrounds by respecting beliefs, interpersonal styles and behaviors of both clients and co-workers; operate contemporary office equipment inclusive of computer, keyboard, and all applicable electronic equipment; apply the principles and techniques of data analysis, administration and management analysis to the gathering, organizing and interpretation of data; write queries from various data sources such Microsoft SQL, Oracle, Cache, Informix, etc; strong analytical and quantitative skills; solve problems and pay close attention to details; focus on multiple projects simultaneously while meeting schedules and deadlines; ability to act positively and efficiently under pressure; prepare clear, concise reports, instructions and procedures using correct grammar, punctuation and spelling; maintain effective working relationships with co-workers, other departments, state agencies, and outside organizations; adjust to changes in work assignments; retain and recall factual information; provide excellent customer service and interpersonal communication skills.

License or Certificate : Possession of, or ability to obtain, an appropriate, valid California driver's license.

DESIRABLE EMPLOYMENT STANDARDS

Experience with SAP Enterprise Suite including Crystal Reports, Business Objects, etc.; experience with Microsoft SQL Server Reporting Services (SSRS); ability to write SQL queries using TOAD or PLSQL; Certified Business Intelligence Professional (CBIP)

Additional Information

Conditions of Employment : Possession of, or ability to obtain, an appropriate, valid California driver's license. Candidates selected may be required to pass a pre-employment drug and alcohol screening. Additionally, a background investigation will be conducted. Some job classes may also require a physical exam.

College Cost Reduction Access Act

This may a qualifying position for student loan forgiveness through the College Cost Reduction and Access Act (CCRAA). Only student loan payments made after October 1, 2007 and in a qualified repayment plan are eligible. For more information you are encouraged to speak with your student loan servicer or visit : h

EQUAL OPPORTUNITY EMPLOYER

Bargaining Unit 7

The information listed is a general summary of benefits. These provisions do not constitute an expressed or implied contract and are subject to change.

Benefit Amount : An annual benefit amount is provided and may be applied towards health insurance premiums (medical, dental, vision and life). This benefit is pro-rated and paid on a pay period basis (24 pay periods).

Health Insurance : A choice of PPO and HMO medical plans which include PPO and HMO dental plans and include dental and vision coverage. Dependent coverage is available. Providers include Anthem Blue Cross, Kaiser Permanente, Delta Dental, and Vision Services Plan (VSP) .

Retirement : The retirement plan is a defined benefit plan administered pursuant to the 1937 Act County Employees Retirement Act and integrated with Social Security. In addition to ordinary retirement benefits, the plan provides disability and death benefits. Retirement contributions are made by both the County and the employee. The County has reciprocity with the State of California, contracting PERS agencies, and all County 1937 Act Retirement Systems.

Paid Holiday Leave : 12 set days and 1 personal holiday .

Vacation Accrual :

2 weeks per year (0-3 years of service)

3 weeks per year (3-7 years of service)

4 weeks per year (7-11 years of service)

5 weeks per year (11 years of service)

Limit of 300 hours.

FLSA exempt employees accrue an additional 5 days of vacation per year.

Sick Leave Accrual : 12 days per year with unlimited accumulation, 60 hours of which may be used toward family sick leave.

Group Term Life Insurance and AD&D : $10,000; Provided by Standard Insurance Company .

Disability Insurance : Employees are covered by State Disability Insurance. The premium is paid by the employee.

Deferred Compensation : A voluntary deferred compensation plan is available.

To view more detailed descriptions of Tulare County's benefits, please view the Benefits section of our Web site at

The Provisions Of This Bulletin Do Not Constitute An Expressed Or Implied Contract And Are Subject To Change.

Describe your experience with relational databases, schemas and data dictionaries. Please include database types and versions, benefits of schemas and data dictionaries.

Describe your experience with report design and the tools used to design reports

Describe your experience working with SQL queries. Please include SQL language.

Describe your experience with extraction and analysis of data. Include tools used, format and intended audience.

The following questions measures desirable employment standards for the IT Business Intelligence Analyst I / II position. It is not necessary to answer these questions; however those that do may be considered more qualified and may be given first consideration Describe any experience you may have with determining business Key Performance Indicators (KPI's).

Describe your experience, if any, with any local government. Include departments and applications.

Do you possess a CRCP (Crystal Report Certification Professional) Certificate?

Do you have experience designing reports or dashboards using the following (check all that apply

• Crystal Reports
• Deski
• Webi
• MS Access
• MS Report Writer
• Monarch
• Tableau
• MS Power Builder
• Other Software

Required Question

Salary : $66,401 - $89,365