Senior Engineer, Software Engineering

Description & Requirements

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 currently #1 ranked consulting firm on Glassdoor’s Best Places to Work list and have maintained a spot in the top four on Glassdoor’s list since its founding in 2009. Extraordinary teams are at the heart of our business strategy, but these don’t happen by chance. They require intentional focus on bringing together a broad set of backgrounds, cultures, experiences, perspectives, and skills in a supportive and inclusive work environment. We hire people with exceptional talent and create an environment in which every individual can thrive professionally and personally. WHO YOU’LL WORK WITH Coro is Bain’s persistent product development and engineering organization serving the firm’s digital solutions across Commercial Excellence (B2B) and the newly established Demand Generation Suite (B2C). Coro brings together technology, data, and services to build and operate proprietary solutions that create differentiated value for Bain’s clients and case teams. This role sits within the newly established B2C pillar of Coro, building the technical foundation for Artemis – Bain’s AI-driven marketing and commercial investment allocation platform, and one of three products in the Demand Generation Suite. WHERE YOU’LL FIT WITHIN THE TEAM The Senior Data Engineer owns the data ingestion, transformation, and quality infrastructure that forms the foundation of Artemis. The data layer is the first unlock for everything else on the product roadmap — nothing downstream in analytics, synthesis, or AI automation works without clean, well-structured client data. Senior Data Engineers build and maintain pipelines that take raw commercial datasets - media spend, impressions, sell-out point-of-sale data, household panel data (e.g., Kantar, Numerator), retailer electronic point-of-sale feeds, and campaign performance data and transform them into structured, reliable inputs for Artemis's Bayesian marketing mix models and channel allocation analytics. This role requires both the engineering discipline to build production-grade pipelines and enough domain understanding to design data models that accurately represent the commercial and marketing data Artemis works with. WHAT YOU’LL DO Data Ingestion and Transformation Build and maintain pipelines that ingest, validate, and transform Artemis client datasets - including media platform feeds (spend, impressions), sell-out volumes, household panel data, and macro indicators — handling the full wrangling workflow from initial data diagnosis through mapping, transformation, and imputation to produce clean, model-ready outputs. Design and implement ETL pipelines that are reliable, testable, and adaptable to the variety of data formats and naming conventions encountered across different client engagements. Data Quality Build the data quality assessment logic that validates completeness, consistency, format, and referential integrity across client datasets. Produce programmati c data quality reports that the consulting team and clients can act on. Ensure all data assets produced by Artemis pipelines conform to the shared Demand Generation Suite data model: structured, documented, and available via API to enable benchmarking and cross-engagement analytics. Data Modeling and External Integrations Design and maintain adaptable data models that keep data structured, consistent, and accessible as business needs and the technology continue to evolve. Manage integrations with third-party and Bain-proprietary data sources used for enriching Artemis client datasets, including Nielsen, Circana, or GfK sell-out data, Kantar or Numerator panel data, media platform APIs, macro data feeds (weather, holidays, inflation), and digital shelf data. Work closely with AI Engineers to ensure the data