The Job logo

What

Where

Lead, Data Engineer

ApplyJoin for More Updates

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

Smart SummaryPowered by Roshi
Lead data engineer position at Bain & Company's Advanced Analytics Group (AAG) involves partnering with data science and platform engineering teams to develop and deploy production quality code, championing modern data engineering concepts, and implementing innovative deployment techniques. The role requires a Master's degree in computer science or related field with proficiency in programming languages like Python and experience with databases like PostgreSQL and SQL Server. The position involves working in New Delhi, Delhi, India, on-site as a full-time opportunity.

Job description 

WHO YOU’LL WORK WITH

Working alongside our generalist consultants, Bain's Advanced Analytics Group (AAG) helps clients across industries solve their biggest problems using our expertise in data science, engineering, customer insights, statistics, machine learning, data management, and supply chain analytics. Stationed in our global offices, AAG team members hold advanced degrees in computer science, engineering, AI, data science, physics, statistics, mathematics, and other quantitative disciplines, with backgrounds in a variety of fields including tech, data science, marketing analytics and academia.


 

WHAT YOU’LL DO

  • Partner with Data Science, Machine Learning, and Platform Engineering teams to develop and deploy production quality code
  • Develop and champion modern Data Engineering concepts to technical audience and business stakeholders
  • Implement new and innovative deployment techniques, tooling, and infrastructure automation within Bain and our clients.
  • Travel is required (~30%)


 

Requirements

  • Master’s degree in Computer Science, Engineering, or a related technical field. 
  • 3+ years at Senior or Staff level, or equivalent
  • 3+ years of experience programming with Python, Scala, C/C++, Java, C#, Go, or similar programming language.
  • 3+ years of experience with SQL or NoSQL databases: PostgreSQL, SQL Server, Oracle, MySQL, Redis, MongoDB, Elasticsearch, Hive, HBase, Teradata, Cassandra, Amazon Redshift, Snowflake.
  • Experience in deploying serverless data pipelines through containerization and terraform orchestration 
  • Industry level experience of working with public cloud environments (AWS, GCP, or Azure), and associated deep understanding of failover, high-availability, and high scalability  
  • Scaling and optimizing schema and performance tuning SQL and ETL pipelines in data lake and data warehouse environments.
  • Strong computer science fundaments in data structures, algorithms, automated testing, object-oriented programming, performance complexity, and implications of computer architecture on software performance.
  • Data ingestion using one or more modern ETL compute and orchestration frameworks (e.g. Apache Airflow, Luigi, Spark, Apache Nifi, and Apache Beam).
  • Version control and git workflows
  • Strong interpersonal and communication skills, including the ability to explain and discuss complex mathematical and machine learning technicalities with colleagues and clients from other disciplines at their level of cognition 
  • Curiosity, proactivity and critical thinking 
Set alert for similar jobsLead, Data Engineer role in New Delhi, India
Bain & Company Logo

Company

Bain & Company

Job Posted

8 months ago

Job Type

Full-time

WorkMode

On-site

Experience Level

3-7 Years

Category

Software Engineering

Locations

New Delhi, Delhi, India

Qualification

Bachelor or Master

Applicants

Be an early applicant

Related Jobs

Bain & Company Logo

Senior 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 Senior Engineer contributes to the development and maintenance of software products. They take a leading role in technical designs and execute coding tasks, ensuring high-quality output. Involved in support and operations, they identify system defects, lead troubleshooting efforts, and support code deployments. Essential Functions  Core Development, Support, and Maintenance (80%): Work 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 Deploy new builds and features to production environments Lead coordination in time and cost estimates of system enhancements, advise on trade-offs of features Mentor junior developers Lead coordination 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%): Help drive innovation through out-of-the-box thinking to solve critical business challenges and demands Contribute to the 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  5-7+ years of experience 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 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) Ability to write optimized complex SQL. Experience creating stored procedures, views, and user defined functions. Experience with scripting and CLI Experience working with Snowflake and/or other modern data platform is preferred. Solid understanding of cloud architecture (Azure, AWS or GCP) Data wrangling experience using python is preferred. 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, 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

Senior Engineer, Software 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 Senior Engineer works on software development and maintenance. They take a leading role in technical designs and execute coding tasks, ensuring high-quality output. Involved in support and operations, they identify system defects, lead troubleshooting efforts, and support code deployments Essential Functions    Core Development, Support, and Maintenance (80%): • Work 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 data ingestion and cleansing, core web application development, analytics, visualizations, automation, integration, and much more • Deploy new builds and features to production environments • Lead coordination in time and cost estimates of system enhancements, advise on trade-offs of features • Lead coordination 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%): • Help drive innovation through out-of-the-box thinking to solve critical business challenges and demands • Contribute to the 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 5-7+ years of experience Developing software products and solutions Demonstrated knowledge of Agile software development and processes Strong performance in prior software development positions Strong analytical and problem-solving skills   Knowledge, Skills, and Abilities: Hands-on experience in web development using modern technologies; JavaScript (React/Angular), TypeScript, ASP.NET Core, CSS, HTML 5 Hands-on experience in mid-tier software development experience using a major programming language (C#, Python) Hands-on experience in backend databases and SQL Functional knowledge with cloud computing concepts and technologies (AWS, Azure, GCP) 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

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