Information and Referral Federation of Los Angeles County (DBA 211 LA) Logo
In-Office or Remote
Hiring Remotely in 91101, Pasadena, CA, USA
95K-95K Annually
Senior level
In-Office or Remote
Hiring Remotely in 91101, Pasadena, CA, USA
95K-95K Annually
Senior level
The Senior Data Analyst develops advanced SQL analyses, maintains Tableau and Hex dashboards, validates warehouse metrics, and translates data into actionable recommendations for executives, funders, government audiences, and community partners. The role emphasizes data storytelling, reporting standards, secure PII-aware delivery, stakeholder collaboration, and business impact evaluation. It also offers growth into AI-assisted analytics, custom visualization, and data-to-report automation.
The summary above was generated by AI
Senior Data Analyst

Data, Artificial Intelligence, & Solutions (DAIS) • Full-Time • Remote

211 LA is a dynamic, forward-thinking organization committed to fostering a culture of innovation, inclusivity, and professional growth. As a leader in Information and Referral Services, we take pride in providing our employees with a supportive and collaborative environment where they can thrive and contribute to the success of our organization.

The Senior Data Analyst is a key role on the 211 LA DAIS team, focused on turning 211

LA’s data into actionable, valuable business insights that inform decisions across the organization and for the leadership, county officials, funders, and community partners we serve. Working within the Agency's governed data warehouse environment (dbt + Amazon Redshift), the Senior Data Analyst develops complex SQL queries, designs and maintains trusted reports and dashboards using Tableau and Hex, and transforms data into actionable insights. This role goes beyond reporting by identifying trends, evaluating business impacts, and providing clear, data-driven recommendations that support strategic decision making across the organization. Over time, this role will grow toward advanced, AI-assisted data visualization and storytelling as we mature that capability in-house. We’re looking for someone who pairs analytical rigor with strong business judgment and a commitment to bringing top-quality work to the nonprofit social services sector.

Position Details

Position: Senior Data Analyst

Reports To: Director of Data and Digital Systems

Department: Technology

Employment Type: Full-Time, Exempt

Location: Remote

Key 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.
QualificationsQualificationsBasic Qualifications
  • 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.
Preferred Qualifications
  • 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
Compensation

$95,000 annually, commensurate with experience.

Benefits
  • Comprehensive health and wellness benefits
  • Retirement savings plan
  • Professional development opportunities
  • Flexible work arrangements
  • Employee assistance program
Physical Demands & Working Conditions

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

  • Ability to lift up to 20 pounds.
  • Prolonged periods sitting at a desk and working on a computer.

During normal operations, this position will work 8 hours per day, 40 hours per week, during normal business hours (9 am - 5 pm Pacific time).

However, 211LA is a frontline responder during disaster events in the Los Angeles area. As such, there will be times that the Senior Data Analyst will be required to work longer days and/or during weekends to support 211LA’s disaster response. 
 

Equal Opportunity Employer

211LA is an Equal Opportunity Employer and values diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

 


HQ

Information and Referral Federation of Los Angeles County (DBA 211 LA) San Gabriel, California, USA Office

San Gabriel, CA, United States

Similar Jobs

23 Days Ago
In-Office or Remote
133K-158K Annually
Senior level
133K-158K Annually
Senior level
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Senior Data Analyst responsible for building financial reporting data models, business logic, reporting layers, and automated solutions supporting regulatory compliance. Partners with product, engineering, accounting, treasury, and finance teams to investigate data issues, improve financial system transparency, resolve reporting problems, and communicate findings to technical and non-technical audiences.
Top Skills: PythonRSQLSuperset
Yesterday
In-Office or Remote
105K-180K Annually
Senior level
105K-180K Annually
Senior level
Insurance
Performs complex cross-functional analyses supporting underwriting, claims, portfolio performance, and business strategy. Uses SQL and Python to improve reporting reliability, data consistency, KPI governance, dashboards, and analytical frameworks. Partners with BI leadership and Data Engineering, troubleshoots data issues, documents reproducible outputs, and guides other analysts. At Level II, independently leads analytical initiatives, influences senior stakeholders, and mentors analysts.
Top Skills: LookerPythonSQL
4 Days Ago
Remote
United States
150K-175K Annually
Senior level
150K-175K Annually
Senior level
Healthtech
Own company-wide analytics covering growth, conversion, care utilization, clinical outcomes, retention, and operational performance. Build executive dashboards, define consistent metrics, transform operational data into analysis-ready datasets, monitor data quality, troubleshoot pipelines, and develop the analytics roadmap. Partner with leadership and engineering to deliver complex SQL and Python analyses, strategic insights, and trusted reporting while advancing AI-enabled workflows.
Top Skills: AIBigQueryDbtGitHipaaHolisticsLlmLookerPower BIPythonRedshiftSigmaSnowflakeSQLTableau

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account