The Job logo

What

Where

Associate - Tools Specialist, Financial Services COE

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi
Join Bain's Financial Services COE team based in Gurugram office. Develop web-based tools, Tableau dashboards using Python, R, Java, HTML, CSS, JS. Design interactive dashboards, host on cloud servers, integrate APIs. Full-time On-site role in New Delhi, India.

Job description 

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
Set alert for similar jobsAssociate - Tools Specialist, Financial Services COE role in New Delhi, India
Bain & Company Logo

Company

Bain & Company

Job Posted

7 months ago

Job Type

Full-time

WorkMode

On-site

Experience Level

3-7 Years

Category

Technology

Locations

New Delhi, Delhi, India

Qualification

Bachelor or Master

Applicants

Be an early applicant

Related Jobs

Bain & Company Logo

Associate - Org CoE

Bain & Company

New Delhi, Delhi, India

Posted: 7 months ago

You will be working in the ORG CoE team under Data & Tech cluster at BCN, focusing on analytical solutions for Operating Model and Organization Practice. Responsibilities include developing insights, guiding case teams, executing projects, analyzing data, and delivering presentations. This role involves working with tools like Tableau, Alteryx, SQL, and collaborating with internal and external partners to create org analytics benchmarks. Coaching analysts and providing thought leadership are key aspects of the job.

Bain & Company Logo

Senior Associate Engineer, Quality Assurance

Bain & Company

New Delhi, Delhi, India

Posted: a year ago

JOB DESCRIPTION Company Overview : Bain & Company is a global consultancy that helps the world’s most ambitious change-makers 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, outperform 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. Our 10-year commitment to invest more than $1 billion in pro bono services brings our talent, expertise, and insight to organizations tackling today’s urgent challenges in education, racial equity, social justice, economic development, and the environment. 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.   Position Summary: This position sits on a scrum team and is responsible for conducting quality assurance (QA) on specific software applications. Working with their agile teams, and with support of QA leader, this position plans, conducts and reports results on a variety of tests including manual, exploratory, automated regression, and performance testing.  As active member of the scrum team, this position participates in all scrum ceremonies. This role also participates in broader QA initiatives under the guidance of the QA leader   Essential Functions:   Requirement understanding (20%)  Understand functional and non-functional requirements and the business context for which the application is being developed. Participate in meetings and calls pertaining to requirements and clarification of requirement issues. Provide input into acceptance criteria to clarify the user story before work begins Test planning, design, execution, and defect management (50%)  Design and document test scenarios, manual test cases for the functional and non-functional requirements. - Write, maintain, and execute automated UI test scripts, with assistance. Maintain a suite of manual and automated regression test cases, ensuring that test cases found missing during internal and external testing are incorporated into this suite. Keep the regression suite updated for all changes in requirement Execute the test cases and prepare test logs. Conduct performance testing to ensure that the application conforms to the defined performance specifications. Interpret the outcome of the testing and escalate any issues in the performance of the application. Report any defect found during the execution using the project's defined defect management tool. Troubleshoot bugs to identify ultimate root cause and then document findings in bug tracking software. Also clearly understand the impacted areas due to resolution suggested/provided by the development team.  Work with the team to ensure bugs found in testing are resolved and retested. Update the status accordingly Collaboration (10%) Provide input into application test strategy, including amount of manual, exploratory, and automated tests, working with both QA leadership and scrum team Raise concerns, roadblocks, and impediments to scrum team and management in a timely manner  Participates fully in all scrum ceremonies, including sprint reviews Help scrum team ensure sprint goal is met, including activities outside QA function when requested Support application deployment as necessary Take ownership   Qualifications : Education and Work Experience: Bachelor's/Master's in Computer Applications, Computer Engineering, Business, Information technology 2-4 years of experience Individual Contributor Functional testing, Regression testing, Smoke testing, Automation testing, Java, JavaScript, C#, Python, Strong reasoning skills, Agile, Scrum, Kanban, Scrum ban, Bug Reporting, Test Execution, Test case writing Few short travels could be required for business/team collaboration   Knowledge, Skills, and Abilities: Good understanding of basic testing concepts Should be able to write functional automated test scripts  Knowledge of any of the programming language like Java, JavaScript, Python, C# with a test automation tool  Working knowledge of test management tool Strong written and verbal communication skills Ability to establish trusted partnerships with product heads, and executive level stakeholders Comfort with agile operating models        Attention to detail and aptitude for analytical problem resolution Strong critical thinking skills Demonstrated interest in and aptitude for technology Ability to work independently and with teams

Bain & Company Logo

Engineer, Data Engineering​

Bain & Company

New Delhi, Delhi, India

Posted: a year ago

JOB DESCRIPTION Company Overview Bain & Company is a global consultancy that helps the world’s most ambitious change-makers 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, outperform 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. Our 10-year commitment to invest more than $1 billion in pro bono services brings our talent, expertise, and insight to organizations tackling today’s urgent challenges in education, racial equity, social justice, economic development, and the environment. 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. Position Summary As a member of Bain's Next Generation Software Solutions (NGSS) team, the Engineer contributes to the development and maintenance of software products. They take a leading role in technical designs and execute coding tasks independently, ensuring high-quality deliverables. Additionally, they play a significant role in support and operations by identifying system defects, leading troubleshooting efforts, and supporting code deployments.  Essential Functions    Core Development, Support, and Maintenance (80%): Coordinate with product teams to understand business needs, functional, and non-functional product requirements Participate in hands-on development of new software features and modules using a variety of tools and technologies spanning low code engineering platforms, data ingestion and cleansing, core web application development, analytics, visualizations, automation, integration, and much more Help deploy new builds and features to production environments Contribute to time and cost estimates of system enhancements, advise on trade-offs of features Help in the testing of application code, including writing unit test plans Work as a member of an Agile software development team with full participation in all team events and activities   Other (20%): Support efforts to drive innovation through out-of-the-box thinking to solve critical business challenges and demands Participate on technical discovery, POCs, and innovation work streams to validate new tools, technologies, and designs Investigate and keep up-to-date on emerging and cutting-edge data technologies and trends, lead knowledge sharing  Support team in recruiting activities (resume scanning, interviews, etc.) Qualifications - Education and Work Experience: Associate's/Bachelor’s degree or an equivalent combination of education, training, and experience 2-5 years of experience  Knowledge, Skills, and Abilities: Hands-on experience with relational database management systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle) and SQL skills (DML & DDL) Relational data modelling and design skills (tables, PK/FK, constraints/indexes) Experience working with ETL/ELT data pipelines. Experience creating stored procedures, views, and user defined functions. Ability to write optimized complex SQL. Experience working with Snowflake and/or other modern data platform is preferred. Data wrangling experience using python is preferred. Developing data products and solutions Demonstrated knowledge of Agile software development and processes Strong performance in prior software development positions Strong analytical and problem-solving skills Strong communication and presentation skills, documenting complex data flows and processes Results-driven, analytical, and creative thinker, self-motivated and proactive Results focused, keeping an eye on the overall outcome and desired impact Strong interpersonal skills, able to interface across many areas and levels of Bain Entrepreneurial spirit, willingness to think outside the box to try new things.

Bain & Company Logo

Engineer, Quality Assurance

Bain & Company

New Delhi, Delhi, India

Posted: a year ago

