Senior Data Analyst, 9amHealth

• We are looking for someone who does not wait to be told what to analyze. You see a pattern, dig in, form a hypothesis, and bring insights to the table before anyone asks. A strong sense of business context and the curiosity to understand why numbers move is just as important as the technical skills to query them
• 5+ years of professional experience in a data analyst, analytics engineer, or BI-focused role
• Deep expertise in Looker, including strong command of LookML: building and maintaining models, views, explores, derived tables, and parameterized dashboards. This is the primary BI tool for the role
• Expert-level SQL: complex joins, window functions, CTEs, subqueries, and query performance tuning. You should be comfortable writing SQL as your primary analytical language
• Strong Python skills for data analysis, scripting, and automation. You should be able to write clean, well-structured Python to query databases, transform data, build automated reports, and support analytical workflows
• Proficiency with AI-assisted development and analytics tools (e.g., Claude, ChatGPT, GitHub Copilot, Cursor). You should already be using AI to write code faster, explore data more efficiently, and improve the quality of your analytical output
• Strong appetite for integrating AI into analytics workflows. You actively look for opportunities where AI can automate, enhance, or transform how data is analyzed and delivered, and you are comfortable experimenting with new tools and approaches
• Self-starter mentality: you proactively identify problems, dig into data without being asked, form hypotheses, and bring insights to stakeholders with actionable recommendations
• Strong business acumen and the ability to understand the "so what" behind the numbers. You can connect data patterns to business outcomes and communicate findings to non-technical stakeholders
• Experience building and delivering recurring client or stakeholder reports (e.g., QBRs, executive dashboards, performance reviews)
• Excellent communication and presentation skills, with the ability to tailor the depth and framing of analysis to different audiences (Customer Success, clients, leadership)
• Familiarity with cloud data warehouses (Redshift preferred) and data lake concepts (S3, Parquet)

Desirable

• We are looking for a Data Analyst to join our Data & Analytics team and become the analytics partner to our Customer Success organization. Your primary mission: ensure that the clients we serve (large employers and health plans) receive best-in-class reporting, from recurring Quarterly Business Reviews to ad hoc analyses that answer the questions they care about most
• You will own the reporting lifecycle end to end. That means building the data models and dashboards in Looker, writing the Python and SQL that power them, and sitting with Customer Success to understand what story the data needs to tell
• We also expect this person to actively leverage AI tools in their daily analytics work and to identify opportunities where AI can improve our reporting, analysis, and client deliverables
• Whether that means using AI-assisted coding to accelerate development, applying LLMs to summarize or interpret data, or proposing entirely new AI-powered analytics capabilities for our clients, we want someone who sees AI as a force multiplier and is eager to push the boundaries of what our data team can deliver
• Own client-facing analytics: build, maintain, and continuously improve the dashboards and reports used in Quarterly Business Reviews and ad hoc client requests
• Partner closely with the Customer Success team to understand client needs, translate business questions into analytical frameworks, and deliver insights that strengthen client relationships
• Design and build production-quality LookML models, explores, and dashboards in Looker, serving as the team's Looker subject matter expert
• Write complex SQL queries across Redshift, Aurora/MySQL, and Athena to extract, transform, and analyze data at scale
• Develop Python scripts and notebooks for data wrangling, automated reporting, and analytical workflows that go beyond what SQL alone can do
• Leverage AI tools (e.g., Claude, GitHub Copilot, Cursor) in day-to-day analytics work to accelerate query development, code generation, data exploration, and documentation
• Identify and champion AI-powered use cases within the analytics workflow, such as automated anomaly detection, natural-language data summarization, predictive insights for client reporting, or AI-assisted QBR narrative generation
• Proactively explore data to surface trends, anomalies, and opportunities, and present findings with clear business context and actionable recommendations
• Define and monitor data quality metrics for client-facing reporting, ensuring accuracy, consistency, and timeliness
• Collaborate with the Data Engineering team to define data model requirements, validate pipeline outputs, and improve the analytical data layer
• Document reporting logic, data definitions, and analytical methodologies to enable self-service and knowledge sharing across teams
• Contribute to the evolution of our BI strategy, including dashboard governance, naming conventions, and version control practices for LookML