Associate Data Analytics and Report Developer

Job Description and Duties

THIS POSITION MAY BE ELIGIBLE FOR A HYBRID WORK SCHEDULE. THE AMOUNT OF TELEWORK IS AT THE DISCRETION OF THE DEPARTMENT AND IS SUBJECT TO CHANGE AS BUSINESS NEEDS ARISE.

Are you interested in making a difference in the lives of fellow Californians while achieving your career goals? Are you looking for a fast-paced and challenging position that will provide you with extremely valuable information technology experience, extensive variety, and frequent exposure to managers and staff in the Information Technology Branch? If you desire to work in a customer service-oriented team environment, surrounded by enthusiastic and self-motivated people, then look no further!

Join our BI Data Analytics and Reporting team as an Information Technology Associate and help deliver reliable, secure, and innovative technology solutions that support Californians.

Why join us?

• Meaningful work that serves the people of California.
• Opportunities for career growth and advancement within the state's IT classifications.
• Work-life balance, including hybrid or remote work options, when available.
• A culture that encourages learning, collaboration, and professional development.

We're looking for someone who

• Enjoys solving technical problems.
• Communicates effectively with technical and non-technical audiences.
• Is eager to learn new technologies and expand their skills.
• Works well independently and as part of a team.
• Is committed to providing excellent customer service.
  

This position may be eligible for a hybrid work schedule. The amount of telework is at the discretion of the Department and is subject to change as business needs arise. Employees are required to report to their headquarters office on their assigned in-office days. Travel expenses to and from the assigned headquarters are the responsibility of the employee.

This position is located at 1416 9th street in the heart of downtown Sacramento. Benefits of working at this location include:

• Benefits of working at this brand new location include:
• Fitness center with showers
• Secure bike storage
• Work café with micro market
• Two private outdoor courtyards for employees
• 100% cost coverage of public transit including light rail, bus, or licensed public conveyance.
• Close to major freeways, light rail, and transit stops
• Close to downtown shopping and restaurants
• Close to the Golden 1 Center and Sutter Health Park

Effective July 1, 2025, specific Bargaining Units and associated Excluded State employees are subject to a salary reduction between 2% - 4.62% in exchange for hours in the Personal Leave Program 2025 (PLP 2025) per month. For more details, please click here to visit the California Department of Human Resources (CalHR) website.

You will find additional information about the job in the .

Working Conditions

Visa Sponsorship
This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment.

Standard Office Environment

Special Requirements

It is strongly encouraged to apply through your CalCareer Account at .

Please only submit ONE application. Electronic applications submitted through your CalCareer Account are highly recommended and will be received/processed faster than other methods of filing.

If you are unable to apply electronically through your CalCareer account, please mail a completed and signed State Examination/Employment Application STD Form 678 and application package to the mailing address provided in the “Application Instructions’ section below and ensure the following:

• Clearly indicate the Job Code #, Position Number and the Classification Title of this position in the “Examination or Job Title(s) For Which You Are Applying” section located on Page 3 of your State Examination/Employment STD Form 678.

• Clearly indicate the basis of your eligibility (list, transfer, reinstatement, etc.) in the “Explanations” section located on Page 3 of your State Examination/Employment Application STD Form 678.

• Remove and do not submit the “Equal Employment Opportunity” questionnaire (Page 10) with your completed State Examination/Employment Application STD Form 678. This page is for examination use only.

• Do not include your full Social Security Number on your documents and/or do not provide any LEAP information.

Examination/Assessment 

If selected for hire , you must obtain list eligibility by taking and passing the examination. If you already have list eligibility for this classification, you do not need to retake the examination unless your list eligibility has expired.

Click the examination link below for more information and to take the exam:

For more information about the State hiring process, click here . To watch tutorials on how to apply for a State job, click here .

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:

The ideal candidate demonstrates the ability to:

• Communicate effectively with technical and business stakeholders.
• Analyze problems, identify practical solutions, and manage multiple priorities.
• Exercise initiative and work both independently and collaboratively.
• Build and maintain effective working relationships.
• Knowledge of and/or experience in one or more of the following areas is desirable:
• Business intelligence (BI) reporting and analytics using Tableau or similar visualization tools.
• Snowflake or other relational database platforms.
• Database design, data modeling, and data integration.
• SQL development, including joins, stored procedures, and database functions.
• Python programming or scripting.
• API development and support.
• Public, private, or hybrid cloud environments.
• Supporting enterprise reporting and data analytics initiatives.
• Supporting the development and maintenance of data marts and data warehouse solutions.
• Data analysis, data quality, and emerging data platform technologies.

Benefits

Benefit information can be found on the CalHR website, , and the CalPERS website, .

Statement of Qualifications Requirements

A Statement of Qualifications (SOQ) is Required.  The SOQ will be considered the first phase of the hiring process for this position. If your qualifications are competitive, you will be invited to an interview. The SOQ should be typed and not more than two pages in length, not less than 12-point font, single-spaced, with margins not less than one inch, including your first and last name at the top of the page.

1. Describe your knowledge, skills and experience in Data analysis for this postion.
2. Describe your knowledge, skills and experience in SQL and Snowflake, SSRS and Tableau.
3. Describe your knowledge, skills and experience in Customer interaction and requirement analysis.

Résumés and/or cover letters DO NOT take the place of the SOQ. Applications received without an SOQ or SOQs that do not include a response to all statements above may not receive further consideration and may be excluded from the hiring process.

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 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 -
  A  Cover Letter is required and must be included.
• Statement of Qualifications -
  A Statement of Qualifications (SOQ) is Required.  Please see “Statement of Qualifications Requirements” section for more information about the SOQ.