JOB DESCRIPTION Company Overview : Bain & Company is a global consultancy that helps the world’s most ambitious change-makers 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, outperform 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. Our 10-year commitment to invest more than $1 billion in pro bono services brings our talent, expertise, and insight to organizations tackling today’s urgent challenges in education, racial equity, social justice, economic development, and the environment. 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.   Position Summary: This position sits on a scrum team and is responsible for conducting quality assurance (QA) on specific software applications.  Working with their agile team, and with some support from QA leader, this position plans, conducts and reports results on a variety of tests including manual, exploratory, automated regression, and performance testing.  As active member of the scrum team, this position participates in all scrum ceremonies. The position works closely with QA Manager, Senior QA, and team to implement the QA process and initiatives; and with TSG Project Managers, Development Managers, and customer Project Managers to develop and execute test plans. The QA engineer works with the same individuals to assist in the development of user acceptance test plans. As experienced member of the QA team, this position is expected to participate in larger and more complex projects. The QA engineer also participates in application testing required to support Infrastructure group initiatives including operating system patches and upgrades.   Essential Functions:   Requirement, Project, and Business understanding (20%)  Develop deep expertise in testing and the business functions (developing knowledge of how Bain works, how applications integrate, and subject matter expertise to provide more thoughtful test plans and more thorough testing) Build a thorough understanding of the development life cycle. Support team on common QA methodologies, tools, and processes, with guidance Understand functional and non-functional requirements and the business context for which the application is being developed. Participate in meetings and calls pertaining to requirements and clarification of requirement issues.    Test planning, design, execution, and defect management (50%)  Development comprehensive functional and regression test plans that incorporate systematic testing of core functionality as well as assessments of the user interface and process flow Able to support on multiple types of testing like API, Cross browser testing or others. Assist the Function and customer Project Managers in the development of user acceptance test plans Supports test data and test environment related activities. Participate in the testing of all applications as necessary to support Infrastructure initiatives that include server and client operating systems patches and upgrades, new server or client software that interacts with applications supported by the Application Development team and new hardware deployments. Design and document test scenarios, manual test cases for the functional and non-functional requirements.  Write, maintain, and execute automated UI test scripts, with assistance. Maintain a suite of manual and automated regression test cases, ensuring that test cases found missing during internal and external testing are incorporated into this suite. Keep the regression suite updated for all changes in requirement Execute the test cases and prepare test logs. Conduct performance testing to ensure that the application conforms to the defined performance specifications. Interpret the outcome of the testing and escalate any issues in the performance of the application. Report any defect found during the execution using the project's defined defect management tool. Troubleshoot bugs to identify ultimate root cause and then document findings in bug tracking software. Also clearly understand the impacted areas due to resolution suggested/provided by the development team.  Work with the team to ensure bugs found in testing are resolved and retested. Update the status accordingly.    Collaboration (10%) Provide input into application test strategy, including amount of manual, exploratory, and automated tests, working with both QA leadership and scrum team Raise concerns, roadblocks, and impediments to scrum team and management in a timely manner  Participates fully in all scrum ceremonies, including sprint reviews Help scrum team ensure sprint goal is met, including activities outside QA function when requested Support application deployment as necessary Take ownership Automation (10%) Able to set up and refine predesigned test automation framework as per project’s need.  Work along with developer to set up and maintain source control as well as pipelines for automated test cases in CI/CD. Leadership (10%)   Take ownership of test deliverables of the project  Lead or assist in initiatives within the QA team.  In the process, demonstrate leadership and superior teamwork. Mentor and train new associates in the testing community and support their onboarding Qualifications : Education and Work Experience: Bachelor's/Master's in Computer Applications, Computer Engineering, Business, Information technology 4-6 years of experience Individual Contributor Functional testing, Regression testing, Smoke testing, SQL, Automation testing, Selenium, Java, JavaScript, C#, Python, Strong Analytical and reasoning skills,Communication, Agile, Scrum, Kanban, Scrum ban, Bug\defect Management, Test Execution, Test Design, ALM tools (JIRA, HP QC.) and Test management tools (Zephyr, Xray, Test Sigma.), Maven, Nunit, Few short travels could be required for business/team collaboration   Knowledge, Skills, and Abilities: Strong knowledge of common software QA methodologies, tools, and processes. Good Knowledge of any of the programming language like Java, JavaScript, Python, C# with a test automation tool  Experience with test automation components like Selenium Web-driver, Junit, TestNG, Cucumber and Extent reports  Understanding of Rest API testing with working knowledge in any one tool API testing tool.  (Postman, SOAP UI, Swagger UI)   Working knowledge of test management tool Strong written and verbal communication skills Ability to establish trusted partnerships with product heads, and executive level stakeholders Comfort with agile operating models        Attention to detail and aptitude for analytical problem resolution Strong critical thinking skills Demonstrated interest in and aptitude for technology Ability to work independently and with teams.