Data Analytics Engineer (m/f/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:

• Drive – We turn ambition into action
• Resilience – We adapt, persevere, and grow stronger
• No BS – We value honesty, transparency, and clear communication
• Humble – We let results speak for themselves
• Moral Compass – We do the right thing with fairness, integrity, and respect

Your Mission

You will join our Data Solutions squad to build and maintain production-grade data platforms. This is not a Data Analyst role — your primary focus is technical: building scalable workflows, writing clean and testable Python/SQL code, automating deployments, and supporting cloud infrastructure optimisations.

Key Responsibilities

• Build, deploy, and maintain robust transformation pipelines for high-volume data (full lifecycle: ingestion, transformation, testing, deployment, monitoring)
• Write highly efficient code and refactor legacy systems to improve performance and reduce cloud compute costs (Athena, Snowflake, Redshift, AWS Glue)
• Adhere to and promote CI/CD workflows, containerisation (Docker), and automated testing
• Implement data quality alerts and checks (dbt tests, Great Expectations) before issues reach stakeholders
• Work closely with Senior Engineers on architecture planning, code reviews, and engineering rigour

Must-Have Skills

• 2+ years in Analytics Engineering or Data Engineering
• Solid Python proficiency (modular, OOP, testing libraries, exception handling, logging)
• Strong SQL & dbt skills (Jinja templating, macros, incremental strategies, query execution plans)
• Git flows, CI/CD pipelines (GitHub Actions / GitLab CI), Docker
• AWS Cloud Native: Lambda, StepFunctions, Glue, Athena
• Unit & Integration testing for data pipelines
• Data warehouse architecture: Snowflake, Redshift, or BigQuery (partitioning & clustering)

Nice to Have

• Terraform (Infrastructure as Code)
• Orchestration tools: Airflow, Dagster, or Prefect
• Big data frameworks: Spark / PySpark
• Agentic coding CLI/IDE tools
• Dashboarding: Streamlit, Preset, Tableau
• B.S./M.S. in Computer Science, Engineering, or Mathematics

Yearly OTE: €60,000 – €75,000

What We Offer

• Hybrid + remote from anywhere up to 3 months/year
• €1,200 yearly learning & development budget
• 30 vacation days
• Urban Sports Club membership + company pension scheme
• Latest hardware provided
• Regular team & company events

Recruiting Process

1. Value-based interview (30 min)
2. Deep-dive technical interview (1.5 hrs) with the Data team
3. Practical data-crunching challenge
4. Team Meet & Greet

Berlin | Hybrid | Start: ASAP