Software Engineer - Data & Full Stack; f​/m​/x

What are the main performance objectives in this role?

This role sits inside our 5-person Engineering team, running the high-volume data platform behind our mobile OEM advertising business: nightly ETL pipelines pulling from 10+ mobile attribution and ad-network partners (Apps Flyer, Adjust, Everflow, Kochava, Huawei, Xiaomi, Oppo, Vivo, Mintegral), an Amazon Redshift warehouse feeding BI, and our internal full-stack platform (APH) used daily by our media buyers and partner managers.

• Building and maintaining Python ETL pipelines orchestrated on Apache Airflow (Amazon MWAA), running on ECS Fargate: API ingestion, S3 staging, Redshift COPY loads
• Developing and evolving our Redshift star-schema warehouse: fact/dimension modeling, SQL transformation jobs, Flyway schema migrations, query performance tuning (DISTKEY/SORTKEY), data quality and reconciliation checks
• Contributing full stack to our internal platform:
  Spring Boot 3 / Java 21 backend (Web Flux, R2
  
  DBC/PostgreSQL, Redshift analytics reads) and Vue.js frontend (Nuxt, Vuetify)
• Adding integrations with new ad-network and attribution partners end to end: API client → transformer → S3 → Redshift → reporting
• Owning reliability: idempotent re-runnable jobs, structured logging, monitoring/alerting, runbooks, and a light on-call rotation
• Reviewing teammates' PRs and writing reviewable, well-tested changes yourself

Must haves (these are non-negotiable for day one):

• 3–5 years professional software engineering experience with production code in at least two of:
  Python, Java, SQL-heavy data work — and genuine willingness to work in all three
• Strong SQL — comfortable with window functions, CTEs, large joins; experience with a columnar/MPP warehouse (Redshift, Snowflake, Big Query) or deep PostgreSQL experience and the curiosity to learn Redshift's differences
• Python for data pipelines — API clients, pagination/rate-limit handling, pandas or plain transforms, pytest
• AWS fundamentals — S3, IAM basics, and at least one of ECS/Lambda/EC2 in production
• Experience with batch/scheduled data workflows (Airflow preferred; Dagster/Prefect/cron-based acceptable) and an instinct for idempotency and failure handling
• Can read and modify a Java or similar typed backend codebase (Spring Boot a plus; C#/Kotlin backgrounds transfer fine)

Nice-to-haves (valuable, but not required):

• Amazon MWAA specifically, or self-managed Airflow at scale
• Redshift specifics: COPY/UNLOAD, DISTKEY/SORTKEY design, WLM, stl_/svl_ system tables
• Spring Web Flux / reactive Java, R2
  
  DBC
• Vue.js/Nuxt experience (React experience transfers)
• Terraform/Terragrunt, Docker, Git Hub Actions
• dbt or similar transformation frameworks
• Ad-tech / mobile attribution domain: MMPs (Apps Flyer, Adjust, Kochava), affiliate platforms (Everflow), postbacks, attribution windows, cost/revenue reconciliation
• Flyway or comparable migration tooling

• We know that individuals who identify as women, trans, or non-binary tend to hesitate to apply for a role unless they meet almost all the requirements. If that resonates with you, we want to be clear: we're more interested in your potential than your ability to tick every box. Apply anyway.
• On compensation:
  At AVOW, pay is structured around a clear grade and level framework, with decisions based on objective criteria: your experience, qualifications, scope of responsibility, and role-specific requirements. We're transparent about how we make these decisions and will be discussing the details from our very first engagement.

• Intro call: A casual conversation with our TA team. We'll tell you about the role and the team; you tell us about…