Apply now »

Principal Enterprise Data Warehouse Architect

Job Category:  Information Technology
Department:  IT Enterprise Data Management

Los Angeles, CA, US, 90017

Position Type:  Full Time
Requisition ID:  7953


Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members in five health plans, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

As a condition of employment, L.A. Care requires a COVID-19 vaccine. This requirement includes our remote workforce. If you would like to request an exemption, L.A. Care has implemented a process to consider exemptions, for documented medical conditions and sincerely held religious beliefs. L.A. Care will review all exemption requests prior to proceeding with the recruitment process.

Job Summary

Responsible for the architecture of the L.A. Care Enterprise Data Warehouse Core platform. Develops  practical roadmaps for the Enterprise Data Warehouse. Defines the overall core warehouse data architecture, including ETL processes, logical and physical structures  and recommends appropriate technologies to support the implementation of the roadmap.


Works with the BI and Enterprise data architects to insure that logical and physical data models support the analytic needs of the business. Provides technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective management. Collaborates with key business users to identify needs and opportunities for improved data management and delivery. Provides expert level technical knowledge and business support to the team.


Collaborate with business and I.T. partners and Translate business strategic needs into architectural requirements and provide direct technical lead expertise in implementing solutions.


Technical solution review of EDW architecture.


Develop Logical and Physical models for the EDW.


Serve as a technical lead in aligning architecture capabilities with business strategies with respect to goals and objectives.


Develop, maintain and communicate reference architectures and architectural roadmaps for overall transparency and alignment. Define roadmap and strategies for integration, data, system and analytics architectures.


Demonstrating and obtaining business & technical buy in to proposed solutions.


Perform other duties as assigned.

Education Required

Bachelor's Degree in Computer Science or Business Administration
In lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Master's Degree


At least 7 years of experience in the design and building of enterprise data warehouses with the demonstrated experience on the following list of stated  knowledge, experience and/ or skills.


Excellent understanding of data modeling, SQL and ETL.


Experience in multiple database platforms, including SQL Server and Oracle.


Experience working with end users to gather requirements and build technical solutions from concept to implementation.


Ability to facilitate meetings and delegate responsibilities.


Fully understand the enterprise sources of data (files and processing systems).

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Additional Information


L.A. Care offers a wide range of benefits including

  • Paid Time Off (PTO)
  • Tuition Reimbursement
  • Retirement Plans
  • Medical, Dental and Vision
  • Wellness Program
  • Volunteer Time Off (VTO)


At L.A. Care, we value our team members’ safety. In order to keep our work locations safe, each employee is required to self-screen for symptoms prior to entering any L.A. Care location each day. L.A. Care and all of its staff are required to comply with all state and local masking orders. Therefore, when on-site at any L.A. Care location, employees are expected to wear a mask in areas where physical distancing cannot be managed.

Nearest Major Market: Los Angeles

Apply now »