Address
Form of workYou must submit a completed Statement of Qualifications (SOQ) Template when you apply. The SOQ consists of questions that must specifically be addressed and submitted within the SOQ Template. Submission of anything other than the SOQ template does not meet application requirements.
Download the SOQ Template
BE A TELEWORK SUPERSTAR!
Work remotely from home (from within the state of California), under direction of the Chief (IT Manager I) of the Business Intelligence Division (BID), the incumbent works both independently and as part of a Business Intelligence (BI) team to develop, configure, maintain, enhance, and test on-premise and cloud-based enterprise BI solutions, data warehouse, subject area data marts, ETL processes, reports, dashboards, stories, and geo-spatial analysis (mapping) solutions.
This is an 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 as a team member in the Office of Technology and Innovation (OTI) is to 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!
The successful candidate must be highly motivated to work in a fast-paced and highly collaborative environment to execute projects within a hybrid Waterfall / Agile (wAgile) methodology. The incumbent must maintain a positive work attitude; provide excellent customer service; communicate effectively with the program/business users and other employees; develop and maintain knowledge and skills related to data analysis, BI solution development, development methodologies, materials, tools, and equipment.
The incumbent must have the ability to effectively work from home (Telework), or in our downtown Sacramento office. In order to Telework, the incumbent must have a Cable or Fiber connection to the Internet.
WORK BALANCE LIFE!
OTI believes it is critical for our staff to have a healthy work/life balance to ensure we have happy, productive staff that love their job! The perfect balance is achieved when you are able to meet work deadlines and still have time for friends, family, and hobbies!
INNOVATION!
We have adopted low-code cloud technologies for application deployment, and soon hope to add cloud-based Business Intelligence tools to our tool belt!
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.7 million Californians.
This is your opportunity to join a newly energized and highly innovative team, eager to embrace new technologies that will effect digital transformation at the DMHC.
You will find additional information about the job in the Duty Statement .
Working Conditions
The DMHC utilizes a hybrid telework model to provide all employees with an avenue to telework while ensuring business and operational needs are met.
Remote-Centered employees are expected to maintain a safe and distraction free work environment at the approved alternate work location. Remote-Centered employees agree to adhere to the state telework policy, the DMHC's telework policy, and conditions cited in the Telework Agreement (STD 200).
Office-Centered employees are expected to maintain a dedicated workstation at a DMHC official worksite. Office-Centered employees are expected to work in a climate-controlled office or cubicle under artificial lighting.
Minimum Requirements You will find the Minimum Requirements in the Class Specification.
- INFORMATION TECHNOLOGY SPECIALIST I
- INFORMATION TECHNOLOGY ASSOCIATE
- Job Application Package Checklist
- Duty Statement
Position Details Job Code #:
JC-409136
Position #(s):
409-541-1402-039
Working Title:
Business Intelligence Analytics (BIA) Developer (Telework)
Classification:
INFORMATION TECHNOLOGY SPECIALIST I $5,960.00 - $7,988.00 A
$6,554.00 - $8,784.00 B
Shall Consider:
INFORMATION TECHNOLOGY ASSOCIATE
$4,516.00 - $6,052.00 A
$4,964.00 - $6,652.00 B
$5,426.00 - $7,273.00 C
$5,968.00 - $7,998.00 D
# of Positions:
1
Work Location:
Sacramento County
Telework:
Telework
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.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.
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 le arning about the Depa rtment 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.
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. Unofficial transcripts may be accepted during the application process; however, submission of official transcripts may be required prior to appointment.
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: 1/5/2024
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
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 make sure to include a Statement of Qualifications with your applicaiton. The Template can be found in the Job Duties section.
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:
This is posted for an IT Specialist I position, but we will consider an IT Associate. Qualifications that are optional for the position of IT Associate are marked as such in the list below:
1. Experience working with enterprise and data architects, business analysts, project management teams and program/business stakeholders to develop, test, support and maintain Business Intelligence (BI) solutions. This can include, but is not limited to, enterprise analytical reports, dashboards, data warehouse, data lake, data marts, ETL processes, using SQL Server, Python, and JavaScript.
2. Experience acquiring and preparing data from various custom application sources for use in DMHC reporting and analytics solutions to support decision making.
3. Experience in business and technical analysis, development tasks, execute unit testing, participate in peer code review, and serving as a BI support resource for on-premise and cloud based reports, dashboards, data warehouse, data lake and ETL solutions.
4. Experience developing reports and dashboards in Tableau, PowerBI, SSRS
5. Experience in development using SQL Server, T/PL-SQL, Python, SSIS
6. Experience in ETL development.
7. Experience in Documentation of code, and creating ERD and data flow diagrams.
8. Experience in Dimensional modeling, This is not a requirement for the position of IT Associate.
9. Experience developing solutions within Snowflake, Microsoft Azure BI/data platform in the cloud, or similar technologies. This will be a plus not a requirement for the IT Associate position.
10. Experience in developing analytical solutions using ArcGIS is a plus.
11. For IT Specialist I only, experience developing solutions within OutSystems, Power Apps and NoSQL technology, or similar is a plus.
For IT Associate, an experience of two years in above mentioned areas OR 60 semester units (or 90 quarter units) from an accredited college or university including at least 15 semester units (or 22.5 quarter units) of information technology course work will be sufficient. For IT Associate the working title will be Junior Business Intelligence Analytics (BIA) Developer.
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:
Julian Ortega
(916) 403-4332
Julian.Ortega@dmhc.ca.gov
Hiring Unit Contact:
Bhupinder Singh
(916) 403-2047
bhupinder.singh@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 l...
