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 for one of our clients.

Location: Europe, Poland, Kazakhstan

Client: is a global mobility and urban services platform that allows users to book rides or other services and negotiate the fare directly with the service provider. It offers a variety of services including ride-hailing, intercity travel, delivery, and task assistance, operating in over 700 cities across 47 countries and is the second most downloaded mobility app in the world.

Responsibilities and tasks:

• Gather and clarify requirements from marketing analysts and BI, and turn them into changes to attribution logic, sources and data marts.
• Lead the migration of the attribution pipeline (dbt models, Airflow DAGs, sources) to the core DWH platform. Run old and new in parallel and reconcile them before switching over.
• Build and optimize incremental data marts in BigQuery (dbt/SQL) and Airflow, including recalculations and backfills.
• Design and implement data quality checks, and investigate discrepancies against product and source data.
• Perform deep-dive analysis of external inputs (AppsFlyer, ad network cost feeds, Google Sheets dictionaries, upstream marts) to keep data flowing reliably from source to consumption.
• Participate in testing, data validation and release processes, including repointing downstream consumers.
• Maintain technical documentation for the domain and spread the knowledge across the team.

Our expectations of the ideal candidate:

• 5+ years of experience as an Analytics Engineer / DWH Engineer / Data Analyst working with DWH.
  
• Hands-on experience with data warehouses.
• Strong understanding of DWH architecture and data layers (ODS, Data Marts).
  
• Understanding of incremental loads, historical data handling and deduplication.
  
• Expert SQL skills.
  
• Experience designing and optimizing data marts.
  
• Experience with BigQuery or similar columnar DB.
  
• Experience with dbt on large incremental projects.
  
• Experience migrating pipelines between platforms with data parity validation.
  
• Experience with Airflow or a similar orchestration tool, Python for data processing and ETL tasks.
• Ability to work with stakeholders and translate business needs into data requirements.

Must have to be familiar with:

• Languages: SQL (expert knowledge), Python (good knowledge).
  
• Transformation: dbt.
  
• Orchestration: Airflow or a similar orchestration tool.
  
• Version Control: Git.
  
• Experience with Data Quality / Data Governance.

Nice to have:

• Mobile or marketing attribution data (AppsFlyer, Adjust, Branch), ad network cost data, SKAN/ATT.
• Ad fraud data (Protect360).
• Cloud & Storage: Google Cloud Platform (BigQuery, Cloud Storage, Dataform).
  
• Analytics & BI: Lightdash, Looker, Tableau.

English: Intermediate

Soft skills:

• The ability to influence teammates and partner teams, and to communicate complex results clearly

We offer:

• flexible working time
• professional and ambitious team
• learning opportunities, seminars and conferences and time for exploring new technologies
• co-funding for language courses (English)

Important Notice Regarding Your Personal Data Security

Thank you for your attention and cooperation.