TSSCI Special Security Officer SSO

About Cal Optima Health

Cal Optima Health is the single largest health plan in Orange County, serving one in four residents. Our motto — "Better. Together." — is at the heart of our mission to serve members with excellence, dignity and respect. We are a public agency made up of compassionate leaders and professionals working together to strengthen our community’s health. We are continuing to build a culture that promotes diversity and inclusion within our community where employees have a sense of belonging, and are valued for their ideas, contributions, and their unique individual perspectives they bring.

Cal Optima Health has been recognized as one of Orange County’s best places to work, so we know there is something special about our organization. It is why people choose to work here and why they choose to stay!

The Programmer Sr (Data Governance) will provide expertise in the design, development, and maintenance of Collibra data governance solutions to support data management and governance initiatives. The incumbent will implement software applications and perform complex and analytical assignments. The incumbent will oversee multi-tasking projects and create, modify and maintain business applications. The incumbent will analyze and design existing systems and programs, develop or recommend new systems or modifications and manage the development and implementation of reporting infrastructure.

The incumbent will gather and document requirements and design and build solutions for internal and external stakeholders. The incumbent will participate in the design and development of solutions using SQL Server technologies as well as other processes that utilize XML, VB scripting, C# scripting and Python.

• Participates in a mission driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability.
• Assists the team in carrying out department responsibilities and collaborates with others to support short and long-term goals/priorities for the department.
• Configures Collibra's data governance platform to meet the organization's data management and governance needs and develops custom scripts and extensions within Collibra to enhance functionality and integration with other systems such as ETL, BI and data cataloging tools.
• Creates and maintains workflows to support data stewardship, data quality and data classification processes, and collaborates with data stewards, business analysts and other stakeholders to define and implement data governance processes.
• Collaborates with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs.
• Serves as a subject matter expert across the organization and assists users with reporting and analysis activities and tools.
• Provides support and innovative solutions related to modules, researches software and matches with user requirements and advises users on limitations and alternative approaches.
• Conducts unit tests of new or modified processes ensuring data quality standards are adhered to.
• Participates in code reviews to represent reviewed work for adherence to standards and specifications.
• Plans, develops and supports ETL processes to populate the operational data stores, data warehouse and data marts as needed.
• Participates in the development of business and functional requirements for DW related projects.
• Develops and maintains code using Microsoft SQL Server, SSIS, Azure SQL, SSRS, Power BI, Tableau, XML, Python, VB scripting or C# scripting.
• Expands and maintains designs of complex information systems through formal design techniques.
• Takes part in BI working sessions, data normalization and governance exercises.
• Partners with leadership to ensure project activity is customer focused, results oriented, performance driven and in compliance with all applicable internal and external requirements and policies.
• Researches, evaluates and documents current and future business processes.
• Trains end-users and administrators in Collibra usage and best practices.
• Completes other projects and duties…