Senior Data Analyst (m/f/x)

About This RoleAI processing…

Key Responsibilities

• 1
  Technical Investigation & Forensics: Identify and resolve data discrepancies. If a metric looks "off," you'll use your knowledge of web/app technologies (inspecting network requests, tracking pixels, or API responses) to find the root cause.
• 2
  Deep-Dive Community Analytics: Analyze complex member behaviors—retention cohorts, engagement velocity, and viral loops—to drive community growth.
• 3
  Data Science & Modeling: Move beyond descriptive stats by building and deploying models (e.g., Churn Prediction, Sentiment Analysis, or Member Segmentation) using Python.
• 4
  High-Performance SQL: Master our ClickHouse environment, writing optimized queries that leverage columnar storage to process billions of rows of interaction data.
• 5
  Data Hygiene: Audit "dirty" data and build robust logic to handle bot activity, duplicate identities, and tracking gaps.

Requirements

• Expert SQL: Advanced mastery of SQL (CTEs, Window Functions, Optimization) specifically for columnar databases (ClickHouse experience is a massive plus).
• Web/App Technical Literacy: Basic understanding of how web/app tracking works. You should be comfortable using tools to inspect network payloads and debug event triggers.
• Analytical Intuition: A "sixth sense" for spotting data anomalies and the tenacity to investigate them until they are solved.
• Workflow Automation: Basic knowledge of Airflow for scheduling analytical scripts.
• Data Science Toolkit: Proficiency in Python (Pandas, Scikit-learn) for statistical modeling and complex data manipulation.
• Community Domain Knowledge: Experience analyzing developer communities, forums, or social platforms.

Perks & Benefits