BigQuery Analytics Engineer: SQL, Data Cleaning & Pipeline Maintenance

Beglaubigt.de is a German legal-tech company (digital company formations, online notarizations, certified translations) with an API-driven product stack and partners like Qonto and Holvi. We're expanding our in-house data team and need a BigQuery specialist to own data quality and transformation. Ongoing role alongside our existing automation and tracking freelancers. Our data lands from multiple sources (GA4/tracking, our incorporation API, and internal automation pipelines), so clean, well-documented data is the core of this role. What you'll own: - Writing and optimizing SQL in BigQuery for reporting and downstream use - Cleaning and validating messy incoming data (deduping, standardizing, handling nulls/schema drift) - Modeling data across sources (GA4 export, incorporation/notarization events, automation pipelines) into reliable datasets - Building and maintaining transformation logic and scheduled queries - Documenting datasets so the rest of the team can trust and reuse them - Keeping data handling aligned with our GDPR / EU data-residency requirements You're a fit if you: - Have real BigQuery experience (partitioning, cost-aware queries, scheduled queries), not just generic SQL - Have cleaned genuinely messy datasets and can describe your approach - Write clear, maintainable, documented SQL - Overlap several hours with IST Nice to have: dbt, Python for data prep, experience with the GA4 BigQuery export schema, experience working under GDPR/EU data constraints. To start, we'll run a short paid test task (a real cleaning/query problem from our data) before moving to ongoing work.