Associate – Tools Specialist, Financial Services

Bain & Company

Description & Requirements
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..

To apply for this job please visit www.bain.com.

Job Overview
Job Location