Senior Data Analytics Engineer - Team *instinctools

*instinctools is a software development company that provides custom software solutions for businesses of all sizes. Our team works closely with clients to understand their specific needs and provide personalized solutions that meet their business requirements.

*instinctools is looking for a Senior Data Analytics Engineer to join a project for a global mobility and urban services platform.

The platform enables users to book rides and other services, including intercity travel, delivery, and task assistance. It operates in more than 700 cities across 47 countries and serves a large international user base.

You will work on the data infrastructure behind marketing attribution and analytics. The project involves migrating data pipelines to a core data warehouse platform, building and optimizing data marts, integrating external data sources, and ensuring the consistency and reliability of analytical data.

Your work will help marketing analysts and BI teams access accurate, trustworthy data for understanding campaign performance and making data-driven decisions.

Location: Europe, Poland, Kazakhstan

What you will get hands-on with

• Data pipeline migration: Lead the migration of dbt models, Airflow DAGs, and data sources to the core data warehouse platform, validating data parity before switching over.

• Modern analytics engineering: Build and optimize incremental data marts using BigQuery, dbt, and SQL.

• Data orchestration: Develop and maintain Airflow workflows, including recalculations, backfills, and reliable execution of data pipelines.

• Marketing attribution data: Work with AppsFlyer, advertising network cost feeds, reference dictionaries, and upstream data marts.

• Data quality and validation: Investigate discrepancies between source data and downstream datasets, implement quality checks, and ensure reliable data delivery.

• End-to-end ownership: Work across requirements clarification, pipeline development, testing, release, and documentation.

This role combines hands-on engineering with technical ownership. You will work on production data pipelines where correctness, historical consistency, and reliable migration are essential.

What you will do

• Gather and clarify requirements from marketing analysts and BI stakeholders, translating business needs into changes to attribution logic, data sources, and data marts.

• Lead the migration of attribution pipelines, including dbt models, Airflow DAGs, and source integrations, to the core data warehouse platform.

• Run old and new pipelines in parallel, reconcile their outputs, validate data parity, and coordinate the transition to the new platform.

• Build and optimize incremental data marts in BigQuery using dbt and SQL.

• Implement recalculations, backfills, and historical data processing while preserving data consistency.

• Design and maintain data quality checks and investigate discrepancies against product and source data.

• Analyze external data inputs, including AppsFlyer, advertising network cost feeds, Google Sheets dictionaries, and upstream marts.

• Participate in testing, data validation, release activities, and the transition of downstream consumers to updated datasets.

• Maintain technical documentation and share domain knowledge across the team.

What we expect from you

• 5+ years of experience as an Analytics Engineer, DWH Engineer, Data Analyst working with a data warehouse, or in a closely related role.

• Hands-on experience working with data warehouses.

• Strong understanding of data warehouse architecture and data layers, including ODS and data marts.

• Understanding of incremental data loads, historical data handling, and deduplication.

• Expert-level SQL skills and good Python knowledge.

• Experience designing and optimizing data marts.

• Experience with BigQuery or a similar columnar database.

• Experience with dbt on large-scale incremental projects.

• Experience migrating data pipelines between platforms and validating data parity.

• Experience with Airflow or a similar orchestration tool.

• Python experience for data processing and ETL tasks.

• Experience with Git and version control practices.

• Familiarity with data quality and data governance.

• Ability to work with stakeholders and translate business needs into data requirements.

• English: Intermediate or higher.

Nice to have

• Experience with mobile or marketing attribution data, including AppsFlyer, Adjust, or Branch.

• Familiarity with advertising attribution mechanisms such as SKAN/ATT.

• Experience with ad fraud data, including Protect360.

• Experience with Google Cloud Platform, particularly BigQuery, Cloud Storage, or Dataform.

• Familiarity with BI and analytics tools such as Lightdash, Looker, or Tableau.

Soft skills

• Ability to influence teammates and partner teams.

• Clear communication of complex technical findings and analytical results.

• Strong problem-solving and analytical thinking.

• Ownership of technical tasks and attention to data quality.

• Ability to collaborate with business stakeholders and technical teams.

What we offer

• A large-scale international product environment. Contribute to data infrastructure supporting a global mobility and urban services platform.

• Meaningful engineering challenges. Work on pipeline migration, incremental data processing, data quality, and production reliability.

• A professional and ambitious team. Collaborate with colleagues working on complex data and analytics challenges.

• Flexible working time. Organize your working schedule within the team’s delivery needs.

• Professional development. Access learning opportunities, seminars, conferences, and time to explore new technologies.

• Language learning support. Co-funding for English language courses.

Join *instinctools and help build reliable data pipelines and analytical datasets that support business decisions at scale.

Important Notice Regarding Your Personal Data Security

Thank you for your attention and cooperation.

share Valeryia Sharshniova Recruiter We will be glad to see you in our team!