Associate - Tools Specialist, Financial Services COE

Who We Are

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 plays a critical role in supporting Bain's case teams globally to help with analytics and research across all industries, 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’ll work with

This is an opportunity to be a part of Bain’s Financial Services, Centre of Expertise (CoE) team, based out of Gurugram office. The FS CoE team supports the global FS practice area leadership team with research and analytics, to help produce the annual IP publications, reports and point-of-views. In addition, the team also helps global Bain case teams and client development teams with specific work-stream on the case or tasks originating out of the annual IP work.

As a Tools Specialist at Bain, you will be the go-to expert for developing web-based tools and Tableau dashboards, using your expertise in server-side languages (Python, R, Java, .Net), front-end technologies (HTML, CSS, JavaScript, Angular JS, React), and MS SQL Server. Whether working independently or leading a team, your role is to deliver impactful, data-driven solutions with precision and innovation, ensuring project success through your strong technical foundation and excellent communication skills.

What You Will Do

• Understand client needs and situations and adapt to case expectations. Show ability to resolve discrete issues and/or drive consensus
• Take responsibility for assigned work streams and generate hypotheses. Effectively understand the work plan and execute it

• Build dynamic, visually attractive, end-to-end, and innovative software product/apps/solutions including front-end and back-end architecture, such as user experience, user interaction, responsive design, and complete architecture
• Work with cloud servers like Azure/AWS to host the products/ databases. 
• Work with third party APIs to integrate them in our apps
• Work with version control system like GitHub
• Create databases with efficient structures; Write optimized queries, views and triggers for integration with other applications
• Design strategy for continuous enhancement/improvements, performance optimization, stability, and scalability
• Design and develop interactive Tableau dashboards. dashboard creation, report authoring and troubleshooting, data source management). Create interactive filters, parameters, and calculations for preparing dashboards and worksheets in Tableau
• Create and edit SQL queries within Tableau to build calculated fields
• Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. Perform end to end Data validation to maintain accuracy of data sets
• Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner
• Stay updated with new tools, frameworks, approaches, and architectures in the development world
• Effectively structure communication of insights from own work-stream. Deliver clear and professional presentations to the team/team leaders/managers
• Maintain proactive and constructive communication with all project stakeholders.

• Consistently seek and provide responsible feedback in all interactions; recognize different skills and development needs in oneself

About You

• Candidate should be a Graduate from top-tier college with strong academic records and with 2-3 years of relevant work experience 
• Minimum of 2+ years of relevant experience in software development 
• Strong organizational and project management skills
• Proficiency with server-side languages such as Python, R, Java, and .Net.
• Familiar with JavaScript frameworks such as Angular JS, React, and Amber
• Knowledge of fundamental front-end languages such as HTML, CSS, and JavaScript
• Familiar with Cloud servers like Azure/ AWS
• Hand on experience of using GitHub/SVN/etc.
• A solid understanding of SQL, relational databases, and normalization
• Experience in developing and designing Tableau driven dashboards would be preferred.
• Experience in designing and developing efficient Alteryx workflows.
• Strong understanding of algorithms, data structures, and system design
• Exceptional interpersonal and communication skills. Proven self-starter with demonstrated problem solving and organizational skills

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..