About the Role
We are looking for a Senior Data Analyst (Community & Product Forensics) to join our Community Data Team team in Berlin/ Munich and surrounding area. At Atolls, your role will be instrumental in helping us lead our community intelligence and data integrity efforts. You will be our "Data Detective," responsible for performing deep-dive analytics on high-volume event data, ensuring its accuracy, and uncovering insights to drive community growth. As a key part of our team, you'll be directly involved in building and enhancing the digital destinations our users rely on throughout their shopping journeys. Your contributions will help shape how millions of consumers interact with our platforms, guiding them to make smart, fair, and rewarding choices.
Responsibilities
- Identify and resolve data discrepancies using web/app technologies to find the root cause.
- Analyze complex member behaviors like retention cohorts, engagement velocity, and viral loops to drive community growth.
- Build and deploy models for Churn Prediction, Sentiment Analysis, or Member Segmentation using Python.
- Write optimized SQL queries in ClickHouse to process billions of rows of interaction data.
- Audit "dirty" data and build logic to handle bot activity, duplicate identities, and tracking gaps.
Requirements
- Experience in writing complex SQL.
- Experience investigating web/app event data.
- Experience building predictive models in Python.
- Dedication to creating exceptional user experiences and driving innovation.
- Advanced mastery of SQL (CTEs, Window Functions, Optimization) specifically for columnar databases.
- Basic understanding of how web/app tracking works.
- Comfort using tools to inspect network payloads and debug event triggers.
- A "sixth sense" for spotting data anomalies and the tenacity to investigate them.
Skills
- SQL
- ClickHouse
- Python
- Pandas
- Scikit-learn
- Airflow
Location
- Berlin
- Munich
Work Type
- Hybrid
Experience Level
- Senior
Benefits
- Culture that values personal and professional development, with internal mobility opportunities.
- Supportive and open-minded team that embraces diverse perspectives and innovative ideas.
- 32 days of paid vacation plus your birthday off.
- Flexible hybrid working scheme.
- Access to a learning budget and internal training.
- Mental health coaching.
- Regular global and local get-togethers.
- Possibility of taking a sabbatical after three years with the company.
- Cloud-based company setup.
About the Company
- Atolls is the world’s largest community-driven shopping platform, active in 20+ markets.
- We help millions make smarter spending decisions across discovery, evaluation, and (re-)purchase by connecting people with the right brands and retailers.
- Our 1,000+ team across 10 countries builds products used every day at global scale, where you’ll have real ownership and see your impact.
- Want to shape the destinations people rely on to shop with confidence?
Equal Opportunity
- Our employment opportunities are open to every gender, race, religion, age, sexual orientation, ability, place of origin, or socioeconomic status.
- We remain committed to a culture of diversity, equity and belonging, where all employees are welcomed, respected, connected, and engaged.
