Sr. Programmer (Data Governance)

Sr Collibra Programmer (Programmer Sr)

LinkedInTwitterEmailMessageShare

Posted Date

11 / 2 / 2023

Department(s) : ITS-Enterprise Data and Systems Integrations

Reports to : Manager Information Technology Services

FLSA status : Non-Exempt

Salary Grade : N - $95,000 - $155,078

Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. The deadline for the first review of applications is on Thursday, November 16, 2023 at 11 : 59 PM. Applicants are encouraged to apply early. Applicants that apply after the first review are not guaranteed to be considered for this recruitment. This recruitment may close at any time without notice after the first review date.

About CalOptima Health

CalOptima 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. CalOptima 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!

About the Position

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 Structured Query Language (SQL) Server technologies as well as other processes that utilize Extensible Markup Language (XML), Visual Basic (VB) scripting, C# scripting and Python.

Duties & Responsibilities :

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 develop custom scripts and extensions within Collibra to enhance functionality and integration with other systems such as Extract, Transform and Load (ETL), Business Intelligence (BI) and data cataloging tools.

Creates and maintains workflows to support data stewardship, data quality and data classification processes, as well as 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, SQL Server Integration Service (SSIS), Azure SQL, SQL Server Reporting Services (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 as assigned.

Experience & Education :

Bachelor's degree in Computer Science, Information Science or related field required.

5 years of experience in general relational database and reporting development required.

5 years of experience with data warehousing analysis and development including database design, ETL and reporting required.

5 years of experience using Microsoft SQL Server, Transact-SQL, Azure SQL, Integration Services and using reporting tools such as SSRS required.

Experience with Collibra Data Intelligence Cloud (DIC) or Data Quality (DQ) required.

An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above is also qualifying.

Preferred Qualifications :

3 years of experience in the health care industry.

2 years of experience with BI tools such as Tableau or Power BI.

Experience using modeling techniques as a tool for application design and development.

Physical Demands and Work Environment

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical demands : While performing duties of job, employee is required to move about the organization. Employee must be able to sit for extended periods of time, as well as work at the computer for long periods. Employee is required to use hands and fingers, especially for typing on the computer and using the mouse. Must also be able to reach with hands and arms and must occasionally lift heavy office supply boxes. Employee is required to communicate, particularly for phone use and in meetings.

Work Environment : Cubicle type office environment with minimal to moderate noise levels and controlled office temperatures.

About our Benefits & Wellness options :

At CalOptima Health, we know that a healthy and happy workforce is a thriving workforce, which is why we offer a comprehensive benefits package, including participation in the California Public Employees Retirement System (CalPERS), low-cost medical / vision / dental insurance options, and paid time off. To support quality work-life balance, we allow flexible scheduling during core business hours, telework options for some positions, work schedules that allow every other Monday or Friday off (9 / 80 schedule), and a wellness program featuring diverse activities. Additionally, CalOptima Health contributes 4% of pensionable earnings to a 401(a) retirement program with no required employee contribution. Employees also have access to 457(b) retirement plans with pre / post-tax contribution options.

CalOptima Health is committed to attracting, hiring, and retaining a diverse staff, where we will honor your unique experiences, identity, and perspectives. Our organization strives to create and maintain a workplace environment that is inclusive, equitable and welcoming so we can truly be Better Together.

CalOptima is an equal employment opportunity employer and makes all employment decisions on the basis of merit. CalOptima wants to have qualified employees in every job position. CalOptima prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion / religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability.