Note: The job is a remote job and is open to candidates in USA. 211 LA is hiring a Senior Data Analyst for its Data, Artificial Intelligence, & Solutions team. The role turns organizational data into actionable insights through advanced SQL analysis, trusted reporting and dashboards, and data-driven recommendations for internal and external stakeholders.
Responsibilities
- Partner with program, operations, and leadership stakeholders to translate business questions into analyses that drive decisions
- Work with leadership and program managers to draft and maintain data reports and analytics for external publication/distribution
- Write advanced SQL to explore, transform, and validate data on top of the governed dbt + Redshift warehouse and its semantic layer
- Build and maintain trusted, refreshable reports and dashboards in Tableau and Hex
- Turn dashboards into narratives that a non-technical audience can understand and act on
- Deliver actionable insights and clear recommendations for executive, funder, and government audiences
- Own analysis accuracy: reconcile every metric against its warehouse / semantic-layer source and maintain a reusable verification/QA checklist before anything is shared
- Define and maintain reporting standards and a lightweight, brand-aligned visual style: consistent metric definitions, disciplined chart selection, and clear labeling
- Support secure, PII-aware delivery of reports to both internal and external audiences
- Apply advanced SQL techniques (PARTITION, LOD-style logic) to solve complex, multi-dimensional analytical problems for stakeholders
- As the capability matures, contribute to advanced, AI-assisted data storytelling and custom visualization—a growth path for this role
Skills
- 5+ years in data analysis, business intelligence, or a comparable role, with a track record of delivering insights that influenced real decisions
- Advanced SQL - PARTITION, geospatial, JSON-parsing, and performance tuning
- Advanced BI and dashboarding proficiency in Tableau (LOD expressions, parameters, publishing) and/or Hex
- Experience working from a governed data warehouse—Redshift or comparable—and comfort with dbt / semantic-layer concepts (metric definitions, grain, data contracts)
- Strong data-storytelling skills: framing exploratory vs. explanatory views, disciplined chart selection, annotation, and a clear “so what.”
- Strong business acumen—able to connect analysis to organizational goals and surface practical, actionable recommendations
- Rigorous source-verification habits and attention to data accuracy
- Excellent written and verbal communication; able to work directly with executive and external stakeholders
- Hands-on experience applying AI to analytics work—e.g., using AI-assisted tools (Claude, GitHub Copilot, Cursor) or LLMs to accelerate SQL, analysis, or reporting—with sound judgment about verifying AI output. This is an emerging area; we value curiosity, practical exposure, and thoughtful, security-minded application
- Custom and advanced data visualization beyond BI tools—component libraries (Recharts, shadcn/ui charts) or lower-level libraries (D3, Visx, Observable Plot)
- Design craft for data: typography, color theory, layout, and accessibility (contrast, colorblind-safe palettes)
- Narrative-web and interactive techniques such as scrollytelling, and live-refresh / connected dashboards
- Secure, PII-aware delivery to external audiences: access control, aggregation thresholds, and governance review
- Exposure to dashboards-as-code, semantic-layer tooling, or agentic / multi-step data-to-report pipelines (e.g., with MCP)
- Prior work in health, social services, public-sector, or nonprofit domains
Benefits
- Comprehensive health and wellness benefits
- Retirement savings plan
- Professional development opportunities
- Flexible work arrangements
- Employee assistance program
Company Overview
Company H1B Sponsorship