Job Posting: Data Warehouse Manager

Business, Consumer Services and Housing Agency

Data Warehouse Manager

$8,381.00 - $11,231.00 per Month

Final Filing Date: 6/3/2022

Job Description and Duties

Under the general direction of the Chief Information Officer, and in the Information Technology (IT) Project Domain, the Information Technology Manager (ITM) I serves as the Data Warehouse Manager, and has significant responsibility to lead the Homeless Data Integration System (HDIS) data analytics and data warehousing team to research, develop, and implement appropriate policies, procedures, and use of data. In addition, serves as the senior project manager for the ongoing planning, design, development, and maintenance of the HDIS which includes ongoing projects relying on knowledge of data collection, data cleansing, data warehouses, data analysis, visualization, and reporting. The ITM I also oversees the development and successful implementation of HDIS policies related to the privacy, security, and uses of data in service of aiding the state to set goals, policies, and recommendations related to the usage of HDIS data towards addressing homelessness in California.

This position is designated under the Conflict of Interest Code. The position is responsible for making or participating in the making of governmental decisions that may potentially have a material effect on personal financial interests. The appointee is required to complete Form 700 within 30 days of appointment. Failure to comply with the Conflict of Interest Code requirements may void the appointment.

Click here to share with us how you first learned about this position

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

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Position Details

Job Code #:
Position #(s):
Working Title:
Data Warehouse Manager
$8,381.00 - $11,231.00
# of Positions:
Work Location:
Sacramento County
Job Type:
Permanent, Full Time

Department Information

The Business, Consumer Services, and Housing Agency (BCHSA) is the California government cabinet-level agency that assists and educates consumers regarding the licensing, regulation, and enforcement of professionals and businesses.

The California Interagency Council on Homelessness (Cal ICH) is part of the BCSH. Cal ICH was established in statute in 2016 (SB 1380, Chapter 847, Statutes of 2016) to oversee the implementation of Housing First policies, guidelines, and regulations to reduce the prevalence and duration of homelessness in California. Cal ICH is developing policies to identify and coordinate resources, benefits, and services to prevent and work toward ending homelessness in California, including:

• Implementing major grant programs, the Homeless Emergency Aid Program (HEAP) and the Homeless Housing, Assistance and Prevention Program (HHAP); as well as two challenge grants focused on addressing encampments and family homelessness.
• The development and ongoing management of the Homeless Data Integration System (HDIS);
• Coordinating Council activities across State agencies and departments to ensure alignment with the Council’s policy priorities and best practices; and
• Work in partnership with Continuums of Care (CoCs), Federal agencies, city and county governments, non-profits, housing and services providers, and others.

Cal ICH staff also work in consultation with the Governor’s Office and with the Legislature as subject-matter policy experts to guide and strengthen the State’s response to homelessness.

Note: The Homeless Coordinating and Financing Council (HCFC) will be renamed to the California Interagency Council on Homelessness (Cal-ICH), effective January 1, 2022. The Council and its staff will continue to be a part of the Business, Consumer Services, and Housing Agency.

Department Website:

Special Requirements

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: 6/3/2022

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list 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 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 General Services
Attn: DGS-OHR/Certification Unit
P.O. Box 989052
West Sacramento, CA 95798-9052

Address for Drop-Off Application Packages

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

Department of General Services
Office of Human Resources-Reception
Office of Human Resources
707 3rd Street, Suite 7-130
West Sacramento, CA 95605
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 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.
  • Statement of Qualifications -
    A Statement of Qualifications (not to exceed two pages and no smaller than 11-point font) is required with the application. The SOQ should detail your interest in the California Interagency Council on Homelessness and show how your education and experience would make you a good fit for the position by addressing the desirable qualifications and the duties outlined in the duty statement. Please be specific about your knowledge, skills, and abilities.
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 in managing all activities associated with data warehouse program.
• Experience in leading the development and adoption of policies, procedures and standards in alignment with agency and other state requirements and standards.
• Knowledge of data warehousing, reporting, analytics, and data visualization trends.
• Experience in managing successful IT related projects in an environment that prioritizes security risk management including but not limited to risk assessment, mitigation, and evaluation.
• Knowledge of state’s information technology policies and standards and related Federal and State regulations.
• Knowledge of principles, practices, and trends of public administration, including management, organization, planning, cost/benefit analysis, budgeting, and project management and evaluation.
• Knowledge of the department’s goals and policies.
• Knowledge of employee supervision, training development and personnel management.
• Ability to establish priorities and complete multiple assignments to meet firm deadlines.
• Ability to understand and align technology proposals with business needs.
• Ability to develop and evaluate alternatives, collect and analyze information, and evaluate results to choose the best solution and solve problems.
• Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
• Ability to effectively develop and use resources.
• Ability to plan, coordinate and direct the activities of a data processing staff.
• Ability to make effective use of interdisciplinary teams.
• Ability to work cooperatively with staff at all levels and positively influence others to achieve results that are in the best interests of the department.
• Ability to reason logically and creatively and use a variety of analytical techniques to resolve managerial problems.
• Ability to present ideas and information effectively, both orally and in writing.
• Ability to consult with and advise administrators and other interested parties on a variety of subject-matter areas, translating technical data processing terms into everyday language.


There are many benefits to joining our team!  The State of California has a generous benefits package, some benefits include:

  • Medical Benefits, including health, dental, and vision insurance
  • Paid Holidays and leave
  • Defined benefit retirement program
  • Savings Plus Program (401(k), 457)
  • Commute Program
  • Employee Wellness Program
  • Employee Assistance Program
  • Medical/Dependent Care Reimbursement Accounts

Some added benefits BCSH/HCFC offers include: Flexible Work Hours, Telework Opportunities, Health, Dental & Vision Benefits, Paid Sick & Vacation, Retirement, Basic Group Term Life Insurance, Employee Assistance Program, 11 Paid Holidays, 401(k) & 457 plans, Military Leave, Student Loan Forgiveness, Long Term Care, Group Legal Services, and Reimbursement Accounts.

Click here to view all the benefits available to state employees!

Contact Information

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

Department Website:
Hiring Unit Contact:
Lori Isbell
(916) 768-4685

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 Main Line
(916) 376-5127
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.

Reporting Location

801 Capitol Mall, 6th Floor
Sacramento, CA, 95814

Please specify RPA 22030-BCSHA and JC-305979 on your state application.

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.