Bain & Company Inc

  • Data Architect

    Job Location US-IL-Chicago
    Job ID
    Posted Date
    Next Generation Product Management
    Regular Full-Time
    Location : Location
  • Overview

    • 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 & Company is one of the world's leading global business consulting firms, serving clients across six continents. It was founded in 1973 on the principle that consultants must measure their success in terms of their clients' financial results. Bain's clients have outperformed the stock market 4 to 1. With offices in all major cities, Bain has worked with over 4,150 major multinational and other corporations from every economic sector, in every region of the world.


    A career at Bain & Company will provide the opportunity to learn in a collaborative teaming environment, drive impact to support our 'Results' mission statement. The firm has a passionate and rich culture that offers an unparalleled business experience that can carry throughout a career.  We hire dynamic individuals that are dedicated to achieving both personal and professional goals.  To learn more about the firm, please visit



    The Team


    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 Role


    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.

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



    • 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 demands.




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

    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