Senior Engineer, Data Engineering
Bain & Company
New Delhi, Delhi, India
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