Job Posting: Report Developer

Department of Consumer Affairs

JC-530439
-
Report Developer
INFORMATION TECHNOLOGY SPECIALIST I

$6,513.00 - $10,537.00 per Month
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

Final Filing Date: 9/8/2026

Job Description and Duties

In all job functions, employees are responsible for creating an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences, and is free from discrimination. Employees are expected to provide all members of the public equitable services and treatment, collaborate with underserved communities and tribal governments, and work toward improving outcomes for all Californians. 

Please let us know how you heard about our position by taking this brief survey.


CalCareers Exams: Once you find the job you want, we need to learn more about you. We will evaluate your education, experience, abilities, and knowledge through an assessment. The assessment process can take many forms, including an interview or exam, depending on the job.

Link to ITS I Exam: CalCareers
 
Under the direction of the Enterprise Reporting & Analytics Information Technology Supervisor II (IT Sup II) and the Information Technology Manager I (ITM I), who oversees the team and establishes overall strategy, the Information Technology Specialist I (ITS I) develops complex SQL based, Cognos, Power BI, and Databricks reporting solutions that support the department’s enterprise business intelligence platforms. The incumbent serves as a technical specialist responsible for system programming, report development, and data engineering support. This position contributes to the modernization of the California Department of Consumer Affairs enterprise analytics environment by designing Power BI semantic models, building Databricks pipelines, and implementing optimized SQL integrations that enable scalable, governed, and reliable enterprise reporting. This position is in the System Engineering Domain. 


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

Working Conditions

Candidates who reside outside of the State of California may be admitted to the job interview. However, they must reside in the State of California once they are hired and start working.

Effective July 1, 2025, the State of California implemented the Personal Leave Program 2025 (PLP 2025) which reduces an employee's monthly salary in exchange for leave credits. Employees appointed to this classification will have their monthly salary reduced and will accrue hours of PLP 2025 on the first day of each pay period as outlined on "Section 2113 - Personal Leave Program (PLP)" of the CalHR Manual. The salary range(s) included on this job posting do not reflect the reduction in pay.

The incumbent is a Work Week Group E employee and is expected to work an average of 40 hours per week each year and may be required to work specified hours based on the business needs of the office. The incumbent must occasionally move about inside the office to access office machinery. The incumbent must constantly operate a computer and other office productivity machinery, such as a copy machine. The incumbent must be able to remain in a stationary position 50% of the time. The incumbent may be required to perform duties at local client sites as required and at any of DCA’s statewide field sites as scheduled in advance. The incumbent is required to travel throughout an assigned geographical area by various methods of transportation.

Additional info: *This position may/may not be eligible for telework. The amount of telework is at the discretion of the Office of Information Services (OIS) and based on the current telework policy. While the OIS supports telework where possible, in-person attendance may be required based on operational needs. Employees are expected to be able to report to their worksite with minimal notification if an urgent need arises, as determined by the Department.

 

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-530439
Position #(s):
610-710-1402-009
610-710-1402-XXX
Working Title:
Report Developer
Classification:
INFORMATION TECHNOLOGY SPECIALIST I
$6,513.00 - $8,729.00 A
$7,163.00 - $9,599.00 B
$7,864.00 - $10,537.00 C
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.
# of Positions:
Multiple
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Facility:
Office of Information Services

Department Information

The Department of Consumer Affairs (DCA) protects and serves California consumers while ensuring a competent and fair marketplace. DCA educates consumers and protects professionals from unfair competition by unlicensed practitioners.

DCA is a unique and dynamic department consisting of 36 different boards, bureaus, a commission, and a program that license and regulate more than 3.4 million licensees in more than 280 license types including certificates, registrations, and permits. DCA has many exciting career opportunities available and is dedicated to hiring and retaining qualified employees.

Find your way at DCA - Career Opportunities – Department of Consumer Affairs (DCA)

Are you a highly motivated employee who enjoys providing excellent customer service and is seeking a supportive team environment? Then the Department of Consumer Affairs (DCA) is the place you are searching for.  The mission of the DCA is to promote and protect the interests of California consumers.  The DCA’s Office of Information Services (OIS) supports clients who license and regulate various industries within the state of California. The OIS is recruiting for a highly motivated and enthusiastic employee with solid development skills and a commitment to continuous improvement.  A supportive team environment will welcome you.

The Department of Consumer Affairs (DCA) has many exciting career opportunities available and is dedicated to hiring and retaining qualified employees. DCA is committed to diversity, equity, inclusion, and accessibility in carrying out its consumer protection mission, and DCA solidifies this commitment starting with its recruitment efforts. DCA enriches its diversity through a workforce that reflects the population it serves, delivers successful results through inclusive team work where all contributions are valued, ensures every employee receives fair opportunities to succeed, and enables all employees to do their best by providing access to tools, resources, information, equipment and career development.

**FREE ON-SITE PARKING**

Special Requirements

Criminal Offender Record Information: Title 11, section 703 (d) of the California Code of Regulations requires criminal record checks of all personnel who have access to Criminal Offender Record Information (CORI). Pursuant to this requirement, applicants for this position will be required to submit fingerprints to the Department of Justice and be cleared before hiring. In accordance to DCA’s (CORI) procedures, clearance shall be maintained while employed in a CORI-designated position. Additionally, the position routinely works with sensitive and confidential issues and/or materials and is expected to maintain the privacy and confidentiality of documents and topics pertaining to individuals or to sensitive program matters at all times.  

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: 9/8/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. 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 Consumer Affairs
Office of Human Resources
Attn: Recruitment Technician, JC-530439 WS
1625 North Market Blvd., Suite N-321
Sacramento, CA 95834

