Address
Form of workThis 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.
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; essential 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 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)
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: https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service
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: https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service
EQUAL OPPORTUNITY EMPLOYER
