Analyst II, Analytics
Castlight Health · Ohio, United States · 3 mo ago
Business Development$64k–$111k/yrFull-time
How Will You Make An Impact
- Data Analysis & Modeling: Write and optimize complex SQL queries in BigQuery to extract, clean, and model data for reporting.
- Visualization: Design, build, and maintain high-performance automated dashboards in Tableau.
- Pipeline Monitoring: Interface with Airflow to monitor data workflows and ensure reporting accuracy and freshness.
- Stakeholder Collaboration: Partner with business leaders to define KPIs and present findings that drive departmental strategy.
- Continuous Improvement: Assist in the potential migration or implementation of Looker for self-service analytics.
Requirements
- 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 (preferred).
- Basic understanding of Airflow for scheduling and monitoring data pipelines (preferred).
- Experience with Python for data manipulation or automation (preferred).