Job Posting: Analytics Data Modeler

Department of Water Resources

JC-474793
-
Analytics Data Modeler
INFORMATION TECHNOLOGY ASSOCIATE

$4,791.00 - $8,485.00 per Month

Final Filing Date: 5/8/2025

Job Description and Duties

Department of Water Resources (DWR) is recruiting for a talented, enthusiastic, and motivated individual to join its SAP Analytic Reporting unit as an Enterprise Analytics Data Modeler/Reports developer. The individual will join one of the most talented and progressive IT shops in CA state government and work with the DWR team to support the Department’s SAP Enterprise Resource Planning (ERP) analytics and reporting needs in a state-of-the-art technology environment. If you’re up for the challenge, apply within and tell us more about yourself!

You will find additional information about the job in the Duty Statement.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-474793
Position #(s):
840-530-1401-011
Working Title:
Analytics Data Modeler
Classification:
INFORMATION TECHNOLOGY ASSOCIATE
$4,791.00 - $6,421.00 A
$5,266.00 - $7,058.00 B
$5,757.00 - $7,716.00 C
$6,331.00 - $8,485.00 D
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time

Department Information

Division of Technology Services, SAP Functional and Analytic Reporting Services, Sacramento

Department of Water Resources (DWR) was established in 1956 by the California State Legislature.  We manage California’s water resources, systems, and infrastructure, including the State Water Project, in a responsible sustainable way.

At DWR, we are embedding climate change response into every project we undertake. We have set standards to help evaluate how each project incorporates climate resilience principles and ensure consistency across the Department.  Our mission is to sustainably manage the water resources of California, in cooperation with other agencies, to benefit the state’s people and protect, restore, and enhance the natural and human environments.

DWR also strives to create a trusting and welcoming workplace where employees embrace diverse viewpoints and treat each other with civility and respect.  An important component of DWR’s equal employment opportunity program centers around justice, equity, diversity, and inclusion.

Department Website: https://water.ca.gov

Free virtual career consultation services including one-on-one DWR career consultations, application/resume review, tips for applying, and mock interviews, provided by DWR’s Recruitment and Workforce Planning section can now be scheduled via https://water.ca.gov/About/Careers.

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: 5/8/2025

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP 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.

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 Water Resources
Mailing Address
Attn: Division of Human Resources
P.O. Box 1079
Sacramento, CA 95812

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Department of Water Resources
Submit in Person
Certification Desk
715 P Street, 7th floor
Sacramento, CA 95814
08:00 AM - 04:30 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.
  • Supplemental Application - See Supplemental Questionnaire information under Special Instructions below.
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:

  • Experience or knowledge of any of the following:
    • SAP, ERP, or other mission critical, enterprise scale applications
    • ABAP, SQL, or OOP languages
    • SAP Business Objects or other BI reporting tools
    • SAP HANA database environment and design tools
  • Creative thinker with a demonstrated history of applying excellent analytical, communication, and leadership skills to solving complex problems
  • Ability to effectively complete competing workloads and projects in a timely manner.

Benefits

Click here to read about the outstanding benefits offered to eligible employees.

Contact Information

The Hiring Unit Contact is available to answer questions regarding the position or application process.

Hiring Unit Contact:
Tina Tran
(916) 801-2351
Tina.tran@water.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:
Office of Civil Rights
(916) 653-6952
weo@water.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.

Special Instructions

To be considered, submit a completed State application (STD. 678), Resume, and Supplemental Questionnaire. Please reference SAP Position #50000548 and Job Control #474793 in the “examination(s) or job title(s) for which you are applying” section of your application.

 

The submitted Supplemental Questionnaire information must be one (1) page (12-point Arial font):

 

1. Based on the duty statement and desirable qualifications, why do you believe

you are the best candidate for this position?

2. What is your approach when faced with a challenging technical problem you haven't encountered before?

 

The follow basis of eligibility will be considered:  List eligibility, transfer, reinstatement, and SROA/Surplus.

 

Resumes, cover letters, and/or other attachments will not be accepted in lieu of a completed application.

 

Click here to complete DWR’s Recruitment Survey. This survey is for research purpose only and will not affect the application status.

Examination/Assessment

For more information about the State hiring process, click here. To learn more about how to get a State job, click here.

 

List eligibility can be established by taking and passing the examination/assessment.

 

Click the examination(s)/assessment(s) information link: INFORMATION TECHNOLOGY ASSOCIATE

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.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail
Drop-off
Print Job