Software Developer III - EDW

Profile

We have an opportunity to join the Alliance as a Software Developer III - EDW in the Data Analytics Services Department.

We are filling one position in any of our three Alliance offices (Merced, Salinas, Scotts Valley) or it can be filled remotely in California.

WHAT YOU'LL BE RESPONSIBLE FOR

Reporting to the Enterprise Data Warehouse Manager, you will:

Create, develop, document, test, implement, and maintain enterprise data warehouse and databases in an Agile environment to support the needs and requirements of the Alliance reporting systems

Plan, schedule, and coordinate the design, development, testing, implementation, and documentation of the data warehouse and ETL/ELT applications using appropriate design techniques and modification of existing software

Participate in sprint planning of software and ETL/ELT design and development as part of the Agile development lifecycle

WHAT YOU'LL NEED TO BE SUCCESSFUL

To read the full position description, and list of requirements click here

Knowledge of:

Structured Query Language

Dimensional Modeling and Data Warehouse Design

Microsoft SQL Server Database

Microsoft Azure

ETL (Extract, Translate, and Load) processing and SSIS packages

Ability to:

Develop, document, apply and provide guidance on EDW development best practices in Wherescape systems, including 3D and RED, using the latest Data Vault methodologies; or, in modern enterprise data warehouse systems

Gather and analyze complex data and information, troubleshoot issues, and develop practical and effective solutions

Provide advice and recommendations on projects, tasks and issues, including the impact of proposed solutions

Quickly learn new business concepts and the latest Data Vault methodologies

Understand and document business users’ requirements

Education and Experience:

Bachelor's degree in Management Information Systems or Computer Science

A minimum of five years of enterprise data warehouse experience (a Master’s degree may substitute for two years of the required experience); or an equivalent combination of education and experience may be qualifying

OTHER DETAILS

While this position is connected to one of our Alliance offices, we are in hybrid telecommute work environment right now and we anticipate that the interview process will take place remotely.

Our Alliance office locations have officially re-opened as of May 2, 2022 and while some employees may work in full-time telecommute schedules, attendance at quarterly company-wide events or department meetings will be expected.

Based on the nature of work, this position may require onsite presence, which is dependent on business need. Details about this can be reviewed during the interview process.

COVID-19 Vaccine Requirement:

At this time, this position requires vaccination or regular testing upon office entry. Fully vaccinated and boosted is defined as receipt of the second dose in a 2-dose series (ex: Pfizer & Moderna vaccines) OR receipt of a single-dose vaccine (ex: Johnson & Johnson); AND receipt of the booster (if eligible); AND a 2-week period having passed since the administration of the last vaccine dose. If you state that you are vaccinated, proof of vaccination must be submitted at time of hire.

Additionally, all positions at the Alliance are required to meet these minimum qualifications

OUR BENEFITS

Medical, Dental and Vision Plans

Ample Paid Time Off

11 Paid Holidays per year

401(a) Retirement Plan

457 Deferred Compensation Plan

Robust Health and Wellness Program

EV Charging Stations

And many more

ABOUT US

We are a group of over 500 dedicated employees, committed to our mission of providing accessible, quality health care that is guided by local innovation. We feel that our work is bigger than ourselves. We leave work each day knowing that we made a difference in the community around us.

Join us at Central California Alliance for Health (the Alliance), where you will be part of a culture that is respectful, diverse, professional and fun, and where you are empowered to do your best work. As a regional non-profit health plan, we serve over 377,000 members in Santa Cruz, Monterey and Merced counties. To learn more about us, click here

At this time the Alliance does not provide any type of sponsorship. Applicants must be currently authorized to work in the United States on a full-time, ongoing basis without current or future needs for any type of employer supported or provided sponsorship.

Company info

Central California Alliance for Health
Website : http://www.ccah-alliance.org/