Data Engineer

Location: San Francisco, CA

Req #200233

Data Engineer, Strategic Analytics

What is Strategic Analytics?

Strategic Analytics at Castlight is part of a centralized Analytics function, reporting into Product. The team is primarily focused on answering the question: how do we measure the value created by the product, especially as it pertains to medical cost savings? Strategic Analytics builds analytical models that power customer reporting, defines metrics that power product analytics reporting and researches new areas of opportunity for the product.  The team partners closely with key stakeholders across the major functions of the business, including Product, Customer Success, Sales, Marketing, and Engineering to define and tackle the most important questions facing the business. 

What you will do:

* Support the data scientists, actuaries and analysts in developing data pipelines for automation

* Maintain and optimize existing data pipelines to expand capacity without expanding hardware

* Support the workflow management infrastructure, working closely with Data Management and Resilience engineering to ensure timely delivery of upstream data to the analytics environment

* Help analytical teams optimize queries in the various database platforms (Postgres and MySQL)

* Support the optimization of extracts and data models behind the Tableau server

* Create new data models that support multiple reporting and tools to minimize the amount of one-off data sets

* Work with EDW development teams to write requirements and to perform UAT/QA

Skills are we looking for:

* 2 - 5 years’ experience

* Experience with workflow managers (Airflow, Luigi, Oozie, Azkaban, etc.)

* SQL mastery in Postgres and MySQL

* Experience optimizing in an MPP Postgres (Vertica, Redshift, GreenPlum, etc.) and MySQL environments

* Experience with Python and Bash

* Ability to estimate level of effort during sprint planning

* BS or MS in Engineering or Computer Science, or related technical / quantitative field

* Experience supporting analytical teams 

Nice to have:

* Direct experience with

   - Pivotal GreenPlum

   - Apache Airflow

   - MPP data loading

   - MySQL Replication chains

   - Audit principles in data pipelines 

About Castlight Health

Castlight is on a mission to make it as easy as humanly possible to navigate healthcare and live happier, healthier, more productive lives. Our health navigation platform connects with hundreds of health vendors, benefits resources, and plan designs, giving rise to the world's first comprehensive app for all health needs. We guide individuals - based on their unique profile - to the best resources available to them, whether they are healthy, chronically ill, or actively seeking medical care. In doing so, we help companies regain control over rising healthcare costs and get more value from their benefits investments. Castlight revolutionized the healthcare sector with the introduction of data-driven price transparency tools in 2008 and the first consumer-grade well-being platform in 2012. Today, Castlight serves as the health navigation platform for millions of people and is a trusted partner to many of the largest employers in the world.

For more information visit www.castlighthealth.com

Our Values

One team. On a mission. Making things happen.

Diversity and Inclusion

The Castlight culture values and celebrates different backgrounds, perspectives, and points of view. We believe our diversity helps drive creativity and innovation. We strive to make everyone feel included, valued, and engaged; enable them to do their best work; and build their careers here at Castlight. That is why diversity and inclusion are more than just words to us. Rather, they are a commitment to a culture where employees feel respected and empowered to share their ideas and deliver the best results.

Learn more about our continuing commitment to diversity and inclusion.

About Castlight

Castlight is on a mission to make it as easy as humanly possible to navigate healthcare and live happier, healthier, more productive lives. Our health navigation platform connects with hundreds of health vendors, benefits resources, and plan designs, giving rise to the world’s first comprehensive app for all health needs. We guide individuals—based on their unique profile—to the best resources available to them, whether they are healthy, chronically ill, or actively seeking medical care. In doing so, we help companies regain control over rising healthcare costs and get more value from their benefits investments. Castlight revolutionized the healthcare sector with the introduction of data-driven price transparency tools in 2008 and the first consumer-grade wellbeing platform in 2012. Today, Castlight serves as the health navigation platform for millions of people and is a trusted partner to many of the largest employers in the world. We are headquartered in San Francisco, and can be found online at www.castlighthealth.com and on the New York Stock Exchange as CSLT.

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.

Castlight Health does not accept unsolicited assistance from recruitment search firms for employment opportunities. All resumes submitted by search firms to any employee at Castlight Health via email, the Internet or in any form and/or method without a signed search agreement on Castlight’s form in place ahead of time will be deemed the sole property of Castlight Health. In such cases, no fee will be paid or payable in the event the candidate is hired by Castlight as a result of the submission.