Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  

Lead and Enterprise Data Warehouse Architect

Job Category:
Technology Provider
Career Level:
Mid Career (2+ years of experience)
Job Type:
Full Time/Permanent
Company Name:
San Francisco
Description: Req # 100545 

Lead and Enterprise Data Warehouse Architect

San Francisco, CA US

Employee: Full Time Employee
Travel: 10%
Apply Now    
About Castlight

At Castlight, our mission is to empower people to make the best choices for their health and to help companies make the most of their health benefits. We offer a health benefits platform that engages employees to make better healthcare decisions and can guide them to the right program, care, and provider. The platform also enables benefit leaders to communicate and measure their programs while driving employee engagement with targeted, relevant communications. 

To date, Castlight has partnered with more than 200 large enterprise customers, spanning millions of lives, to improve healthcare outcomes, lower costs, and increase benefits satisfaction.

Essential Duties and Responsibilities: 
  • Strategically designs and implements data warehouses, data marts, and data stores, while ensuring high levels of data availability. 
  • Defines and implements enterprise wide data standards. 
  • Designs logical and physical models for the data warehouse, data mart, staging, and the operational data stores. 
  • Communicates physical database designs to database administrator(s); evolves models to meet new and changing business requirements; develop process for capturing and maintaining metadata from all data warehousing components. 
  • Defines, designs, and implements data structures and database solutions that integrate with different information distribution platforms and comply with industry standards 
  • Develops strategy for migrating existing legacy databases and data warehouse(s) to a company's future state Data Warehouse solution 
  • Defines, develops, and implements ETL principles, standards, and guidance to support business intelligence and application development needs. 
  • Develops data stores to provide central integration of a given subject such as patient, claims, benefits, etc, that feed operational systems, warehouse and other internal and external data systems. 
  • Uses best practice to develop data marts to provide content-specific data to business area and implement aggregations as required. 

Lead and Architect Enterprise Data Warehouse


  • Bachelor’s degree required, preferably in Computer Science, Information Technology, Mathematics or Data Science 
  • Related work experience within the Healthcare Technology Industry or Insurance Industry; experience working with healthcare payers/carriers in managing provider, claims, medical or patients data strongly desired 
  • Applied experience in secure file transfer protocol (sFTP), web services integrations, 
  • Salesforce, and JIRA is preferred 


5+ years of hands-on experience in the following areas: 

  • Industry-standard data integration methodologies, business intelligence, data warehouse principles and approaches; database and data warehouse design, development and team leadership with at hands-on experience as an architect on at least 2-3 prior projects. 
  • Data modeling (normalized and dimensional) using various data modeling 
  • tools/technologies 
  • Analyzing and developing data requirements and data specifications and translating them into data warehouse schemas 
  • Creating, mapping and documenting data within organization (source,targets, transformation rules, etc.) 
  • Hands-on experience in developing solutions within Greenplum database (or equivalent relevant experience) 
  • Leading the evaluation and selection of all related infrastructure components such as software, hardware, database management systems and networking capabilities related to enterprise's information architecture. 
  • Project coordination/team leadership and mentoring background is required (or equivalent relevant experience)


The Castlight Health Difference
  • Dynamic leadership grounded in Mission and Values. Clearly defined goals for you, with routine opportunities for feedback
  • Diverse, team-driven culture that thrives on fun
  • Commitment to employee development
  • High growth entrepreneurial environment
  • A commitment to the greater good: opportunity to participate in and lead community events
  • Opportunity to help change U.S. Healthcare
  • Unlimited time off policy
  • 100% paid employee health benefit premiums
The Castlight Co de

Our values are intrinsic to what we do - we call them the Castlight Code. The code is embedded deep within our organization and defines who we are.

  • START WITH THE CUSTOMER: The customer is at the core of everything we do. We're on this journey together. Earn their trust.
  • RAISE THE BAR AND DELIVER: We get better, every time.  Own the outcome.  Stay curious.
  • CHANGING HEALTHCARE IS A TEAM SPORT: We can't do it alone. This is our moment - seize it. Play hard.
  • BRING IT ON: We are rebels with a cause. It is in our DNA to tackle big problems. Endurance is critical to success.
  • WE ARE FAMILY: Come as you are. Be a steward. Welcome hard conversations. Here, we hug.

EEOC Statement
Castlight Health provides equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, pregnancy, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, Castlight Health will provide reasonable accommodations for qualified individuals with disabilities.