Job Posting: Business Intelligence Analytics (BIA) Developer

Department of Managed Health Care

JC-429786
-
Business Intelligence Analytics (BIA) Developer
INFORMATION TECHNOLOGY SPECIALIST I

$6,139.00 - $9,932.00 per Month

Final Filing Date: Until Filled

Job Description and Duties

This job is being reposted as Until Filled. Applications will be reviewed daily.

You 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

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!


This position is eligible for a hybrid telework schedule under Government Code 14200. Under the Department of Managed Health Care’s (DMHC) current hybrid telework policy, employees may be required to report in-person to the office two times per week and will be required to utilize a shared or “hotel” workspace. Employees may also be required to report in person more frequently as determined by management, which may include working at a DMHC designated headquarters and/or offsite events or locations. Employees must work from a location within California while employed 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 operationalneeds are met.

Remote-Centered employees are expected to maintain a safe and distraction free work environment at the approved alternate worklocation. Remote-Centered employees agree to adhere to the state telework policy, the DMHC’s telework policy, and conditions cited in theTelework Agreement (STD 200).

Office-Centered employees are expected to maintain a dedicated workstation at a DMHC official worksite. Office-Centered employees areexpected to work in a climate-controlled office or cubicle under artificial lighting.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-429786
Position #(s):
409-541-1402-039
Working Title:
Business Intelligence Analytics (BIA) Developer
Classification:
INFORMATION TECHNOLOGY SPECIALIST I
$6,139.00 - $8,228.00 A
$6,751.00 - $9,048.00 B
$7,413.00 - $9,932.00 C
INFORMATION TECHNOLOGY ASSOCIATE
$4,651.00 - $6,234.00 A
$5,113.00 - $6,852.00 B
$5,589.00 - $7,491.00 C
$6,147.00 - $8,238.00 D
# 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 astable 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.7million 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 allCalifornians.

If you are interested in learning about the Department of ManagedHealth 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 LikeMe 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 time frames on the job posting) to be considered for hire at the DMHC. None of the information you provide through theSomeone 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, LEAPstatus, 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

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 Office - Julian Ortega
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 Office - Julian Ortega
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 befound in the Job Duties section.

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:

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:
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: 23-171 and Job Control: JC-429786 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/Information Technology Associate 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


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 not exceed 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 an SOQ in the downloadable template above are excluded from further consideration.

The SOQ must address the following:

  1. What modules/courses/classes/projects of your education align with the desirable qualifications of this position? Explain what BI skills you gained during these modules/courses/classes/projects?
  2. If you have professional experience in developing BI solutions then describe your professional experience in developing BusinessIntelligence (BI) solutions? Describe one of the BI solutions that you worked on and explain how it benefited your organization.
  3. Describe why you want to work in the field of business intelligence (BI) and how do you see yourself growing in the field of BI in the next five years?
  4. Describe your experience in data collection, data sharing, creating business insights from business data.
  5. Describe your experience in collaborating with Project Managers, Business Analysts, Business intelligence Specialists and Business users/stakeholders while working on business intelligence (BI) 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.

Application Methods:
Electronic (Using your CalCareer Account)
By Mail
Drop-off
Print Job