Bain & Company Inc

Data Architect

Job Location US-IL-Chicago
Job ID
Posted Date
Next-Generation Software Solutions
Regular Full-Time
Location : Location


Bain & Company is a global consultancy that helps the world’s most ambitious change makers define the future. Across 59 offices in 37 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 over $1 billion in pro bono services brings our talent, expertise and insight to organizations tackling today’s urgent challenges in education, racial and social equity, economic development and the environment. Since our founding in 1973, we have measured our success by the success of our clients. We proudly maintain the highest level of client advocacy in the industry, and our clients have outperformed the stock market 4-to-1




  • Do you want to help shape the future of the consulting industry?
  • Do you want to work with Bain's most senior stakeholders on strategic Global priorities?
  • Do you want the variety and dynamism of a technology start-up environment within the comfort of a major management consultancy?


Bain's Next-Generation Software Solutions (NGSS) team has been set up to help Industry and Capability Practices digitize their Intellectual Property through a diversified set of technology, software, services, delivery, and support.


The team supports practices, case teams, and clients through various product delivery models including best-in-class partnerships with leading SaaS vendors, product development using industry-leading low code and business engineering platforms, and developing highly complex full-stack custom software solutions and products.


In addition to core product development, the team fills critical gaps through a growing technical services catalogue including technical architecture and code assessments, expert architecture consulting, business automation and data integration, visualization services, and infrastructure hosting and support consulting.


Underlying these products and services is Next Gen’s Customer Success Program, ensuring the tools are setup and configured according to the case team and client’s needs, end-users are on-boarded and trained properly, and a global support structure is in-place to quickly answer any questions or address issues.


The results of these efforts are a greater ability to sell cases effectively, serve clients efficiently, and drive capability transfer. In short, it is about better results that enhance our clients' and our own competitiveness.




The Next Gen Software Solutions team is seeking a Data Architect. Working under the guidance of the tea’ms Senior Architect, and alongside the team’s Program Manager, Business Engineers, and Product Consultants, this multi-faceted role will help drive the overall data architecture approach of Next Gen software.

The role is responsible for defining the data strategy and technology stacks for various use cases, overseeing the architecture and design, ensuring implementation and delivery follows the agreed upon approach, and helping to setup, automate, and operationalize data pipelines. Other facets of the role include providing strategic and tactical direction to development teams, expert advisory input, taking part in hands-on design and proof of concepts (POCs), development and architectural reviews to ensure quality, scalability, performance, consistency, reliability and client/personal data protection.

This is a highly visible role within Bain and will help to set the strategic and technical direction for both Next Gen software and Bain at the enterprise level.

  • Collaborate closely with other Bain software, technology, and cloud engineering teams and experts on establishing best practices for data architecture optimized for scalability, maintainability, and security.
  • Provide technical leadership and data architectural direction to internal and external development teams on the design, development, implementation, and deployment of highly performant, secure and scalable software.
  • Participate in the design of data schema, ingestion, transformation and orchestration alongside development teams, including performing formal reviews and providing feedback on quality, scalability, performance, consistency, reliability and client/personal data protection.
  • Develop, present, and maintain materials such as data flow and conceptual diagrams in order to clarify data architecture and flow to a wide range of technical and non-technical groups.
  • Work with product and client teams on architecting and developing simple to complex data integration strategies using a variety of approaches.
  • Formally document, train vendors, and strictly enforce and maintain adherence to best practices in the area of data security, performance and scalability.
  • Assist the team’s architecture team on performing in-depth technology evaluations and risk assessments of vendor software and platforms data backend.
  • Participate in estimation, planning, and costing of new projects and initiatives across multiple metrics.
  • Lead evaluation efforts with new and emerging data technologies to assess technical fit and risk.
  • Participate in build versus buy assessments, evaluate trade-offs of various options, and work with team to present final recommendations to senior stakeholders and management.
  • Investigate and keep up-to-date on emerging and cutting-edge data technologies and trends, lead knowledge sharing.
  • Drive innovation through out-of-the-box thinking to solve critical business challenges and demand. 


The role is based in Chicago - local candidates or those willing to relocate only.


This role is not currently live but is a talent pool for a role we expect to have later in the year. If you are interested please apply to the role and we'll be in touch when the role becomes live.




  • Bachelor of Science degree in Computer Science, Applied Mathematics, Physics, Engineering, Information Sciences or any other technology-related field, or strong relevant work experience.
  • Minimum of 5+ years of relevant experience in enterprise data architecture/engineering and data-driven focus work in a fast-paced, complex business setting.
  • Experience with large enterprise data warehouse architecture design including logical and physical model development.
  • Strong experience with traditional relational database management systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle) and SQL skills, including developing stored procedures, functions, and triggers.
  • Experience with NoSQL databases (e.g., DynamoDB, MongoDB) and cloud-based data warehouses (e.g., Redshift, SQL Data Warehouse, Snowflake, MemSQL).
  • Experience designing, implementing, and supporting end-to-end automated data processing ETL pipelines using a variety of tools and technologies (e.g., Alteryx, SSIS, Informatica, Talend, Pentaho).
  • Experience with production reporting and BI platforms a plus (e.g., Tableau, Power BI, Qlik) a plus.
  • Experience interfacing with leading 3rd party dataset providers (e.g., Nielsen, IRI) a plus.
  • Experience with Hadoop ecosystem (e.g., Hive, HBase, Pig, Spark) a plus.
  • Strong communication and presentation skills, including documenting complex data flows and processes for long-term support and maintenance.
  • Results driven, analytical and creative thinker, self-motivated and proactive, highly organized and demonstrated ability to stay calm and composed in a fast moving environment.
  • 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, not be afraid to fail.
  • Ability to travel as needed, including internationally, up to 25% of the time.





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.


ind 123


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed