Analyst II, Analytics

Castlight Health

Data-driven Analyst II at Castlight Health developing insights from data analysis and visualization. Utilizing SQL and Tableau to enhance decision-making via executive-level dashboards.

Posted 7/11/2026full-timeRemote • California, Ohio, Texas, Utah • 🇺🇸 United StatesJuniorMid-Level💰 $63,982 - $111,125 per yearWebsite

Tech Stack

Tools & technologies

AirflowBigQueryCloudETLGoogle Cloud PlatformPythonSQLTableau

About the role

Key responsibilities & impact

Write and optimize complex SQL queries in BigQuery to extract, clean, and model data for reporting.
Design, build, and maintain high-performance automated dashboards in Tableau.
Interface with Airflow to monitor data workflows and ensure reporting accuracy and freshness.
Partner with business leaders to define KPIs and present findings that drive departmental strategy.
Assist in the potential migration or implementation of Looker for self-service analytics.

Requirements

What you’ll need

2–4 years of experience in data analytics or business intelligence.
Advanced proficiency in SQL (ETL logic, window functions, and performance tuning).
Hands-on experience building production-level dashboards in Tableau.
Experience working within GCP (BigQuery) or a similar cloud data warehouse.
Familiarity with Looker (LookML) or other modern BI modeling layers.
Basic understanding of Airflow for scheduling and monitoring data pipelines.
Experience with Python for data manipulation or automation.

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETL LogicWindow FunctionsPerformance TuningTableauLookMLPythonData ManipulationData ModelingData Analytics