Job Posting: Enterprise Data Architect

Department of Managed Health Care

JC-488297
-
Enterprise Data Architect
INFORMATION TECHNOLOGY SPECIALIST III

$9,507.00 - $12,740.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: Until Filled

Job Description and Duties

This advertisement is posted as until filled. The Job Control will remain open, and applications will be reviewed every Friday.

The Office of Technology and Innovation (OTI) enables the DMHC to deliver essential services to the State of California using Information Technology (IT). The systems that the OTI supports have become valuable tools in the execution of the DMHC’s business functions. OTI develops, maintains, and supports multiple IT systems that include a vast variety of office automation tools, custom applications, public and internal web sites, business intelligence tools, and the underlying IT infrastructure. The Technical Services Division (TSD) provides support to endpoint applications and devices, which includes, but is not limited to, desktops, laptops, smartphones, tablets, SharePoint and Microsoft Teams.

JOB SUMMARY

Join us as our Enterprise Data Architect, primarily responsible for architecture, design and development of analytic databases, data pipelines, data integration, conceptual, logical and physical data modeling, data warehousing and data security to support DMHC’s data intensive applications, business intelligence, diagnostic, predictive, and prescriptive Analytics solutions.

For more information on how to apply, visit the DMHC’s Technology Career Center!

JOIN US ON OUR MISSION!

Your work supports the mission of the DMHC to protect consumers’ health care rights and ensure a stable health care delivery system for more than 29.8 million Californians.

ELIGIBILITY CONSIDERATIONS

Applicants must successfully complete an online examination and be authorized to work in the United States without the need for visa sponsorship now or in the future.

STATEMENT OF QUALIFICATIONS (SOQ) The SOQ is used to evaluate applicants for potential interview and is critical to the hiring process. If your qualifications meet the requirements for the position, you may be invited for an interview. The SOQ consists of questions that must specifically be addressed and submitted with an application using the provided SOQ Template. Resumes and cover letters DO NOT take the place of the SOQ. Failure to submit a completed SOQ Template disqualifies an applicant from hiring consideration.

 Download the SOQ Template

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

Working Conditions

The DMHC has locations in Downtown Sacramento and Rancho Cordova. Both locations are located close to light-rail with various amenities. The incumbent will work in a climate-controlled cubicle and/or office environment with artificial lighting.

This position may be eligible for hybrid telework. The telework schedule is permitted at the operational needs of the Department and is subject to change, consistent with the State Telework Policy and the DMHC’s Telework Policy. All employees who telework are required to be California residents and maintain California residency in accordance with Government Code 14200.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-488297
Position #(s):
409-531-1415-004
Working Title:
Enterprise Data Architect
Classification:
INFORMATION TECHNOLOGY SPECIALIST III
$9,507.00 - $12,740.00
New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.
# of Positions:
1
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
Permanent, Full Time

Department Information

The mission of the California Department of Managed Health Care (DMHC) is to protect consumers’ health care rights and ensure a stable health care delivery system. The DMHC accomplishes its mission by ensuring the health care system works for consumers. The Department protects the health care rights of more than 29.8 million Californians by regulating health care service plans, assisting consumers through a consumer Help Center, educating consumers on their rights and responsibilities, and preserving the financial stability of the managed health care system.

DMHC values diversity at all levels of the organization and is committed to fostering an environment in which employees from a variety of backgrounds, cultures, and personal experiences are welcomed and can thrive. DMHC believes the diversity of our employees and their unique ideas inspire innovative solutions to further our mission. Join DMHC and help us improve the lives of all Californians.

If you are interested in learning about the Department of Managed Health Care (DMHC) culture from the perspective of someone like yourself, contact our Someone Like Me program. Within five business days of your request to participate in the Someone Like Me program, you will be matched with a DMHC employee with a similar background to discuss the DMHC’s culture. This program is not part of, or in any way affiliated with the application or hiring process. Prospective employees must complete the application process on Cal Careers (e.g., submit your application within the specified timeframes on the job posting) to be considered for hire at the DMHC. None of the information you provide through the Someone Like Me program will be relayed to the Hiring Unit.

Department Website: http://www.dmhc.ca.gov

Special Requirements

  • The position(s) require(s) a Background Investigation be cleared prior to being hired.

All applicants not currently employed by the DMHC will be subject to a pre-employment background investigation. The investigation will consist of fingerprinting and an inquiry to the California Department of Justice to disclose criminal records.

Any documents you submit for a job vacancy such as your state application, resume, cover letter, educational transcripts, etc. SHOULD NOT include ANY confidential information. Confidential information that should be excluded or removed from these documents include, but is not limited to, your Social Security Number (SSN), birthday, driver’s license number (unless required), basis of eligibility, examination results, LEAP status, marital status, and age. Confidential information on the first page of applications submitted electronically online, such as Easy ID number, SSN, examination related information, and driver’s license number will automatically be redacted upon submission. Possession of Minimum Qualifications will be verified prior to interview and/or appointment.

If you are using education to meet the minimum qualifications for this position, you must submit a copy of your high school transcripts or college/university transcript(s).

