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

Key Responsibilities* Pipeline Engineering: Build, deploy, and maintain robust transformation pipelines for high-volume data. You will participate in the full lifecycle: ingestion, transformation, testing (unit/integration), deployment, and monitoring.

• Optimization & Maintenance: Write highly efficient code and collaborate with the team to refactor legacy systems, helping to improve performance and reduce cloud compute costs (e.g., optimizing Athena/Snowflake/Redshift clustering or AWS Glue jobs).
• Software Engineering Best Practices: Adhere to and promote the team's technical standards by actively utilizing CI/CD workflows, containerization (Docker), and automated testing.
• Data Quality & Observability: Focus on infrastructure monitoring rather than just business dashboards. You will implement alerts and checks (e.g., dbt tests, Great Expectations) to catch data quality issues before they reach stakeholders.
• Collaboration & Growth: Work closely with Senior Engineers to plan architectures, participate actively in code reviews, and advocate for engineering rigor within the squad. 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* 2+ years of experience specifically in Analytics Engineering or Data Engineering.

• Solid Python proficiency: You write modular, object-oriented code, utilize relevant libraries for testing, and understand exception handling and logging.
• Strong skills in SQL & dbt: You can build scalable data models (Jinja templating, macros, incremental strategies) and understand query execution plans.
• 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 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

• Experience with Infrastructure as Code (Terraform) to manage cloud resources.
• Experience with orchestration tools like Airflow, Dagster, or Prefect.
• Knowledge of big data processing fra