Senior Data Analytics Engineer
Summary
Instinctools is hiring a Senior Data Analytics Engineer to serve a global ride-hailing/mobility client: migrating the marketing attribution pipeline to a BigQuery DWH, building incremental data marts with dbt/SQL, orchestrating with Airflow, and running data quality checks from source to consumption.
*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: