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

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in SQL for data extraction and modeling, with experience in building automated dashboards using Tableau. Familiar with cloud data warehousing in GCP and capable of leveraging tools like Airflow and Looker for data analytics and reporting.

Highest-signal resume keywords

Advanced SQL ProficiencyTableau Dashboard DevelopmentGCP (BigQuery) ExperienceLooker FamiliarityAirflow Basic Understanding

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

SQLETL LogicWindow FunctionsPerformance TuningTableauLookMLPythonData ManipulationData ModelingData Analytics

Tools & Technologies

BigQueryTableauAirflowLooker

Industry Keywords

Business IntelligenceData AnalyticsKPI DefinitionReporting AccuracyData Workflows

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