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

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.

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