Unofficial transcripts may be accepted during the application process; however, submission of official transcripts may be required prior to appointment.

Application Instructions

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: Until Filled

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 Managed Health Care
DMHC Recruitment
Attn: Human Resources Office
980 9th Street, Suite 500
Sacramento, CA 95814

Address for Drop-Off Application Packages

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

Department of Managed Health Care
DMHC Recruitment
Attn: Human Resources Office
980 9th Street, Suite 500
Sacramento, CA 95814
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 -

    The Statement of Qualifications (SOQ) is a MANDATORY requirement to apply for this position. The SOQ will answer specific questions and provide insight to the hiring manager regarding the candidate’s education, training, experience, and skills to meet the minimum and desirable qualifications for the position.

    Please see section labeled Statement of Qualifications Instructions for further direction.

     

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:
  1. Strong experience as an Enterprise Data Architect responsible for designing complex Enterprise Data Architectures (EDAs), and developing analytic databases to support data analytics solutions deployed within the EDA.
  2. Experience creating and evolving data technology road maps.
  3. Strong experience designing, developing, implementing and supporting:
  • Cloud and on-premises database and analytical solutions within a Microsoft cloud and on-premise framework including Azure SQL, Synapse, Power BI, SQL Server, SSIS, SSRS, Azure Data Factory and other technologies.
  • Data Pipelines using SQL Server Integration Services (SSIS) and Azure Data Factory (ADF).
  1. Strong experience designing, developing, implementing and supporting geospatial analytic solutions within the ESRI ArcGIS cloud platform and the ArcGIS Javascript API.
  2. Strong experience developing with Python and Java script programming languages.
  3. Experience working in a self-directed manner, or in concert with a business analyst, to conduct requirements gathering sessions focused on data object mapping, data transformation and planning.
  4. Experience developing conceptual, logical, and physical data models to support data analysis and business intelligence.
  5. Experience developing Extract/Transform/Load (ETL) and/or data pipeline solutions to support loading and refresh of analytic data structures.
  6.  Experience architecting, creating and maintaining current and target-state data architectures.
  7.  Experience ensuring that technology solutions are in alignment with the DMHC Strategic Plan, IT Strategic Plan, using data architecture principles and target state.
  8.  Experience overseeing end-to-end data life cycle management activities.

Benefits

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

Contact Information

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

Department Website: http://www.dmhc.ca.gov
Human Resources Contact:
Human Resources Office
(916) 445-1786
recruitment@dmhc.ca.gov
Hiring Unit Contact:
Ralph Cesena
(916) 738-3379
ralph.cesena@dmhc.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:
EEO Office
(916) 738-3394
EEO@dmhc.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.

Additional Application Instructions

To be considered for this vacancy, please complete all applicable fields on the application form, including a list or description of previous/current occupational experience in the duties performed section.

Do NOT include your social security number on any submitted documents. If submitting your application via postal mail or in person, please notate RPA:25-021 and Job Control: JC-488297 on your application.

All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to clearly demonstrate how you meet the Minimum Qualifications for the position on your State Application (STD Form 678). The application should also clearly demonstrate the candidate’s ability to meet the Desirable Qualifications identified in this job advertisement. The Classification Specification for the Information Technology Specialist III is located at the top of this Job Announcement Posting under Minimum Requirements.

Foreign Degrees or Transcripts – Applicants with foreign degrees or transcripts who wish to apply that coursework toward meeting the minimum qualifications of the classification must provide a transcript evaluation that indicates the number of units to which his/her foreign coursework is equivalent. DMHC accepts foreign transcript evaluations that are completed by one of the agencies approved by the California Commission on Teacher Credentialing.

PLEASE NOTE: If you are mailing your application, it must be postmarked by the final filing date. Hand delivered applications must be submitted no later than 5:00 p.m. on the final filing date. Applications slipped under the door at the Human Resources Office will be time stamped the following business day.

Statement of Qualifications Instructions

The SOQ consists of questions that must specifically be addressed and submitted with an application using the provided SOQ Template. Resumes and cover letters DO NOT take the place of the SOQ. Failure to submit a completed SOQ Template disqualifies an applicant from hiring consideration. The SOQ must be no longer than two pages, single-spaced, typed, Arial 12-point font.

Download the SOQ Template

The SOQ must address the following:

Question 1: Describe your background and experience acting as a Enterprise Data Architect responsible for shaping an organization's data landscape, and ensuring that data systems are robust, scalable, and aligned with business goals.

Question 2: Describe your background and experience developing analytic database structures and solutions leveraging your extensive expertise in data architecture, modeling, and governance to create comprehensive data solutions that facilitate effective data management and utilization, including but not limited to: Data Warehouse, Data Mart, Data Lake and enterprise reporting/analytic dashboard architecture and development.

Question 3: Describe your experience developing analytic databases within on-premises, cloud-based and/or hybrid (mixed cloud-and-on premises) architectures.

Question 4: Describe the analytic database schema types you have developed and the data migration/mapping/conversion tools and techniques you have used to implement each solution to support data analysis.

Question 5: Describe your experience with setting up and using data governance policies and procedures practices in an organization.

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