Job ID: 290155341  |  Last Updated: 7/10/2023

Programmer, Sr. (Data Warehouse)

Employer
CalOptima
Location
Orange, CA
Applicant Contact
Jeffrey Lum
HR Manager (Recruitment)
Accepts J-1 Visas
Unspecified
Websites

Job Description

Programmer, Sr. (Data Warehouse)

Job Description

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

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 Warehouse (DW)) will design, develop and 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.
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, including ad-hoc reporting.
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 Extract, Transform and Load (ETL) processes to populate the operational data stores, data warehouse and data marts as needed.
Designs, develops and implements reports as necessary to fulfill business requirements.
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) and SQL Server Reporting Services (SSRS).
Develops and maintains code using XML, Python, VB scripting and C# scripting.
Expands and maintains designs of complex information systems through formal design techniques.
Takes part in Business Intelligence (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.
Supports user training and documentation, along with the roll-out of reports and end-user reporting tools.
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, Integration Services and using reporting tools such as SQL SSRS 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.
Experience with Collibra Data Intelligence Cloud (DIC) or Data Quality (DQ).

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

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

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

Job Location: Orange, California

Position Type:

To apply, visit https://apptrkr.com/4350626

Copyright 2022 Jobelephant.com Inc. All rights reserved.

https://www.jobelephant.com/

jeid-73a76508c886f947b636bd6789c03ebc

Employer Profile

Not Specified

View Full Employer Profile