Associate Director, Data Engineering

Key Skills

Amazon RedShift, Apache Airflow, Apache Beam, Apache Cassandra, Apache Hive, Apache NiFi, AWS, Azure, C Programming, C# Programming, C++, Data science techniques, Database, Elasticsearch, ETL frameworks, Google Cloud Platform (GCP), HBase, Java Programming, Luigi, Machine learning techniques, MongoDB, MySQL, NoSQL, Oracle, PostgreSQL, Python Programming, REDIS, Scala Programming, Snowflake, SPARK Programming, SQL, SQL Server, Supply Chain Management, Teradata

Job Description

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 a Glassdoor Best Place to Work, and we have maintained a spot in the top four since its founding in 2009. We believe that diversity, inclusion, and collaboration are 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.

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, customer insights, statistics, machine learning, data management, supply chain analytics and data engineering. 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

As a member of the growing Cloud, Apps and Data Engineering team in Bain’s Advanced Analytics Group, you will:

• Develop, champion, and implement state-of-the-art Data Engineering concepts, solutions, and best practices.
• Provide guidance on modern cloud data platforms, data ingestions and transformation tools for a wide range of use cases.
• Partner with multi-disciplinary teams to develop production quality code, implement innovative deployment and tooling techniques, and perform infrastructure automation within Bain and our clients.
• Influence and educate clients on data engineering capabilities, often at the executive level, while working closely with business consulting staff to evaluate opportunities and technical solutions across various sectors.
• Be a thought leader within the practice, reflected in knowledge sharing, asset creation, mentoring, etc.
• Act as PD Advisor for AAG team members as needed.
• Travel is required (~30%)

ABOUT YOU

• Master’s degree in Computer Science, Engineering, or a related technical field.
• 4+ years at Senior or Staff level, or equivalent.
• 7+ years of experience programming with Python, Scala, C/C++, Java, C#, Go, or similar programming language.
• 7+ years of experience with SQL or NoSQL databases: PostgreSQL, SQL Server, Oracle, MySQL, Redis, MongoDB, Elasticsearch, Hive, HBase, Teradata, Cassandra, Amazon Redshift, Snowflake.

• 1+ years’ experience overseeing data engineering team members
• 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.

ABOUT US

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. We earned a platinum rating from EcoVadis, the leading platform for environmental, social, and ethical performance ratings for global supply chains, putting us in the top 1% of all companies. 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. 

U.S. Compensation and Benefit Information:

Compensation for this role includes base salary, annual discretionary performance bonus, 401(k) plan with an annual employer contribution based on years of service and Bain’s best in class benefits package (details listed below).

Some local governments in the United States require a good-faith, reasonable salary range be included in job postings for open roles. The estimated annualized compensation for this role is as follows:

In New York City, the good-faith, reasonable annualized full-time salary range for this role is between $225,500 - $271,000; placement within this range will vary based on several factors including, but not limited to experience, education, licensure/certifications, training and skill level

In California state, the good-faith, reasonable annualized full-time salary range for this role is between $225,500 - $271,000; placement within this range will vary based on several factors including, but not limited to experience, education, licensure/certifications, training and skill level

In Washington state, the good-faith, reasonable annualized full-time salary range for this role is between $225,500 - $271,000; placement within this range will vary based on several factors including, but not limited to experience, education, licensure/certifications, training and skill level