Senior Data Analytics Engineer

Instinctools; Polska; Hybrid; PLN 180,000 - 280,000; Full time

Benefits offered by this job

Flexible working time

Learning opportunities

Language courses funded

Job summary

instinctools is seeking a Senior Data Analytics Engineer for a global mobility client. You will lead attribution-pipeline migrations, build incremental data marts in BigQuery, and ensure data quality across the DWH. Strong SQL, Python, dbt, Airflow and data governance are essential.

The ideal candidate has 5+ years in analytics engineering, experience with data warehouses, and the ability to translate business needs into data requirements. Hybrid work options are offered.

Qualifications

• 5+ years of experience in Analytics/ DWH engineering or data analysis.
• Hands-on with data warehouses and DWH architecture (ODS, Data Marts).
• Strong SQL and Python skills with DBT and Airflow experience.
• Experience with BigQuery or similar columnar DB and data governance.

Responsibilities

• Gather requirements from analysts and translate to attribution logic and data marts.
• Lead migration of the attribution pipeline to the core DWH platform and run parallel pipelines.
• Build and optimize incremental data marts in BigQuery and Airflow.
• Design data quality checks and investigate data discrepancies.
• Analyze external inputs to maintain reliable data flows from source to consumption.
• Participate in testing, data validation and release processes, and document domain knowledge.

Skills

SQL

Python

dbt

Airflow

BigQuery

Data Warehouses

Git

Data Quality

Data Governance

Tools

dbt

Airflow

BigQuery

Git

Job description

*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.

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.
  
• 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.

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

At *instinctools, we take the security of your personal data very seriously. Please be informed that all official communication, offers, and correspondence from *instinctools are conducted only through our verified company resources, including:
Official Email Domain: @instinctools.com
Company Website: https://www.instinctools.com
Important Reminder:
*instinctools will NEVER ask for sensitive personal or financial information, including:
– Bank account details
– Credit/debit card numbers
– Passwords or PINs
If you receive any suspicious requests claiming to be from *instinctools via unofficial channels (e.g., personal emails, social media DMs, or phone calls), please:
– Do not respond or share any information.
– Report it immediately via the company’s official channels.
Your trust and security are our top priorities. For any questions, always verify through our official channels.

Thank you for your attention and cooperation.

We will be glad to see you in our team!

We use a modern technology stack, the key of which are: