Avow·1 month ago
1 month ago
Software Engineer - Data & Full Stack (f/m/x)
Sign up free to see how well your resume matches this role.
What you'll do
- 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 (WebFlux, R2DBC/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
What they're looking for
- 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, BigQuery) 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 have
- Amazon MWAA specifically, or self-managed Airflow at scale
- Redshift specifics: COPY/UNLOAD, DISTKEY/SORTKEY design, WLM, stl_/svl_ system tables
- Spring WebFlux / reactive Java, R2DBC
- Vue.js/Nuxt experience (React experience transfers)
- Terraform/Terragrunt, Docker, GitHub Actions
- dbt or similar transformation frameworks
- Ad-tech / mobile attribution domain: MMPs (AppsFlyer, Adjust, Kochava), affiliate platforms (Everflow), postbacks, attribution windows, cost/revenue reconciliation
- Flyway or comparable migration tooling
Summarised by NextRaise from the employer’s description, which follows in full below.
Full description from employer
What are the main performance objectives in this role?
What are the strengths, transferable skills, and behaviors that drive success in this role?
What does our hiring process look like?
What do we offer?
Company
Avow
Berlin (Hybrid), Germany
Company facts come from this company's own listings. We only show what the postings themselves carry.