About the company
Globaldev Group is a team of professionals specializing in creating engineering teams for technological businesses for the Western Europe, Israel, USA. Only long-term product teams for EU with investments and a modern stack of technologies. We set up the company in 2010 in Kharkiv. In 2017 we opened the office in Berlin. Currently, there are 400+ of us and we are constantly growing. Now in 2024 we have development hubs in Israel, Ukraine, Portugal, Armenia and Poland. If youāre interested in joining the team and taking part in decision making that will affect the product and business - let us know!
Job Summary
Key Responsibilities
š1. Pipeline & Ingestion Management šMaintain & Troubleshoot: Monitor existing data ingestions, including Supermetrics, custom APIs, and Python-based scripts. Vendor Data Handling: Manage ingestion of varied vendor formats (CSV/ZIP) into BigQuery, handling dynamic schema changes and sharded raw tables efficiently. šEnvironment Monitoring: Oversee pipelines interacting with VM environments and transactional databases (e.g., MySQL) to ensure reporting continuity. š2. Transformation, Modeling & Standards šAdvanced Modeling: Maintain and optimize existing SQL/Python scripts while formalizing transformations into production-ready tables using dbt. šPerformance Optimization: Implement incremental loading strategies, partitioning, and clustering within BigQuery to manage costs and query speed. šClassification & Normalization: Apply and update complex logic to categorize media spend and performance. This includes normalizing varied vendor naming conventions into internal CP/Mavenn standards (Campaigns, Placements, Creatives, and UTM structures). š3. BI Strategy & Documentation šOmni Integration: Collaborate with the Analyst team to ensure BigQuery "Production" tables are optimized for the Omni Analytics modeling layer. šKnowledge Transfer: Finalize and expand upon technical documentation to ensure no loss of institutional knowledge during the transition.
Technical Qualifications
šRequired šExpert BigQuery (SQL): Master-level SQL (window functions, UDFs, script optimization) and GCP environment management. šMarketing Tech Stack: Deep experience with advertising data schemas (Meta, Google, TikTok, etc.) and ingestion tools like Supermetrics or Fivetran. šProblem Solving: Proven ability to "reverse engineer" legacy scripts to extract and document business logic. šVersion Control: Proficiency with Git-based workflows (GitHub/Bitbucket).
If this role isnāt the perfect fit, there are plenty of exciting opportunities in blockchain technology, cryptocurrency startups, and remote crypto jobs to explore. Check them on our Jobs Board.
