Data Analyst

Duties: Under the direct supervision of the Research Data Supervisor I, the incumbent provides research, data gathering, and statistical work in the areas of program and project management reporting, fiscal reporting, and resource balancing, utilizing structured and unstructured data from existing reports and resources. Incumbent will use proven techniques and methods in the researching process to propose solutions to support the Division of Engineering's (DOE) Program Control Section (PCS) in project tracking, document management, and procedures through analysis and working with subject matter experts (SME) within DOE, PCS, or others. Incumbent will research and develop dashboards, functional reports, and visuals in Power BI in order to assist DOE staff in decision making. Incumbent will perform technical research and statistical work involving various types of data. Incumbent will support DOE managers in maintaining data in the Portfolio and Project Management/Resource Management (PPM/RM) system. Incumbent will perform exploratory research, data manipulation, and data ingesting in various database software and platforms, including R, Python, and SQL Server Management Studio., The Department of Water Resources is committed to its mission and employees, and we are grounded in our commitment to public safety. Regular, consistent, and predictable attendance is essential to the successful performance in this position.

Diversity, Equity, and Inclusion All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.

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: 4/10/2026

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., 1. Please detail your history and experience using a financial system (SAP, Epicor, NetSuite, etc.). Feel free to detail modules used, processes performed, and data captured.

2. Please explain your experience using Power BI. List any dashboards, reports, and visuals you have created. Explain any additional functions you have performed, if any.

Resumes, cover letters, and/or other attachments will not be accepted in lieu of a completed application. Failure to provide requested documents and information may result in automatic disqualification from the hiring process.

The following basis of eligibility will be considered: List eligibility, transfer, LEAP, reinstatement, SROA/Surplus, and training and development assignment.

We are looking for someone who is self-motivated, able to work in a collaborative setting, has effective communication skills, and is willing to take on new and special assignments related to financial information and data., 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:

Foundational knowledge of financial concepts, terms, and experience working with a financial system. Experience in research and data analysis. Experience and expertise in developing reporting, dashboards, and visuals in Power BI. Ability to compile and communicate on research findings to various customers within the organization. Experience preparing various reports using narratives, tables, charts, and/or dashboards. Working knowledge of database tools and software, including Python, R, and/or SQL Server Management Studio.

Why Choose Us: This position offers an exciting opportunity to work in the Department of Water Resources' (DWR) Division of Engineering's Program Control Section (PCS), which includes a team of professionals dedicated to supporting programs and partners in DWR that deliver a variety of large public civil-works projects related to water storage, water transportation, flood control, environmental protection, species conservation, habitat restoration, and recreation. Working for DWR is more than a job. It's a career full of experience, growth, and opportunity. At DWR, you will have the advantage of numerous resources to support your work and your professional growth-including training along with knowledgeable and professional colleagues all of which collaborate for project success. We hope you'll check out the Duties and Desirable Qualifications below and apply for this great career opportunity to join our team and help deliver water to over 26 million Californians as well as contribute to protecting our state's precious resources., 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, diversity, equity, and inclusion.