Senior Data Analytics Engineer

Senior Data Analytics Engineer - Team *instinctools About company *instinctools Global *instinctools India *instinctools Poland *instinctools Kazakhstan Career Vacancies Team Blog Events Contact Us 25 Vacancies All jobs Senior Data Analytics Engineer Home Vacancies Senior Data Analytics Engineer *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. Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data 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 Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data Send Data 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. share Valeryia Sharshniova Recruiter We will be glad to see you in our team! * Full Name * E-mail * Job Vacancy * Location (country, city) Years of experience on a similar role/position Additional Information (LinkedIn, Github, etc.) Attach CV * * I confirm my consent to the processing of personal data and accept the terms of the Privacy Policy . Submit job application Developers *instinctools is a developer of IT solutions for Western Europe. We have over 350 projects in our portfolio. The spheres are different – from healthcare and medicine, training and education, to digital advertising, economics and IT. For the software implementation and maintenance across such a number of projects, competent developers are important. We use a modern technology stack, the key of which are: Javascript, ReactJS, Angular, Node.js, Golang, Python, Java, iOS, Android, Blockchain, AWS. Join the *instinctools team! *instinctools Poland We have had a representative office in Poland (Warsaw) since 2021. Our Polish team consists of highly qualified and experienced specialists – most of them are Middle to Senior level Developers. Right now we’re on the lookout for bright and innovative minds to join our professional team! Copyright © 2000 − 2024 — *instinctools / Privacy policy / FAQ Linkedin We are using cookies to give you the best experience on our website. You can find out more about which cookies we are using or switch them off in settings . Close GDPR Cookie Banner Accept All Reject All Settings Close GDPR Cookie Banner Change cookie settings Close GDPR Cookie Settings About this Policy Strictly Necessary Cookies Analytics cookies Cookie Policy About this Policy This Cookie Policy ("Policy") explains how we use cookies and other similar technologies to recognise you when you visit our website https://www.instinctools.eu/ ("Website"). It explains what these technologies are and why we use them, as well as your rights to control our use of them. The Website owned by INSTINCTOOLS PL SP. Z O. O. (referred to as “we”, “us”, or “our”). Please take the time to read this Policy carefully. If you have any questions or comments, please contact us via email at privacy@instinctools.eu . What are cookies? Cookies are small data files that are placed on your computer or mobile device when you visit a website. Cookies are used by website owners in order to make their websites work, or to work more efficiently, as well as to provide reporting information. Cookies have many different features, such as allowing you to navigate between pages efficiently, remembering your preferences, and generally improving your user experience. They can also help ensure that the advertisements you see online are more relevant to you and your interests. Cookies set by the website owner are called "first party cookies". Cookies set by other parties other than the website owner are called "third party cookies". Third party cookies enable third party features or functionality to be provided on or through the website (e.g. like advertising, interactive content and analytics). The parties that set these third party cookies can recognise your computer or mobile device both when it visits the websites in question and also when it visits certain other websites. Strictly Necessary Cookies These cookies are necessary for the website to function and cannot be switched off through the cookie-banner. They are usually only set to provide website services properly. You can set your browser to block or alert you about these cookies, but this may cause parts of the website to not work properly. Also we record and keep your language and region preferences and privacy choices once you have made them. Cookie name Host Description Duration pll_language www.instinctools.eu Used to set the language of web pages 24 hours Enable or Disable Cookies Analytics cookies Using these cookies we can count visits and traffic sources to be able to measure and improve the performance of our website. They help us to know which pages are the most and least popular and see how visitors move around the website. If these cookies are disabled, we will not be able to monitor the website’s performance. Cookie name Host Description Duration _ga Google Used to distinguish user 2 years _ga_M6HW5W7L8G Google Used to persist session state 2 years Enable or Disable Cookies Cookie Policy More information about our Cookie Policy. How can I control cookies? You have the right to decide whether to accept or reject specific types of cookies (except of strictly necessary cookies). You can exercise your cookie preferences on the cookie banner. You can set or amend your web browser controls to accept or refuse cookies. If you choose to reject cookies, you may still use our Website though your access to some functionality and areas of our Website may be restricted. As means by which you can refuse cookies through your web browser controls vary from browser to browser, you should visit your browser's help menu for more information. Updates to this policy We may update this Policy from time to time in response to legal, technical or business changes and developments. You can see when this Policy was last updated by checking the “last updated” date displayed at the top of this Policy. Enable All Reject All Save Changes