Senior Data Analytics Engineer

Instinctools; Kraków; On-site; PLN 180,000 - 280,000; Full time

Benefits offered by this job

Flexible working time

Learning opportunities and conferences

Language course funding (English)

Professional and ambitious team

Job summary

instinctools seeks a Senior Data Analytics Engineer for a client project. The role focuses on migrating attribution pipelines to the core DWH platform, building incremental data marts in BigQuery, and ensuring data quality across sources.

You will collaborate with marketing analysts, BI teams and stakeholders to translate business needs into data requirements. The ideal candidate has 5+ years in Analytics/DWH roles, strong SQL, experience with BigQuery, dbt and Airflow, and comfort with data

Qualifications

• 5+ years as Analytics Engineer or related roles with DWH experience.
• Hands-on with data warehouses and modern pipelines.
• Strong SQL and data modeling skills.
• Experience with BigQuery and dbt on large projects.

Responsibilities

• Gather requirements from analysts and translate into data pipeline changes.
• Lead migration of attribution pipelines to core DWH platform.
• Build and optimize data marts in BigQuery and Airflow.
• Design data quality checks and investigate discrepancies.
• Perform deep-dive analyses of external inputs to ensure data reliability.
• Support testing, validation and releases; update downstream consumers.
• Maintain technical documentation across the domain.

Skills

SQL

Python

Data Warehousing

DWH Architecture

Incremental Loads

Data Quality

Data Governance

Airflow

dbt

BigQuery

Git

Looker/Tableau

Tools

BigQuery

Airflow

dbt

Looker

Tableau

Git

Lightdash

Cloud Storage

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.

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

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.