INFORMATION TECHNOLOGY SPECIALIST II JC-512646

DEPARTMENT OBJECTIVE:

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.

PROGRAM OBJECTIVE:

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.

GENERAL DESCRIPTION:

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 incumbent also works with the BID Manager/CDO to develop and implement modeling, analysis, inference, exploration, and outcomes-based utilization of the department’s data assets; and in conjunction with the BID Manager/CDO to ensure that all activities and efforts align with DMHC Strategic Plan and IT Strategic Plan. The incumbent participates in the development and implementation of enterprise-wide data management policies, practices, and standards for the department.

TYPICAL DUTIES:

Employee must be able to performthe following dutieswith or without reasonable accommodation.

PERCENTAGE        JOB DESCRIPTION

Essential (E)/Marginal (M)

45% (E)                      Data Engineering

Architect, plan, design, develop and maintain DMHC enterprise data platforms that include on-premises and Azure cloud data stores, data models, including but not limited to, data warehouse, data marts, data lakes, data models,reporting databases and transactional databases, to enable enterprise reporting and analytics in support of DMHC’s data

analytics requirements. Plan, design, create and maintain data pipelines, ETL/ELT processes, data pipelines, data integrations and data migrations. Troubleshoot and fix data and BI/analytics solutions throughout the data life cycle. Develop, maintain and troubleshoot reports, dashboards and data stories. Plan and Implement data security and access mechanisms. Develop and leverageApplication Programing Interfaces (APIs) to support ingress and egress of data. Take inventory of data assets, perform gap analysis, develop data flow diagrams, and understand business needs for developing BI solutions. Consult with business and technical personnel.

Review project deliverables to lead in the analysis, design, and development of solutions. Guide BID staff who are responsible to develop data analytic solutions, technical and end user data dictionaries and user guides. Participate in meetings, provide status reports and complete work assignments in an effective, accurateand timely manner.Maintain system uptime, secure highly sensitive data, and work under pressure to meet work demands. Provide high-level technical expertise, leadership, communication and mentoring support to the BID team members, technical staff and cross functional teams.

Work in a self-directed manner, and/or in concert with business analysts, to gather and analyze business requirements, system and program specifications, use/test cases data and reports. Be familiar with coding for solutions, systems and/or modulesusing various programming languages, tools and frameworks that include but are not limited to SQL, MS .Net and

.Net Core, Microsoft Visual Studio.NET, HTML, CSS, Java, Java Script, Extensible Markup Language (XML), Python, web services, ArcGIS, Power BI, Synapse,and data APIs. Conduct unit, integration, system,and stress tests. Code deployment in all environments. Work collaboratively with the Quality Assurance team to maximize the performance of data analytics solutions.

15% (E)                      Enterprise Data Architecture

Represent the BID as a member of the OTI Enterprise Architecture Committee, to develop an effective data architecture that ensures data quality, accessibility, and security that will enable informed decision-making and strategic business outcomes. Create and evolve technology roadmaps to define department data architectures and support data strategies. Ensure data solutions are performant, secure and follow reusable patterns. Develop and share best practices for data discovery, change management and deployment. Research, analyze and promote data standards across the organization. Partner with cross-functional teams to deliver roadmaps and enable data capabilities. Design and implement integrations with other data sources and architect data solutions. Work collaboratively with the CIO, Chief Technology Officer (CTO) and BID Manager/CDO to Identify build vs. buy strategies for data

technologies. Work collaboratively with the Infrastructure Services Division (ISD) and Database Administrators to monitor performance trends and improve processes. Mentor team members and define internal guidelines. Research and stay informed about new technologies.

15% (E)                      Geo SpatialAnalytics Development

Serve as the DMHC’s subject matter expert on the ArcGIS geospatial analytics platform, and MicrosoftPowerBI geo-spatial analysiscapabilities. Design, develop, test and maintain existing and future geospatial analytic applications. Integrate geo-spatial solutions within software applications.

Assist program staff in conducting spatial analysis using solutions developed with ArcGIS, PowerBIand Python libraries to identify patterns, trends, and relationships in geographic data. Manage and maintain geospatial databases to ensure data integrity and efficient data storage and retrieval. Create custom GIS software solutions and tools, including add-ins for ArcGIS or web-based widgets. Work with program stakeholders to understand their needs, provide technical support, and collaborate with other team members on geospatial projects. Generate reports and visualizations using geographic data, create maps and dashboards, and communicate findingsto stakeholders. Keepingabreast of emerging technologies and trends in the geospatial field. Mentor and train junior BID staff to effectively leverage this technology to deliver solutions. Possess or acquire expert knowledge of ArcGIS API for JavaScript and other technologies. Familiarity with Docker, Kubernetes and CI/CD tools; AWS and other GIS technology platforms.

10% (E)                      Azure BI Administration and Data Infrastructure Management

Administration of DMHC’s BI tools and solutions including but not limited to Power BI, data warehouse, data marts, data lake, reporting databases, Synapse, Azure Data Factory, etc. Oversee BID staff responsible for installation, configuration and maintenance of database systemsand data stores. Ensure that the database systems, data models, data stores, reports, dashboards and other BI solutions are optimized for performance and scalability. Work with vendors, business users and DMHC management to evaluate, demonstrate and procure data, BI and analytics tools and solutions.

10% (E)                      Data Governance, Master Data Management, Enterprise Search Work collaboratively with the BID Manager/CDO to create and implement data management processes and procedures to efficiently and cost-effectively collect, store and use data. Work with DMHC management,

stakeholders, data stewards and data owners to set technical direction for the overall master data management program, define component architectures, review detaileddesigns for accuracyand overall compliance to defined architecture across the complete data lifecycle. Support object

identification and manage data elements, specify policies and business rulesfor master data creation and maintenance, description of hierarchies, taxonomies, or other relationships important to organizing or classifying objects, and assign data stewardship responsibility to appropriate individuals and organizations within DMHC offices and programs. Identify areas for data quality improvements and assist in resolving data quality problems through the appropriate choice of error detection and correction, process control, improvement, or design strategies. Act as a data literacy champion utilizing key performance indicators and data dictionary and educate peers and stakeholders. Conduct analytics workgroups, workshops, and meetings to expand the use and adoption of the enterprise data analytics platform and help DMHC become a more insight driven enterprise.

Setup, configure and support Elastic Search, DMHC’s enterprise data searchsolution. Based on requirements and Index new datasets and add existing data sets to the enterprise data search. Train and mentor other BID staff to assume responsibility for managing Elastic Search solutions.

5%(M)                         Participate as needed in stakeholder meetings, strategic planning sessions, meetings, security incident responses, California Health and Human Services Agency committees, sub-committees, workgroups, and other activities as assigned by the CIO and/or BID Manager/CDO. Collaborate and coordinate with other offices, stakeholders, data owners and vendors. Work collaboratively with the Infrastructure Services Division (ISD) staff to coordinate and plan backup and recovery of analytic data and reporting repositories, and databases; participate in Disaster Recovery and Technology Recovery planning, testing, and execution.

Perform special assignments and other related duties as required. Leverage excellent communication and interpersonal skillsto be a positive leader within BID, DMHC, CalHHS Agency and to other collaborative partners.

SUPERVISION EXERCISED OVER OTHERS:

Does not supervise others.