Skip to main content

Data Analytics Engineer (m/f/d)

Berlin
Full-time
Permanent employee
60,000 - 75,000 € per year

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.


Must-Have Skills

 Redshift, or BigQuery), including partitioning and clustering concepts.

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

About us

Adsquare is the global audience & location intelligence company making marketing a whole lot smarter.

With eight offices around the world we are a truly international company but one united team working towards our vision: empowering companies to accelerate business growth by staying at the forefront of data-driven marketing. 

We are pioneers in advertising and data. We were born mobile, before it was a necessity, and have pioneered data-driven advertising in display and now DOOH. We have the smartest people, working with the best tech, so we can drive the pace of change.

We are visionaries. We see a better way for marketers and are doing everything we can to make that a reality. We believe in innovation and the power of technology. We believe in constantly improving what we’re doing because the work is never done.

We believe in what we do and rise to meet our own high standards. If there’s a problem, we fix it, humbly and without fuss or delay. Although our technology is best-of-breed, we are unassuming and modest in our approach.

We are passionately candid, both with each other and with our clients. We take the time to explain our approach to their problem, confident there is nothing to hide.

We are consistent and true to our word. We don’t take shortcuts but focus on being our clients’ most reliable partner. We make promises - and we keep them. As a result, clients enjoy spending time with us, because we are good people.