Business Intelligence Data Analyst

This position provides hybrid telework opportunities, with employees required to work in-person at least two days per week.
Under the direction of the Information Technology Manager I (ITM I), the Data Manager, the Information Technology Associate (ITA) assumes the role of Business Intelligence Data Analyst. The ITA is responsible for analyzing, developing, reviewing, implementing, documenting, and supporting Business Intelligence applications and data efforts for the statewide Learning Management System (LMS) Data Sharing and Reporting projects.
Additionally, the ITA is tasked with enhancing the Employee Core Record (ECR) and Learning Core Record (LCR) databases for statewide training data collection and management. As well as creating data and reporting architecture.
The ITA collaborates closely with departmental business stakeholders and other departments that share LMS data with CalHR. Responsibilities include defining data, reporting requirements, evaluating reporting solutions, implementing statewide reporting solutions, conducting data inventory, performing data quality analysis, coordinating data cleanup across agencies with SCO, executing Business Intelligence, and reporting implementation tasks.
You will find additional information about the job in the Duty Statement .
Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY ASSOCIATE

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC-417167
Position #(s):
363-175-1401-007
Working Title:
Business Intelligence Data Analyst
Classification:
INFORMATION TECHNOLOGY ASSOCIATE $4,792.00 - $6,420.00 L
$5,266.00 - $7,057.00 M
$5,757.00 - $7,716.00 N
$6,332.00 - $8,487.00 O
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Department Information The California Department of Human Resources (CalHR) is responsible for issues related to employee salaries and benefits, job classifications, civil rights, training, exams, recruitment and retention. For most employees, many of these matters are determined through the collective bargaining process managed by CalHR.
Our Vision: To be the premier leader and trusted partner in innovative human resources management.
Our Mission: To provide exceptional human resources leadership and services with integrity, respect and accountability to state departments and all current and prospective employees.
DEIA Statement: At CalHR we believe in the power of diversity. Diversity fuels the creativity and innovation necessary to serve our customers well. We are building a culture that values difference and fosters belonging. We strive to sustain a workforce reflective of the state we serve, and an environment that is safe, inclusive, and accessible for all individuals. We welcome everyone to contribute their talent, life experience, and expertise to drive CalHR forward.
Department Website: https://www.calhr.ca.gov
Special Requirements You must submit a Statement of Qualifications (SOQ). You need to provide direct responses to each of the numbered items. You must include the numbered item followed by your response. Include specific examples of your education, training, and/or experience. Limit your SOQ to two (2) pages, single-spaced, twelve-point Arial font.
1. Please provide a summary of your technical experience as a report writer and your experience with Structured Query Language (SQL).
2. Share your recent project and years of experience that qualifies you as a Business Intelligence Data Analyst.
3. Describe the most challenging aspect of being a Business Intelligence Analyst based on your experience?
Note: If you do not follow the instructions, you may not move forward in this recruitment. Cover letters and resumes do not take the place of the SOQ.
Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: 3/1/2024
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).
Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).
How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:
Address for Mailing Application Packages
You may submit your application and any applicable or required documents to:
Department of Human Resources
Attn: Human Resources Office - Lisa El Sao
1515 S Street, North Building, Suite 500
Sacramento , CA 95811-7258
Address for Drop-Off Application Packages
You may drop off your application and any applicable or required documents at:
Department of Human Resources
Human Resources Office - Lisa El Sao
1810 16th Street
Sacramento , CA 95811-7258
08:00 AM - 04:00 PM
Required Application Package Documents
The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
• Other - If you are basing your eligibility on education, provide your unofficial transcripts. If you are using foreign transcripts, you must provide a transcript evaluation. The transcript evaluation must state the number of units to which the foreign course work is equal. You will need to submit official transcripts at the offer stage. If you are not basing your eligibility on education, do not provide your unofficial transcripts. Select Choose/Upload for the required document. Then select Bypass File.
• Statement of Qualifications - You must submit a Statement of Qualifications (SOQ). See the Special Requirements section for instructions.

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.
Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

• Knowledge of data visualization best practices
• Knowledge of data warehousing concepts and technologies
• Knowledge of statistical analysis techniques for data interpretation
• Experience with Extract, Transform, Load (ETL) processes and tools
• Proficiency in writing complex Structured Query Language (SQL) queries
• Ability to create comprehensive data dictionary documentation
• Ability to communicate with technical and business stakeholders

Benefits Benefit information can be found on the CalHR website and the CalPERS website.
If you're passionate about business-changing experiences in an exciting, thriving state environment, CalHR is right for you. Join us at CalHR to provide human resources support to state departments. As you contribute your time, talent, and ideas, you'll see the impact you will make to thousands of state employees and fellow Californians.
We offer competitive, flexible opportunities:

• Hybrid telework
• Tax-advantaged savings and spending accounts
• Short-Term Disability Program available
• Employee Assistance Program
• Excellent health, dental and vision benefits for employee/employee's family 401k program
• Alternate Work Week Schedule options
• Ongoing training and development
• Convenient transportation options, including light-rail and pre-tax parking
• On-site ATM
• On-site Gym
• Shopping
• Nearby restaurants

CalHR employees are excluded from bargaining and are eligible to receive enhanced benefits, such as CoBen benefit allowance, employer paid life insurance, additional vacation/annual leave, and are not subject to State Disability Insurance payroll withholding.
Contact Information
The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.
Department Website: https://www.calhr.ca.gov
Human Resources Contact:
Lisa El Sao
(916) 909-2819
lisa.elsao@calhr.ca.gov
Hiring Unit Contact:
Bo Ching
(916) 926-0203
bo.ching@calhr.ca.gov
Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
RA Coordinators
(916) 322-5315
RACoordinators@calhr.ca.gov
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.
Additonal Application Information
When completing the State application, STD 678, you must include a description of the duties performed for each position held. You may not move forward in this recruitment if you write "See Resume."
Redact confidential information from all documents you submit for this position. Confidential information includes, but is not limited to:

• Social security number (CalCareers removes this from the first page of the State application, STD. 678, upon submission)
• Birthdate
• Student identification number
• Driver license number (unless required)
• Basis of eligibility
• Examination results
• LEAP status
• Marital status
• Age

You can apply in one of three ways:

• Online (preferred),
• U.S. mail, parcel deliver or courier service, or
• In person

We may fill additional positions from this recruitment.
Examination Information
We have a three-step guide to a state job.
You must pass an examination to become a state employee. State examinations measure your skills and experience. When you pass an examination, you become list eligible, which allows us to consider you for this appointment.
Before you start the examination:

• Review the sample questions in the examination bulletin.
• Have your resume handy. You will need it during the examination.

The examination starts with a series of questions. They confirm you meet the minimum qualifications.
Take the online Information Technology Associate exam to become list eligible for this position.
Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.
It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.