Software developer

Software Developer IV – EDW

LOCATION: Scotts Valley, California

We have the opportunity to join the Alliance as Software Developer IV – EDW in the Data Analytics Services department.

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

WHAT YOU WILL BE RESPONSIBLE: Reporting to the Enterprise Data Warehouse Manager, you:

  • Act as the hands-on lead for the architecture, data modeling, design, development, documentation, testing, and implementation of the Enterprise Data Warehouse (EDW) system and ETL/ELT applications
  • Provide guidance related to the use of EDW development best practices
  • Lead software sprint planning and ETL/ELT design and development as part of the Agile development cycle
  • Provide subject matter expertise and help provide mentorship and training

ABOUT THE TEAM: The Data Analytics Services team provides accurate and actionable data insights for sound business decision making. Our analysis teams are competent, focused and highly collaborative. We work hard, have fun and take pride in the impact of our work on the health outcomes of the communities we serve.


  • Be a strong developer, with expertise in end-to-end data modeling, data warehouse design, and data architecture
  • Be a hands-on leader and mentor, who embodies a proactive and solution-oriented approach to work
  • Be a fast learner, with a passion for professional development with an eagerness to stay current and apply new processes in an ever-changing healthcare environment
  • Consider the big picture of the organization and use this approach while developing and improving processes
  • Enjoy being part of a collaborative team


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

Knowledge of:

  • Dimensional Modeling, Data Warehouse Design, Data Architecture and Data Modeling
  • Structured Query Language (SQL)
  • Microsoft SQL Server database
  • Microsoft Azure
  • ETL processing (extract, translate and load) and SSIS packages
  • Project management and coordination principles and practices

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
  • Collect and analyze complex data and information, solve problems and develop practical and effective solutions
  • Provide advice and recommendations on projects, tasks and issues, including the impact of proposed solutions
  • Coordinate multiple projects simultaneously, organize work and meet goals and deadlines

Education and experience:

  • Bachelor’s degree in management information systems or computer science
  • A minimum of eight years of enterprise data warehouse experience (a master’s degree can replace two years of required experience); or an equivalent combination of education and experience may qualify


  • Although this position is connected to one of our Alliance offices, we are currently in a hybrid work-from-home environment and anticipate that the interview process will take place remotely.
  • Our Alliance offices officially reopened on May 2, 2022 and while some employees may work from home full-time, attendance at quarterly company-wide events or department meetings will be expected.
  • Depending on the nature of the work, this position may require on-site presence, which is dependent on business requirements. Details on this can be reviewed during the interview process.

COVID-19 vaccine requirements: Currently, this position requires vaccination or regular testing upon entering the office. Fully vaccinated and boosted is defined as receiving the second dose of a 2-dose series (eg Pfizer & Moderna vaccines) OR receiving a single dose vaccine (eg Johnson & Johnson); AND receipt of the reminder (if eligible); AND a period of 2 weeks having elapsed since the last dose of vaccine was administered. If you claim to be vaccinated, proof of vaccination must be presented at the time of hiring.

In addition, all Alliance positions must meet these minimum qualifications.


  • Medical, dental and vision plans
  • Lots of paid vacation
  • 11 paid holidays per year
  • 401(a) Retirement Plan
  • 457 Deferred Compensation Plan
  • Robust health and wellness program
  • EV charging stations
  • And much more

ABOUT US: We are a group of more than 500 dedicated employees, committed to our mission to provide accessible, quality healthcare guided by local innovation. We feel our work is bigger than ourselves. We leave work every day knowing that we have made a difference in the community around us.

Join us at Central California Alliance for Health (the Alliance), where you’ll be part of a respectful, diverse, professional, and fun culture, and where you’ll be empowered to do your best. As a nonprofit regional health plan, we serve more than 377,000 members in Santa Cruz, Monterey, and Merced counties. To learn more about us, click here.

At present, the Alliance does not offer any type of sponsorship. Applicants must be currently authorized to work in the United States on a full-time and continuous basis without the need, currently or in the future, of any type of employer supported or provided by sponsorship.

HOW TO REGISTER: If you are interested, please submit an online application here.