Unexpected Awesome Person (f/m/d)

INTRO At Adsquare, our mission is driven by our core focus:  Passion – Solving complex challenges with great people, tech, and data.  Niche – Location Intelligence for Programmatic Advertisers.  Our core values are integral to everything we do: * Drive: We turn ambition into action. * Resilience: We adapt, persevere, and grow stronger. * No BS: We value honesty, transparency, and clear communication. * Humble: We choose modesty over vanity and let results speak for themselves. * Moral Compass: We do the right thing with fairness, integrity, and respect. We seek candidates who not only bring excellent technical expertise but also embody these values in every aspect of their work. YOUR MISSION * Scientific Problem Solving & Deep Dives: Act as an investigative engineer. Formulate hypotheses and dive deep into data, logs, and telemetry to understand analysis results, explain unexpected anomalies, and gather evidence. You won't just move data; you will scrutinize it to understand what is being processed (e.g., identifying when we are processing useless data that drives up costs). * Pipeline Engineering: Build, deploy, and maintain robust transformation pipelines for high-volume data spanning the full lifecycle: ingestion, transformation, testing, deployment, and monitoring. * Optimization & SQL Mastery: Write highly efficient code and relentlessly optimize SQL queries. You will analyze query execution plans, refactor legacy systems, eliminate redundancies, and improve pipeline efficiency to reduce cloud compute costs (e.g., optimizing Athena/Snowflake/Redshift clustering or AWS Glue jobs). * AI-Augmented Engineering: Responsibly and intelligently leverage agentic AI tools (CLI or IDE-based) as core instruments in your daily workflow for more efficient planning, architecting, and implementation of features. * Data Quality & Observability: Focus on infrastructure monitoring and telemetry rather than just business dashboards. Implement robust alerts and checks (e.g., dbt tests, Great Expectations) to catch data quality issues at the source. * Software Engineering Best Practices: Adhere to and promote technical rigor using CI/CD workflows, containerization (Docker), and automated testing. Collaborate with Senior Engineers on architecture and code reviews. YOUR PROFILE We are looking for a Data Analytics Engineer who approaches data with a software engineering mindset. You will join our Data Solutions squad to build and maintain production-grade data platforms. This is not a Data Analyst role. While you will understand the business context, your primary focus is technical: building scalable workflows, writing clean and testable Python/SQL code, automating deployments, and supporting cloud infrastructure optimizations. You will ensure our pipelines remain reliable, cost-effective, and maintainable. We are looking for a candidate who has solid analytics engineering experience or a strong background in backend development focused on data. WHAT YOU WILL DO We are looking for a Data Analytics Engineer who approaches data with a software engineering mindset but thinks like a scientist. You will join our Data Solutions squad to build and maintain production-grade data platforms. We are seeking proactive, inquisitive problem solvers who look well beyond the surface of a task. We want engineers who ask "why?", formulate hypotheses, and closely examine the data itself to understand underlying pipeline behaviors. You know that a pipeline's efficiency is directly tied to the nature of the data flowing through it, and you gather empirical evidence to guide your architectural decisions. While you understand the business context, your primary focus is technical and analytical: building scalable workflows, diagnosing complex data issues through evidence gathering, writing exceptional Python/SQL code, and optimizing cloud infrastructure. MUST-HAVE SKILLS * Rigorous Educational Background: At least a B.Sc. (M.Sc. or Ph.D. strongly preferred) in Computer Science, Mathematics, Physics, Neuroscience, Economics, or another empirical science field that emphasizes the scientific method and evidence-based problem solving. * Experience: 2+ years of experience specifically in Analytics Engineering, Data Engineering, or backend development heavily focused on data. * Scientific & Analytical Mindset: Proven ability to work hypothesis-driven, dissecting logs, telemetry, and raw data to solve complex problems and explain unexpected pipeline behaviors. * Excellent Python Proficiency: You have deep experience developing and deploying production-grade Python code. You are highly skilled in both object-oriented and functional programming paradigms, write modular code, utilize advanced testing libraries, and deeply understand exception handling, logging, and system optimization. * Advanced SQL & dbt: Exceptional ability to build scalable data models (Jinja templating, macros, incremental strategies). You have a deep understanding of query execution plans and a track record of rigorous SQL query optimization. * Agentic AI Proficiency: Demonstrated ability to smartly and responsibly utilize agentic AI coding assistants to accelerate development and architecture—this is a core requirement, not a novelty. * Software Engineering Fundamentals: Hands-on experience with Git flows, CI/CD pipelines (e.g., GitHub Actions, GitLab CI), and Containerization (Docker). * AWS Cloud Native Experience: Experience building and maintaining data workflows using serverless architectures such as AWS Lambda, StepFunctions, Glue, and Athena. * Testing Mindset: Experience implementing Unit Tests and Integration Tests for data pipelines rather than relying solely on manual checks. * Data Warehouse Ops: Solid understanding of warehousing architecture (Snowflake, Redshift, or BigQuery), including partitioning and clustering concepts. NICE TO HAVE * Infrastructure as Code: Experience with Terraform to manage cloud resources. * Orchestration: Experience with modern data orchestration tools like Airflow, Dagster, or Prefect. * Big Data: Knowledge of big data processing frameworks (Spark/PySpark). * Dashboarding: Familiarity with visualization tools (Streamlit, Preset, Tableau, etc.) primarily used for debugging and system monitoring. WHY US? On top of a competitive package… * We are open to flexible work models: we work in a hybrid mode and remotely from anywhere in the world up to 3 months per year. * To encourage education and professional growth, we offer an individual yearly budget of 1.200€. * You are entitled to 30 vacation days per year. * We offer Urban Sports Club membership, company pension scheme. * Regular team events and company events organised by our People team (Trust us, they know how to throw a party!). * We equip you with the latest hardware and provide you with all the tools you need to thrive. SALARY RANGE (ANNUAL ON-TARGET EARNINGS) 60,000 - 75,000 euros RECRUITING PROCESS For technical roles (Data, Engineering, and Product), candidates are encouraged to upload any technical certifications referenced in their CV via the "Other Documents" section of the application form. Alternatively, certification documents may be submitted after the first technical interview. Any certifications listed on the CV must be provided and successfully validated before proceeding to the second technical interview stage. * Step 1: Online quizzes (45 mins). * Step 2: Value-based interview (30 mins). * Step 3: Deep-dive technical interview (1.5 hours) with the Data team. * Step 4: Practical data-crunching challenge. * Step 5: Team Meet & Greet — the final step to ensure we're a great fit for each other. WORK MODEL Hybrid DESIRED START DATE As soon as possible

