This position is being re-advertised. If you previously applied, your application is being considered and you do not need to re-apply. Under direction of the Information Systems Branch (ISB) Information Technology Manager II (IT Manager II), the Information Technology Specialist I (ITS I) acts as a project lead on complex applications, and/or complex information technology system problems. Incumbent works independently as a technical specialist performing system programming and analysis related to the development of reports. This position is in the System Engineering domain. Incumbents in this classification will progress through ranges A, B and C based upon the requirements of the alternate range criteria relating to the classification specifications. As the incumbent progresses beyond Range A, the incumbent will be expected to perform the level of responsibilities associated with the assigned range, in addition to the level of responsibilities in the lower range(s): Range A - Incumbents in this range develop, maintain, test, and resolve routine report issues. Incumbents analyze and resolve complex data and programming issues with guidance. Range B - Incumbents in this range complete programming responsibilities with less supervision, and broader knowledge and application of DCA's business environment, database structure and programming tools. Incumbents develop, maintain, test and resolve complex reporting issues. With guidance, incumbents develop and document design specifications and recommend solutions for complex business requirements. With guidance, incumbents analyze and recommend reporting framework changes. Incumbents may implement reporting framework changes as well if approved by the supervisor. Range C - Incumbents in this range require minimal supervision and have expert knowledge of DCA's business environment, database structure and programming tools. Incumbents develop, maintain, test and resolve complex reporting issues. Incumbent work independently with other staff to analyze system requirements and design, develop, test and integrate applications. Incumbents analyze, recommend, and implement reporting framework changes. Incumbents are involved in the administrative work needed for maintaining/upgrading reporting tools/software, client user set up and trainings 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. 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 SPECIALIST I
Additional Documents - Job Application Package Checklist
- Duty Statement
Position Details Job Code #: JC-472870 Position #(s): 629-###-####-002 629-###-####-XXX Working Title: SQL/Reports Developer Classification: INFORMATION TECHNOLOGY SPECIALIST I $6,323.00 - $8,475.00 A $6,954.00 - $9,319.00 B $7,635.00 - $10,230.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: Medical Board of California
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. This position is with the Medical Board of California and in the Information Systems Branch. The Medical Board has FREE PARKING and is located next to the Royal Oaks Light Rail Station.
Special Requirements - The position(s) require(s) a Background Investigation be cleared prior to being hired.
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. Conflict of Interest Regulation: This position is subject to Title 16, section 3830 of the California Code of Regulations, the Department of Consumer Affairs' Conflict of Interest Regulations. The incumbent is required to submit a Statement of Economic Interests (Form 700) within 30 days of assuming office, annually by April 1st, and within 30 days of leaving office.
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: 8/21/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. 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-472870, GP 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-472870, GP 1625 North Market Blvd., Suite N-321 Sacramento , CA 95834 Please note: The drop off location may be non-operational on weekends and holidays. 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 optional. It may be included, but is not required.
- Statement of Qualifications - A statement of qualifications is required for this position. Please refer to the Statement of Qualifications Requirement section for instructions. Applications received without the SOQ may not be considered for this position. A resume does not replace the SOQ.
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: Required Technical Knowledge Experience developing and implementing enterprise-scale reports and dashboards Experience working with users in a requirements analysis role Experience with Cognos Analytics product suite (Report Studio, Analysis Studio, Query Studio, etc.) or similar reporting tool Extensive knowledge of SQL queries Experience performance tuning queries Experience with complex data integration issues and structures Experience programming/scripting and knowledge of software development life cycle Experience managing multiple priorities, and assessing and adjusting quickly to changing priorities Experience with logical and physical data modeling concepts (relational and dimensional) Additional Performance Expectations: 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 multiple deadlines Ability to look and act in a professional manner Ability to get along with others Ability to exhibit courteous behavior towards others at all times 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.
Contact Information The Hiring Unit Contact is available to answer questions regarding the position or application process. Hiring Unit Contact: Sean Eichelkraut (916) ###-####
[email protected] 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) ###-####
[email protected] California Relay Service: 1-800-###-#### (TTY), 1-800-###-#### (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.
Statement of Qualifications Information Technology Specialist I - COGNOS Report/SQL Developer SOQ Questions: Please answer the following questions in a list format. Answers provided here that are not substantiated by Education and Employment History Duties Performed on STD. 678 Employment Application will not be considered. Question 1 can be answered in the format of A , B , or C . Questions 2-7 can be answered in the format of 20 Months at Department of Consumer Affairs . 1. Please provide your level of Computer Science (CS) or Management Information Systems (MIS) Education: a. No formal education or certification b. Some college level courses/certifications but less than a Bachelor's or Master's degree in CS or MIS c. A Bachelor's or Master's degree in CS or MIS. 2. How many months of professional experience do you have developing/troubleshooting/scheduling reports using IBM COGNOS? Which Employment History entry(s) on your state application will detail this experience? 3. How many months of professional experience do you have developing/troubleshooting/scheduling reports using Microsoft SQL Reports Services (SSRS)? Which Employment History entry(s) on your state application will detail this experience? 4. How many months of professional experience do you have developing/troubleshooting/optimizing Microsoft Transact-SQL (T-SQL) databases, queries, views, joins, indexes, keys, etc? Which Employment History entry(s) on your state application will detail this experience? 5. How many months of professional experience do you have developing/troubleshooting/optimizing Oracle's Procedural Language for SQL (PL/SQL) databases, queries, views, joins, indexes, keys, etc? Which Employment History entry(s) on your state application will detail this experience? 6. How many months of professional experience do you have gathering requirements for report/software development? Which Employment History entry(s) on your state application will detail this experience? 7. How many months of professional experience do you have as a Business Analyst working with large datasets? Which Employment History entry(s) on your state application will detail this experience?
Additional Instructions If you are using education to meet the minimum qualifications, as specified in the classification specification ( 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). 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
[email protected]. For all other questions, regarding your CalHR CalCareer account, you may contact the CalCareer unit at (866)###-####.
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.
