Job Posting: Data Systems Analyst

Department of Managed Health Care

JC-257918
-
Data Systems Analyst
INFORMATION TECHNOLOGY SPECIALIST I

$5,562.00 - $9,267.00 per Month

Final Filing Date: Until Filled

Job Description and Duties

This is your opportunity to join a newly energized and highly innovative team, eager to embrace new technologies to effect digital transformation at the California Department of Managed Health Care (DMHC). Your work will support DMHC’s mission to protect consumers’ health care rights and ensure a stable health care delivery system! Our goal is to be the best and most innovative technology office within the State of California!

Under direction of the Information Technology Manager I of the Business Intelligence Division (BID), the Data Systems Analyst works closely with program staff and BID leadership to define data projects that support department-wide decision making:

  • Analyze and document business requirements for Business Intelligence (BI) projects that can consist of data warehouse, data extraction/transformation/load (ETL), data extraction/load/transformation (ELT), data mart, enterprise reporting and analytic solution components.
  • Work with program staff to develop requirement documents, design documents, use cases and test cases that define complex and advanced data projects.
  • Design and development of data acquisition solutions including ETL and/or ELT using our Microsoft SQL Server Integration Services and/or Tableau capabilities.
  • Design and develop solutions within DMHC’s Data Governance and Data Quality Management standards to ensure high quality data is available to programs for analysis.
  • Participates in building a data-driven culture across the DMHC program areas by supporting Data Governance and Master Data Management programs.
  • Function as an integral member of a BI team responsible for delivering enterprise data solutions that include planning, organizing, controlling, and managing BI initiatives and solutions.
  • Work independently as required, and provide consultation and information regarding all data projects and issues related to DMHC data assets.

**Statement of Qualifications (SOQ) Required**

Candidates must submit a SOQ with their application package. The SOQ consists of questions that must specifically be addressed using the SOQ Template. Submission of a Resume as a SOQ does not meet application requirements.

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

Working Conditions

This position is located in downtown Sacramento in a modern facility with the following amenities: on site gym, free shuttle service to local businesses, two tenant appreciation events each year, across the street from a Farmer’s Market, and one block to light rail. Join this team of professionals for an opportunity within an energetic setting.

The employee will work in a climate-controlled office under artificial lighting. There will be occasional fluctuations in temperature. The employee will work in a cubicle and will periodically attend meetings and/or training outside of his/her assigned office. The employee will work in and/or visit offices located in a high rise building accessed through elevators. Due to COVID -19 pandemic, DMHC employees are currently teleworking.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-257918
Position #(s):
409-541-1402-030
Working Title:
Data Systems Analyst
Classification:
INFORMATION TECHNOLOGY SPECIALIST I
$5,562.00 - $9,267.00
# of Positions:
1
Work Location:
Sacramento County
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 27.7 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.

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. This 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 unofficial transcripts 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 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
Attn: Human Resources - Margie Villadelgado
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
Human Resources - Margie Villadelgado
980 9th Street, Suite 500
Sacramento, CA 95814
If hand delivering, please bring to HR, Suite 8091 on Mondays & Wednesdays, except 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 required and must be included.
  • Statement of Qualifications - Please see "Statement of Qualifications Instructions" section for more information. 
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. Experience in designing and developing enterprise and departmental business intelligence, data warehousing, and reporting solutions while working with business users and stakeholders. This includes business and technical requirements documentation and analysis, ETL/ELT development, implementation of data quality initiatives.

2. Experience with the design, analysis, and interpretation of projects from data requirement gathering to data processing, data mapping and data modeling.

3. Experience mapping relationships between databases and reporting systems. Illustrates data relationships across multiple databases, with the ability to understand and explain relationships to users of the information.

4. Experience with developing and maintaining a data dictionary, Key Performance Indicators, and validated measures.

5. Experience meeting data requests from internal and external stakeholders and addressing gaps in existing data quality.

6. Experience with data acquisition and distribution strategies and reporting processes to ensure the systematic, efficient, and reliable collection and distribution of data.

7. Experience in accessing, integrating, and cleaning data from internal and external sources to assess the impact and activity outcomes of programs.

8. Experience presenting data sets in a manner that is user-friendly and facilitates learning/understanding at various levels (i.e., Program staff, Supervisors, Executive and Directors).

9. Experience in conducting all reporting and data mining in compliance with privacy, confidentiality and proprietary regulations and policies.

10.Familiar with data engineering concepts and practices, including a very strong SQL skill.

11. Knowledge of enterprise BI processes along with tools such as SQL Server, MS Azure, Tableau, and PowerBI.

12. Knowledge of Data Quality tools, technology, theories, concepts, and practices; federal/state/or other Quality Assurance (QA) standards or regulations, data collection and analysis concepts and practices.


Benefits

To learn more about benefits for State employees, visit the page California State Civil Service Employee Benefits Summary on the CalHR website. 

NOTE:  Salaries do not reflect recent changes necessitated by the unanticipated budget shortfalls arising from the COVID-19 pandemic.  Information for actual reductions of salaries is available in the Human Resources Manual, Section 2113, Personal Leave Program (PLP) at http://hrmanual.calhr.ca.gov/Home/ManualItem/1/2113.

Please refer to the section for Service Employees International Union (SEIU) – Bargaining Units 1, 3, 4, 11, 14, 15, 17, 20 and 21.

General State Employment Benefits and Protections

Click here to view more information about the outstanding benefits offered to State employees.

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:
Margie Villadelgado
(916) 322-6864
Margie.Villadelgado@dmhc.ca.gov
Hiring Unit Contact:
Nishan Sandhar
ext:
Nishan.Sandhar@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) 403-0409
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.

Electronic applications though your CalCareer account are highly recommended.

Do NOT include your social security number on any submitted documents. If submitting your application via postal mail or in person, please notate RPA: 20-164 and Job Control: JC-257918 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 I 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

Please submit a Statement of Qualifications (SOQ), using the SOQ Template, to describe your experience, knowledge, skills and abilities related to the qualifying factors listed below. The SOQ must be no longer than two pages, single-spaced, typed, and Arial 12-point font size. Resumes, letters, and other materials will not be considered as a response to the SOQ.

 

Applications submitted without a SOQ are excluded from further consideration. You must provide your reporting manager and phone number to verify your capabilities.

Statement of Qualifications (SOQ) Questions. Please use SOQ Template.

1. Describe your professional experience gathering, documenting, and analyzing business and technical requirements to support data warehouse, data mart, analytic and enterprise reporting projects. 

2. Describe your professional experience developing, testing, and deploying Extract/Transform/Load (ETL) and/or Extract/Load/Transform (ELT) solutions using Microsoft SQL Server Integration Services, NoSQL databases and/or Tableau. 

3. Describe your professional experience and knowledge of Data Governance programs including master data management, meta data management, data collection and data-sharing concepts, practices, and principles. 

4. Describe your professional experience establishing methods and procedures for monitoring and tracking data quality and completeness, as well as eliminating data redundancy.

5. Describe your professional experience collaborating with Project Managers, Business Analysts, Business Intelligence Specialists, business program staff, and/or outside partners while executing Enterprise Business Intelligence projects. 


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.