Data Engineer (BigQuery)

• 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

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

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)