Engineer, TSG Data Engineering

COMPANY PROFILE

Bain & Company is one of the top management consulting firms in the world that helps the world’s most ambitious changemakers define the future.

Across 65 cities in 40 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperforming the competition, and redefine industries. We complement our tailored, integrated expertise with a vibrant ecosystem of digital innovators to deliver better, faster, and more enduring outcomes.

The firm established several functions in the Indian market early 2000s and its remit across functions has expanded over time. Since 2019, these functions have become part of Global Business Services (GBS). Global Business Services (GBS) is a network of five interconnected business functions hubs across India, Poland, Malaysia, Mexico and Portugal, serving Bain globally to run our business, support other functions, and help drive innovation internally. We are over 1000 business professionals – serving functions in operations, HR, finance, legal, tech, marketing, research, and data analytics – who support our offices globally. Our mantra of “shared innovation, seamless execution,” underpinned by a passion for results, teamwork, and creativity, helps Bain stay at the top of our game operationally.

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. We are currently the top-ranked consulting firm on Glassdoor’s Best Places to Work list and have earned the #1 overall spot a record seven times.

Extraordinary teams are at the heart of our business strategy, but these don’t happen by chance. They require intentional focus on bringing together a broad set of backgrounds, cultures, experiences, perspectives, and skills in a supportive and inclusive work environment. We hire people with exceptional talent and create an environment in which every individual can thrive professionally and personally.

WHO YOU’LL WORK WITH

This position works as a member of an Agile/scrum software development team focused exclusively on building and supporting Bain’s most strategic internal software systems. Team members work collaboratively to design, build and implement new features and functionality in their systems aimed at delivering the most value to Bain’s global users and supporting key business initiatives. Systems developed are primarily enterprise-scale browser based or mobile applications developed with current Microsoft development languages and technologies, with a global user base and integration points with one or more other internal Bain systems.

WHERE YOU’LL FIT WITHIN THE TEAM

A Data Engineer is someone with a proven track record of delivering application modules with minimal to no supervision from senior engineering team members. Additionally, the individual is also responsible of providing guidance to associate/ entry level engineers in the team.

WHAT YOU’LL DO

Technical Delivery (80%)

• Work with teams developing and updating enterprise applications.
• Work as a member of an agile software development team with full participation in all Agile team events and activities.
• Demonstrate ability to identify all technical steps required to complete a story. Work with the senior team members to evaluate product backlog items and functional specifications and determine the appropriate approach to developing the required functionality in the software application.
• Demonstrate high-level business and domain knowledge and ability to understand and achieve business outcomes.
• Work in collaboration with other team members on an agile team to analyze user stories and perform task breakdown and complete committed tasks as per sprint schedule.
• Demonstrate good understanding of using the underlying infrastructure to develop his/her features.
• Follow the standard application design and architecture to develop his/her features and work with senior team members to ensure non-functional metrics (e.g. scalability, performance) are met.
• Prepare work estimates for committed tasks and components with support from senior team members.
• Write unit test plans for committed components. Execute and confirm successful completion of unit tests as part of the criteria for completion.
• Participate in the testing and implementation of applications releases.
• Provide ongoing support for applications already in use. This includes problem diagnosis and resolution, ad hoc reporting support and database administration.
• Demonstrate ability to acquire new skills e.g. creating automation tests using selenium, creating UX designs, DevOps, performing functional/ load testing etc. through internal/ external trainings to be a T-Shaped team member helping the team in achieving sprint goals.
• Provide input during sprint retrospective to improve team experience.
• Follow Bain development project process and standards in completing committed tasks and modules and contribute to the continual evolution of processes and standards.
• With guidance, write technical documentation as required.

Research (10%)

• Contribute to evaluating and employing new and/or supplemental technologies necessary to deliver functionality for a given software application.
• Contribute to the research and evaluation of new tools and technologies beyond current product requirements that are likely to be used in future initiatives. Help in the presentation of findings and recommendations to the full Software Development team.
• Participate in internal skill development by sharing concepts and technologies with the full Software Development team.

Communication (10%)

• Ability to present the technical findings and recommendations to the Software Development team.
• Clearly communicates impediments to completing a story and ensures clear understanding of definition of ‘done’.
• Provide input during sprint retrospective to improve team experience.

ABOUT YOU

• Demonstrated knowledge of agile software development methodologies and processes
• Demonstrated record of strong performance in prior software development positions,
• Strong communication and customer service skills
• Strong analytic and problem-solving skills

Data Engineering - Technical skills:

• Languages: T-SQL, PySpark, Python, Scala
• Data Storage & Analytics: Delta Lake, Unity catalog, Microsoft SQL Server, Azure SQL, Azure Data Lake, Blob Storage, etc.
• ETL Tools: Azure Databricks, Azure Data Factory
• Cloud-based data warehouse and Lakehouse architectures on Microsoft Azure
• Cloud & Infrastructure: Azure Databricks, ADLS, ADF, Azure Logic app
• DevOps: Azure DevOps, Git, GitHub Actions
• NoSQL databases: MongoDB, Cosmos, etc.
• Visualization Tools: Tableau, Power BI, etc.

Experience

• 2-4+ years of relevant experience in Data Engineering
• Experience developing enterprise scale applications
• Demonstrated knowledge of agile software development methodologies and processes.
• Demonstrated record of strong performance in prior software development positions.
• Strong communication and customer service skills
• Strong analytic and problem-solving skills
• Demonstrated record of T shape behavior to expedite delivery by managing conflicts/ contingencies

Education OR equivalent combination of education, training, and experience

• Bachelor’s or equivalent degree