We have an opportunity to join the Alliance as the Enterprise Data Warehouse (EDW) Manager in the Data Analytics Services Department. 

 

WHAT YOU'LL BE RESPONSIBLE FOR

  • Managing the design, implementation, maintenance, and support of data warehouse systems, including the following components: Database, ETL Tools, Meta Data, Query Tools, and Data Marts
  • Managing and leading the Enterprise Data Warehouse (EDW) team and supervising, mentoring and training assigned staff
  • Managing and leading the development of analytical Data Marts and the Business Intelligence (BI) solution, such as Population Health BI tool and Power BI, including dashboard reporting, customization, training and related backend data integration with EDW

 

ABOUT THE TEAM

We integrate data from many sources to create information marts that provide the basis for business intelligence, reporting, and advanced analytics

 

WHAT YOU'LL NEED TO BE SUCCESSFUL

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

  • Knowledge of:
    • PC and EDW technologies
    • The principles and practices of systems and EDW architecture development
    • The EDW platform development
    • Data Warehouse Design
    • MS SQL Server Database design and optimization, T-SQL programming, and PL/SQL
    • ETL (Extract, Translate, and Load) processing and SSIS packages
    • Dimensional Modeling methodologies
  • Ability to:
    • Train, mentor, supervise, and evaluate the work of staff and motivate staff to achieve objectives
    • Develop work plans and workflows and organize and prioritize staff’s work
    • Demonstrate strong teamwork and team building skills
    • Facilitate and lead meetings and projects
    • Collect, manage and analyze data, identify issues, offer recommendations and potential consequences, and mitigate risk
    • Identify and resolve issues in a timely manner, including troubleshooting and resolving systems operating problems
    • Work in a multi-protocol, multi-platform environment
  • Education and Experience:
    • Bachelor’s degree in Management Information Systems, Computer Science or a related field
    • Minimum of six years of EDW development experience, from specification through implementation, which included responsibility for EDW architecture development and implementation of EDW technologies and a minimum of three years of healthcare experience, and a minimum of three years of manager or supervisor or project lead 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 remote/in-office 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.

 

The full compensation range for this position is listed by location below. 

The actual compensation for this role will be determined by our compensation philosophy, analysis of the selected candidate's qualifications (direct or transferrable experience related to the position, education or training), as well as other factors (internal equity, market factors, and geographic location).

 

Bay Area
$133,816$214,115 USD
Southern California
$133,816$214,115 USD
Central Valley
$122,045$195,291 USD
Central Coast
$133,813$214,115 USD

 


OUR BENEFITS

  • Medical, Dental and Vision Plans
  • Ample Paid Time Off 
  • 12 Paid Holidays per year
  • 401(a) Retirement Plan
  • 457 Deferred Compensation Plan
  • Robust Health and Wellness Program
  • Onsite EV Charging Stations

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 members in Mariposa, Merced, Monterey, San Benito and Santa Cruz counties. To learn more about us, take a look at our Fact Sheet.

The Alliance is an equal employment opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status. We are an E-Verify participating employer


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.

Apply for this Job

* Required
resume chosen  
(File types: pdf, doc, docx, txt, rtf)
cover_letter chosen  
(File types: pdf, doc, docx, txt, rtf)


U.S. Standard Demographic Questions

The Alliance is dedicated to creating a work environment focusing on inclusivity and belonging, In addition, we are interested in ensuring we have a diverse workforce. To that end, we invite you to voluntarily self-identify your race and ethnicity, as well as provide information on additional demographics. This data will remain anonymous and reported in aggregate to support our Diversity, Equity, Inclusion and Belonging efforts and to improve our future outreach and recruitment efforts.

How would you describe your gender identity? (mark all that apply)





How would you describe your racial/ethnic background? (mark all that apply)











How would you describe your sexual orientation? (mark all that apply)








Do you identify as transgender? (Select one)




Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication (seeing, hearing, speaking), and learning? (Select one)




Are you a veteran or active member of the United States Armed Forces? (Select one)





Please reach out to our support team via our help center.
Please complete the reCAPTCHA above.