Data Engineer
Primary stack
Nice to have's
Job description
Data Engineer
About Weltrade
Weltrade is a leading international Fintech company with over two decades of stability and trust in the global FX and online trading industry. Established in 2006, we operate as a truly global, remote-first organization, bringing together high-performing professionals across multiple time zones. We focus on building scalable trading infrastructure and high-impact commercial ecosystems that drive sustainable client acquisition worldwide. At Weltrade, we value ownership, autonomy, and measurable impact.
About your Role
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.
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.
- Wellbeing: Well-balanced leave allowance (paid vacation, sick leave, public holidays, etc.) and a supportive culture that values every employee.
Recruitment Process
Application Review → HR Interview → Technical Interview → Final Interview → Offer
Apply now
© Weltrade. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
Weltrade — a global financial services provider with a suite of financial products, including an innovative brokerage platform. Trusted by millions of traders around the world, Weltrade is dedicated to providing a transparent brokerage platform for partners and users, and features products and offerings including synthetic indices, copy trading, round-the-clock support, real-time market analysis, automated trading options, ensuring that traders can confidently navigate the complexities of the financial markets.