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.

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.

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/lake houses (e.g., Snowflake, Redshift, Athena, Star Rocks, 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, Step Functions, 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.

• 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…