Information Technology Specialist Ii Jc-

The mission of the Department of Managed Health Care (DMHC) is to ensure health plan members have access to equitable, high quality, timely, and affordable health care within 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

30.2 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.

The Office of Technology and Innovation (OTI) enables the DMHC to deliver essential services to the State of California through the use of information technology (IT). The systems OTI supports have become a valuable tool in the execution of 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, low-code business intelligence tools, load code application development tools,data analytics and the underlying IT infrastructure.

Under the general supervision of the Chief Information Officer (CIO) and Manager of the Business Intelligence Division (BID)/Chief Data Officer (CDO), the Senior Data Engineer is 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.

The incumbent works as an integral member of the BID team, working under the direction of data solutions including planning, organizing, controlling, and managing on-premises and Azure cloud data and BI initiatives and solutions, data search and geospatial data analysis using ArcGIS for the DMHC. The incumbent is responsible for translating business requirements into technical requirements and design, for inclusion into the enterprise data architecture.

The incumbent shall serve as a technical lead during the implementation of these requirements, including but not limited to architecture, design, development, testing, and deployment. This also includes the management of architecture and design artifacts to provide an overall technical vision and maintain the department’s Data Architecture documentation. The incumbent is also primarily responsible for architecture and maintenance of the DMHC data warehouse environment and analytics platforms that include, but are not limited to, technologies and capabilities such as geo coding for spatial analysis within an ArcGIS enterprise platform, ingestion indexing, integration of data for integrated search using Elastic Search, business intelligence environment with on-premise SQL Server, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Azure Data Factory (ADF), SQL Server Analysis Services (SSAS), Azure BI and Microsoft Power Platform, Azure SQL MI, Power BI, Azure Synapse, Azure blob storage, Azure data lake gen2, ETL/ELT processes, Data pipelines, Python programs and packages, internal, external and cloud data sources and data, server applications and associated architectures.

The incumbent works collaboratively with the BID Manager/CDO to establish and maintain the department’s data governance structure; foster and promote a data-driven culture, encourage programs to share data and collaborate on program needs, and employ and analyze operational data to improve the performance of DMHC programs. The…