Project is a dynamic solution empowering companies to optimize promotional activities for maximum impact. It collects and validates data, analyzes promotion effectiveness, plans calendars, and integrates seamlessly with existing systems. The tool enhances vendor collaboration, negotiates better deals, and employs machine learning to optimize promotional plans, enabling companies to make informed decisions and maximize return on investment. Stack on the project: Databricks, SQL, and Spark Project duration: 12 months (with possible extension) Tasks: Build and optimize data pipelines using Databricks, SQL, and Apache Spark. Design and implement scalable data processing systems. Manage and optimize data pipelines. Ensure the quality and efficiency of data flows. Our expectations of the ideal candidate: 5+ years of experience as a Data Engineer. Deep expertise in big data technologies, particularly Databricks, SQL, and Spark. Very strong SQL skills. Experience in data modeling and ETL processes. Experience with analytics engineering is a plus. Experience with DBT. Soft Skills: Prefer problem solving style over experience Ability to clarify requirements with the customer Willingness to pair with other engineers when solving complex issues Good communication skill

*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 Data Engineer (BigQuery) for one of our clients. Our Client is one of the TOP-5 global management consulting firms considered to be among the most prestigious ones in the world. Hundreds of customers from Fortune-500 , including the largest global financial institutions, the world s top media companies, technology companies and federal government agencies rely on our Client s proven platform and services. Project is a dynamic solution empowering companies to optimize promotional activities for maximum impact. It collects and validates data, analyzes promotion effectiveness, plans calendars, and integrates seamlessly with existing systems. The tool enhances vendor collaboration, negotiates better deals, and employs machine learning to optimize promotional plans, enabling companies to make informed decisions and maximize return on investment. Stack on the project: BigQuery, SQL, and Apache Spark, Python, AWS Tasks: Build and optimize data pipelines using BigQuery, SQL, and Apache Spark Design and implement scalable data processing systems Manage and optimize data pipelines Ensure the quality and efficiency of data flows Collaborate with data scientists and analysts to support data initiatives 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 a Data Engineer. Strong experience in writing and optimizing complex SQL queries, managing datasets in Google BigQuery, and ensuring efficient data retrieval Ability to build, optimize, and troubleshoot distributed data processing pipelines using Apache Spark (PySpark/Scala) Hands-on experience in designing, building, and maintaining scalable ETL/ELT pipelines, ensuring efficient data transformation and processing Understanding of cloud-based data solutions, storage optimization, and performance tuning in AWS Strong knowledge of data validation techniques, performance tuning, and monitoring to ensure high-quality, efficient, and reliable data flows Soft Skills: Ability to clarify requirements with the customer Willingness to pair with other engineers when solving complex issues Good communication skills English: Upper-Intermediate or higher Working time zone: IST 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 (from Indian location) professional and ambitious team learning opportunities, seminars and conferences and time for exploring new technologies full remote work co-funding for language courses (English) share Margarita Lukyanenka Recruiter