Enterprise Data Warehouse (EDW) Manager
Location: Scotts Valley, Salinas or Merced offices or remotely in California (must reside in California by start date).
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 please visit our website.
o PC and EDW technologies
o The principles and practices of systems and EDW architecture development
o The EDW platform development
o Data Warehouse Design
o MS SQL Server Database design and optimization, T-SQL programming, and PL/SQL
o ETL (Extract, Translate, and Load) processing and SSIS packages
o Dimensional Modeling methodologies
o Train, mentor, supervise, and evaluate the work of staff and motivate staff to achieve objectives
o Develop work plans and workflows and organize and prioritize staff’s work
o Demonstrate strong teamwork and team building skills
o Facilitate and lead meetings and projects
o Collect, manage and analyze data, identify issues, offer recommendations and potential consequences, and mitigate risk
o Identify and resolve issues in a timely manner, including troubleshooting and resolving systems operating problems
o Work in a multi-protocol, multi-platform environment
Education and Experience:
o Bachelor’s degree in Management Information Systems, Computer Science or a related field
o 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
o 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.
o 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.
o 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).
• 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
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 Merced, Monterey and Santa Cruz counties.
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.