Join Choco, where we build and own solutions that reshape a broken food system. The global food supply chain is inefficient by design. Waste is high, margins are thin, and most distributor order processes are done over the phone, tracked across broad spreadsheets, and based on intuition rather than strong data. At Choco, we’re changing that. We build software used daily by food distributors and their customers to run their business. It automates orders, reduces errors, and helps operations run faster and more reliably. Because it’s embedded in daily operations, our SaaS platform has immediate, real-world impact, on efficiency, margins, and how businesses run day to day. But great software alone isn't enough. People need an environment where they can do their best work. As our Workplace & Culture Intern, you'll own the day-to-day operations of our Berlin office. You'll make sure around 80–90 colleagues can focus on solving hard problems instead of worrying about broken meeting rooms, missing equipment, onboarding logistics, or operational distractions. This isn't an internship where you'll spend your time observing. You'll become the go-to person for keeping our office running, making practical decisions every day, and taking ownership of problems until they're solved. WHAT YOU'LL DO * Own the day-to-day operations of our Berlin office, ensuring it stays organized, functional, and welcoming. * Coordinate vendors, deliveries, office supplies, maintenance, and workplace requests from start to finish. * Prepare onboarding logistics so every new joiner has everything they need before day one. * Plan and execute office events and employee activities within agreed budgets and objectives. * Prioritize competing requests, solve unexpected operational issues, and know when to escalate. * Maintain clear documentation so workplace processes remain reliable and easy to hand over. * Identify practical improvements that make the office work better for everyone. WHAT YOU BRING * You're currently studying and available for a full-time internship of at least five months (ideally six). * You've taken ownership in fast-paced, service-oriented environments such as hospitality, retail, events, customer service, office support, or similar roles. * You stay organized when priorities change, enjoy solving practical problems, and don't wait to be told every next step. * You communicate confidently with colleagues, vendors, and external partners. * You're fluent in both German and English. WHAT YOU GET * Work on digitalizing core operating systems for food distributors, automating orders, sales and payments in a system that still largely runs on calls and spreadsheets. * Work with an AI product with proven product–market fit, already embedded in distributor workflows and directly affecting order accuracy, speed, and margins. * Join a global team across 6 countries and 40+ nationalities, building a company that has raised $300M+ and reached unicorn status (~$1.2B valuation) with the ambition to define this category end-to-end. * In return, you get real ownership, equity, and the support to do your best work, including competitive compensation, health and wellbeing support, and long-term benefits like a sabbatical (all localized by office). * Collaborate with people who want to own outcomes in a messy, real-world system and make it work at scale. If you want to work on real problems, take ownership, and raise the bar, we should talk. Choco is an equal opportunity employer. We encourage people from all backgrounds to apply. We are committed to ensuring that our technology is available and accessible to everyone. All employment decisions are made without regard to race, color, national origin, ancestry, sex, gender, gender identity or expression, sexual orientation, age, genetic information, religion, disability, medical condition, pregnancy, marital status, family status, veteran status, or any other characteristic protected by law.