Data Engineer

Data Engineer

---

About Weltrade
Weltrade is a leading international Fintech innovator with over two decades of stability and trust. Established in 2006, we are committed to providing secure, efficient, and accessible trading solutions in the global FX and online trading market. We operate as a truly global, remote-first team across different time zones, united by a culture of autonomy and shared goals.
We are currently seeking proactive specialists to join our cross-functional environment. At Weltrade, we offer impact, ownership, and the stability to do your best work. We are a flat organization where empowered professionals are trusted to design the future of global trading.

Role Overview
As a Data Engineer, you will own the company's data warehouse and the pipelines that power analytics, marketing attribution, and product reporting. You'll design and maintain scalable data models and ELT pipelines in BigQuery using dbt and Airflow, transforming raw data into reliable, business-ready datasets. Working closely with analysts and stakeholders, you'll ensure data quality, optimize performance, and help build a trusted foundation for data-driven decision-making.

Responsibilities
- Design, build, and maintain data models and the DWH layering (raw → staging → core → mart) in BigQuery.
- Develop and orchestrate ELT pipelines with dbt and Airflow — incremental loads, idempotent/re-runnable jobs, backfills.
- Model data using established methodologies (Kimball, Inmon, Data Vault, Anchor modeling) and choose the right approach per use case.
- Implement data quality checks, tests, and monitoring; investigate and fix pipeline failures.
- Manage schema evolution and breaking changes from upstream sources.
- Optimize warehouse performance and cost (partitioning, clustering, query tuning).
- Document data lineage and models; collaborate with analysts and stakeholders on the source of truth for metrics.

Requirements
- Strong SQL (joins, window functions, delta/change detection) and solid Python.
- Hands-on experience with BigQuery (or a comparable cloud DWH).
- Production experience with dbt: models, tests, macros.
- Orchestration experience with Airflow (or equivalent).
- Data modeling expertise: Kimball / Inmon / Data Vault / Anchor modeling, and reasoning about layer boundaries and trade-offs.
- ELT/ETL design: incremental extraction, backfills, schema evolution.
- Experience with data quality, testing, and pipeline monitoring.

Nice to have
- Integration with ad-platform APIs / advertising cabinets (Google Ads, Facebook/Meta) and marketing attribution data.
- Experience building AI/LLM data pipelines.
- Experience building agents / agentic workflows.
- Product analytics exposure (AppsFlyer, GTM, server-to-server, enhanced conversions).
- CI/CD for data pipelines.

What We Offer

• Remote-First Flexibility: We operate fully remotely and offer a global and cross-functional environment.
• Ownership & Impact: A chance to own ideas and make a measurable impact on organizational growth and client experience.
• A Flat Organization: We foster a collaborative culture where specialists are trusted to contribute, challenge, and improve processes.
• Wellbeing: Well-balanced leave allowance (paid vacation, sick leave, public holidays, etc.) and a supportive culture that values every employee.