Apply Now    
Req # 101150

Data Analyst, Customer Outbound Files

San Francisco, CA US

Employee: Full Time Employee
Travel: None
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 240 large enterprise customers, spanning millions of lives, to improve healthcare outcomes, lower costs, and increase benefits satisfaction.

  • Manage process, coordination and scheduling of outbound customer files
  • Provide support to vendors/clients with specific questions they may have
  • Report issues or delays with file delivery to internal/external clients 
  • Troubleshoot and identify issues with ETL data, file formats and jobs
  • Perform data quality checks and report to internal/external clients
  • Maintain documentation of ETL process and support procedures for each client
  • Work with client to make minor changes in data file layouts
  • Strong SQL (MySQL, POSTGRES) skills, ability to write complex queries
  • Strong ability to communicate effectively verbally, in writing, and fluently
  • Strong ability to provide a high level of problem solving and technical troubleshooting
  • Ability to work independently to meet objectives
  • Strong ability to actively collaborate with other support teams for problem resolution
  • Maintain and secure sensitive/confidential information (PHI)
  • Ability to multi-task and prioritize workload
  • R and/or Python familiarity preferred
  • Familiarity with AirFlow is a bonus

We are Castlight and we are…


* Changing healthcare is a team sport

* Teamwork requires respect

* Direct feedback is a gift that improves us

* Diversity makes us stronger

* We take care of ourselves and each other=


* We put our mission first

* We are here to transform healthcare

* We tackle complex problems with curiosity, passion, and ambition

* We bring our best every day

* We learn and grow together


* Done well is better than perfect

* We move fast to accelerate execution and learning

* We are empowered to take action

* We own the outcome

* We win together

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.
Apply Now