Staff 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 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 top-tier technical expertise but also embody these values in every aspect of their work. Your tasks About the team We are looking for a Staff Data Analytics Engineer to join our technical proficiency track. This is a highly technical, Individual Contributor (IC) role. You will act as the Technical Lead for your squad—making critical architectural decisions, defining engineering standards, and driving cross-squad collaboration—without the responsibilities of people management. You will be the technical north star for the team, approaching extremely complex data problems with a rigorous software engineering mindset. You will design, build, and oversee production-grade data platforms that process massive volumes of geo-spatial data, audience attributes, and geo-location time-series data.

What you will do Technical Leadership & Architecture:

Act as the principal architect for your squad. You will design horizontally scalable, cost-efficient, production-grade data solutions capable of handling TB-scale, highly dimensional datasets. Engineering Excellence & TDD: Champion rigorous software engineering principles. You will lead the adoption of Test-Driven Development (TDD), CI/CD workflows, and clean code architectures. You ensure our codebase is resilient, testable, and maintainable. Cross-Squad Impact: Drive technical alignment beyond your immediate team. You will act as an engineering ambassador, solving architectural issues that span multiple squads, keeping our technical processes synchronized, and aligning your squad's work with global engineering priorities. Domain Mastery: Leverage your deep expertise to build high-value data products on top of location signals and audience attributes. You don't just process data; you deeply understand its geographic and time-series nature to unlock its business value. Mentorship & Code Quality: Be the technical mentor for Senior, Mid, and Junior engineers. Through highly insightful code reviews, architectural feedback, and pair programming, your input will consistently be the source of others’ learning and growth. Data Observability: Proactively build monitoring and alerting frameworks at the infrastructure level to catch anomalies in our multi-terabyte data streams before they impact downstream products. Your profile Your Profile We are looking for an exceptional engineer who has a proven track record of acting as a technical leader and domain expert in heavy data environments. Must-Have Skills: 7+ years of experience in Data Engineering, Analytics Engineering, or Backend Development with a deep focus on massive data systems. Geo-Spatial & Time-Series Expertise: Proven, hands-on experience handling massive datasets specifically involving geo-spatial (GIS) data, audience attributes, and high-frequency time-series data. Advanced Software Engineering (Python): Mastery of Python beyond standard data scripting. You write highly modular, object-oriented code. You have deep, practical experience with Test-Driven Development (TDD) , mocking, exception handling, and performance profiling, functional programming. Architectural Vision: Deep expertise in designing scalable data architectures using both relational and horizontally scalable data warehouses/lakehouses (e.g., Snowflake, Redshift, Athena, StarRocks, Iceberg). You deeply understand query execution plans, partitioning, clustering, and cloud cost governance. Big Data Frameworks: Extensive experience with large-scale data processing frameworks (e.g., Apache Spark, PySpark, AWS EMR, Glue) to handle massive throughput. Expert SQL & dbt: You design scalable, robust data models (using Jinja, macros, incremental strategies) that serve as the foundation for our entire analytics layer. AWS Cloud Native & IaC: Hands-on experience building architectures in AWS (e.g.: AWS Lambda, AWS Batch, Glue, StepFunctions, S3, EC2, ECS, ECR, Fargate) and deploying them using Infrastructure as Code (Terraform). Leadership Skills: Superb organizational and communication skills. You can distill complex architectural trade-offs for non-technical stakeholders and drive technical consensus among your engineering peers. Nice-to-Have Skills: Polyglot Programming: Experience with a compiled or strongly typed language (e.g., Scala, Go, Kotlin, C++ or Java). Advanced Orchestration: Experience defining complex dependency graphs in tools like Airflow, Dagster, or Prefect.