Address for Drop-Off Application Packages

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

Department of Consumer Affairs
Office of Human Resources
Recruitment Technician, JC-530439 WS
1625 North Market Blvd., Suite N-321
Sacramento, CA 95834
The drop off location may be non-operational on weekends and holidays. 08:00 AM - 05:00 PM.
08:00 AM - 05: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.
  • Statement of Qualifications -
    (SOQ) is REQUIRED and MUST be submitted with your application to be considered for this position.  The SOQ serves as documentation of each candidate's ability to present information clearly and concisely in writing.
     
    When responding to the SOQ, applicants must follow these guidelines:
     
    Responses must be typewritten, no more than two (2) pages using no smaller than a 11-point font.
     
    Identify the page with "Statement of Qualifications" in the page header.
     
    Please review the Duty Statement and the Desirable Qualifications for the Data Governance and Reporting Architect.
     
    PLEASE RESPOND TO THE FOLLOWING: Review the desirable qualifications and in the order they are listed, briefly summarize your specific experience in each of them including the years of experience. 
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:
Desirable Technical Qualifications:
Experience developing reports, dashboards, and data products using Power BI,IBM Cognos, or Tableau.
Expert level SQL development skills, including query optimization and advanced performance tuning.
Hands on experience with Databricks, Delta Lake, Spark SQL, and enterprise data pipeline development.
Practical experience with ETL/ELT frameworks and modern data integration methods.
Ability to design and maintain conceptual, logical, and physical data models.
Experience working with enterprise databases such as Oracle, MySQL, Azure SQL, AWS RDS, or MongoDB.
Understanding of SDLC, Agile development practices, peer review standards, and user acceptance testing (UAT).
Ability to manage multiple priorities, meet deadlines, and adapt to evolving business needs.
Strong technical writing skills for documenting specifications, workflows, and development processes.
 
The ideal candidate will also have the following:
• Ability to work cooperatively with others
• Ability to work efficiently
• Ability to report to work on time
• Ability to maintain consistent, regular attendance
• Ability to work under changing deadlines
• Ability to get along with others
• Ability to always exhibit courteous behavior towards others
• Ability to meet deadlines
• Ability to perform tasks with minimal amount of errors
• Ability to do completed staff work

Benefits

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

The Department of Consumer Affairs, Office of Information Services is located in the Natomas area, offers FREE PARKING with electric vehicle charging stations, an in-house café, vending machines, and offers many nearby restaurants and retail stores, including http://www.natomasmarketplace.com  and http://www.sacramentogateway.com.  

Just a short distance from I-80 and I-5, with a bus stop directly in front of the building.  

 

EXCELLENT BENEFITS INCLUDE:

• The DCA is a qualified employer for Public Service Loan Forgiveness (PSLF)

• Various Health, Dental and Vision plans to choose from

• Retirement Plans (CalPERS, 401(k) and 457 Deferred Compensation Plans)

• 11 Paid Holidays

• Additional Paid Time Off (Vacation; Sick Leave; Professional Development Days; Personal Holidays)

• Staff Mentoring Program

• Free Parking On-Site Parking

• Close proximity to various amenities

Contact Information

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

Hiring Unit Contact:
Sophia Bruinsma
(916) 471-0741
sophia.bruinsma@dca.ca.govv

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:
EEO Officer
(916) 574-8280
EEO@dca.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.

Filing Instructions

If you are using education to meet the minimum qualifications, as specified in the classification specification (http://www.calhr.ca.gov/state-hr-professionals/pages/job-descriptions.aspx), please include a copy of your degree or unofficial transcripts with your application package. Please be aware that if you are selected for the position, you will be required to submit official sealed transcripts.
 
Using the online application system as specified in the announcement is the preferred method for applying for civil service job opportunities; however, applicants may instead apply by way of U.S. mail, parcel delivery or courier service, or in person, as set forth in this announcement.
 
Do not include confidential information such as social security numbers, date of birth, marital status, equal employment opportunity data, examination scores, and LEAP information.
 
Applicants who wish to submit hard copy applications shall use the most current version of the State application (STD. 678). https://jobs.ca.gov/pdf/std678.pdf
 
Applicants who fail to submit the most current version of the STD. 678 may be disqualified.
Multiple positions may become available.
 
Electronic Submission:
Application and any applicable required documents may be submitted electronically through CalCareers account. The application packages must be received electronically by 11:59 p.m. on the final filing date as state on the job vacancy announcement.
 
U.S Postal Service Mail:
Application and any applicable required documents may be submitted by mail. The envelope must be postmarked before or on the final filing date as stated on the job vacancy announcement.
 
Hand Delivery:
Application and any applicable required documents may be hand delivered by 5:00 p.m. on the final filing date as stated on the job vacancy announcement. Application packages postmarked, personally delivered, or received via interagency mail after 5:00 p.m. on the final filing date will not be accepted for any reason. Do not submit applications to the California Department of Human Resources (CalHR). Drop off location may be non-operational on weekends and holidays.
 
Please note the CalCareer system will not allow you to make changes to your application information once it is submitted. If you have updates to your online application after you have submitted it, please contact JobPostings@dca.ca.gov. For all other questions, regarding your CalHR CalCareer account, you may contact the CalCareer unit at (866)844-8671. 

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