Senior Data Analyst

INFORMATION AND REFERRAL FEDERATION OF LOS ANGELES COUNTY•Pasadena, CA
•$95,000 - $95,000•Remote

About The Position

The Senior Data Analyst is a key member of 211 LA’s Data, Artificial Intelligence, & Solutions (DAIS) team, responsible for turning organizational data into actionable business insights for staff, leadership, county officials, funders, and community partners. The role works within a governed data warehouse environment using dbt and Amazon Redshift, developing complex SQL queries and building and maintaining reports and dashboards in Tableau and Hex. Beyond reporting, the analyst identifies trends, evaluates business impacts, and provides clear, data-driven recommendations to support strategic decisions. As the organization’s capabilities mature, the role will contribute to advanced, AI-assisted data visualization and storytelling. The position partners with program, operations, and leadership stakeholders to translate business questions into useful analyses, and works with leadership and program managers on reports and analytics for external publication or distribution. It is responsible for analytical accuracy, reusable verification and QA practices, consistent reporting standards, clear visual presentation, and secure, PII-aware report delivery. The role is remote, full-time, exempt, and reports to the Director of Data and Digital Systems in the Technology department. The position is normally scheduled for eight hours per day, 40 hours per week, during Pacific business hours, 9 a.m. to 5 p.m. During disaster events in the Los Angeles area, longer days and weekend work may be required. Physical demands include lifting up to 20 pounds and prolonged periods sitting at a desk and working on a computer. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Requirements

  • At least 5 years of experience in data analysis, business intelligence, or a comparable role, with a track record of delivering insights that influenced real decisions.
  • Advanced SQL skills, including PARTITION, geospatial analysis, JSON parsing, and performance tuning.
  • Advanced BI and dashboarding proficiency in Tableau, including LOD expressions, parameters, and publishing, and/or Hex.
  • Experience working from a governed data warehouse such as Redshift or a comparable platform, and comfort with dbt and semantic-layer concepts such as metric definitions, grain, and data contracts.
  • Strong data-storytelling skills, including framing exploratory versus explanatory views, disciplined chart selection, annotation, and explaining the practical significance of findings.
  • Strong business acumen and ability to connect analysis to organizational goals and provide practical, actionable recommendations.
  • Rigorous source-verification habits and attention to data accuracy.
  • Excellent written and verbal communication skills and ability to work directly with executive and external stakeholders.

Nice To Haves

  • Hands-on experience applying AI to analytics, such as using Claude, GitHub Copilot, Cursor, or LLMs to accelerate SQL, analysis, or reporting, with sound judgment in verifying AI output and a security-minded approach.
  • Experience with custom and advanced data visualization beyond BI tools, such as Recharts, shadcn/ui charts, D3, Visx, or Observable Plot.
  • Design craft for data, including typography, color theory, layout, and accessibility practices such as adequate contrast and colorblind-safe palettes.
  • Experience with narrative-web and interactive techniques such as scrollytelling, and live-refresh or connected dashboards.
  • Experience with secure, PII-aware delivery to external audiences, including access control, aggregation thresholds, and governance review.
  • Exposure to dashboards-as-code, semantic-layer tooling, or agentic and multi-step data-to-report pipelines such as MCP.
  • Prior work in health, social services, public-sector, or nonprofit domains.

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 or distribution.
  • Write advanced SQL to explore, transform, and validate data in the governed dbt and Redshift warehouse and its semantic layer.
  • Build and maintain trusted, refreshable reports and dashboards in Tableau and Hex.
  • Turn dashboards into narratives that non-technical audiences can understand and act on.
  • Deliver actionable insights and clear recommendations for executive, funder, and government audiences.
  • Reconcile metrics against their warehouse or semantic-layer sources and maintain a reusable verification and QA checklist before sharing analyses.
  • Define and maintain reporting standards and a lightweight, brand-aligned visual style, including consistent metric definitions, disciplined chart selection, and clear labeling.
  • Support secure, PII-aware delivery of reports to internal and external audiences.
  • Apply advanced SQL techniques, including PARTITION and LOD-style logic, to solve complex, multidimensional stakeholder problems.
  • As the capability matures, contribute to advanced, AI-assisted data storytelling and custom visualization.

Benefits

  • Comprehensive health and wellness benefits
  • Retirement savings plan
  • Professional development opportunities
  • Flexible work arrangements
  • Employee assistance program
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service