Associate (Data Engineering) – Pyxis, Data Business CoE

About us

Bain & Company is a global management consulting that helps the world’s most ambitious change makers define the future. Across 65 offices in 40 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperform the competition and redefine industries. Since our founding in 1973, we have measured our success by the success of our clients, and we proudly maintain the highest level of client advocacy in the industry.

In 2004, the firm established its presence in the Indian market by opening the Bain Capability Center (BCC) in New Delhi. The BCC is now known as BCN (Bain Capability Network) with its nodes across various geographies. BCN is an integral and largest unit of (ECD) Expert Client Delivery. ECD plays a critical role as it adds value to Bain's case teams globally by supporting them with analytics and research solutioning across all industries, specific domains for corporate cases, client development, private equity diligence or Bain intellectual property. The BCN comprises of Consulting Services, Knowledge Services and Shared Services.

Who you will work with

• Pyxis leverages a broad portfolio of 50+ alternative datasets to provide real-time market intelligence and customer insights through a unique business model that enables us to provide our clients with competitive intelligence unrivaled in the market today. We provide insights and data via custom one-time projects or ongoing subscriptions to data feeds and visualization tools. We also offer custom data and analytics projects to suit our clients’ needs. Pyxis can help teams answer core questions about market dynamics, products, customer behavior, and ad spending on Amazon with a focus on providing our data and insights to clients in the way that best suits their needs. Refer to: www.pyxisbybain.com
• As a Data Engineer associate, you will be integral to the building of services & databases that power PYXIS products. You will closely work with the Pyxis PL, team manager, and the Pyxis data architect. This position requires individuals with a passion for data and analytics as well as the creativity to help with product development

What you’ll do 

• Python Code Development: Write scalable and efficient code in Python, ensuring it adheres to best practices in software development
• API and Service Development: Develop robust Python-based APIs and services that facilitate data processing and analytics, contributing to the system's overall functionality and efficiency
• Data Analytics: Perform in-depth analytics using advanced SQL techniques to extract meaningful insights from raw data, aiding in decision-making and strategy development
• Performance Tuning: Continuously monitor and optimize Python code and SQL queries for performance enhancements, reducing processing time and improving system efficiency
• Adaptability in Learning: Demonstrate the ability to quickly learn and adapt to new data tools and concepts
• Collaborative Development: Work collaboratively with cross-functional teams to understand data needs, translate business

About you

• A Bachelor’s or Master’s degree in Computer Science or related field
• Work experience range in case highest qualification is postgraduate studies – 1-3 years in Data Management, Business Intelligence, or Business Analytics
• Work experience range in case highest qualification is undergraduate studies – 4-5 years in Data Management, Business Intelligence, or Business Analytics
• Python Proficiency: Demonstrable experience in Python coding for data-related tasks (must have)
• Data Handling and ETL: Proven hands-on experience in managing data and executing ETL (Extract, Transform, Load) processes
• Advanced SQL Skills: Extensive experience in crafting advanced SQL queries, developing stored procedures, tuning query performance, and maintaining indexes
• Code Management: Familiarity with code management and version control using GitHub
• Debugging and Testing: Skilled in testing and troubleshooting code to identify and rectify failures

What makes us a great place to work

We are proud to be consistently recognized as one of the world's best places to work, a champion of diversity and a model of social responsibility. We are currently ranked the #1 consulting firm on Glassdoor’s Best Places to Work list, and we have maintained a spot in the top four on Glassdoor's list for the last 12 years. We believe that diversity, inclusion and collaboration is key to building extraordinary teams. We hire people with exceptional talents, abilities and potential, then create an environment where you can become the best version of yourself and thrive both professionally and personally. We are publicly recognized by external parties such as Fortune, Vault, Mogul, Working Mother, Glassdoor and the Human Rights Campaign for being a great place to work for diversity and inclusion, women, LGBTQ and parents..