B

Boston Consulting Group

Global strategy and transformation consulting firm

Data Architect Director & Chapter Lead - Martech

Data EngineeringConfirmed live in the last 24 hours
Full-timeGurugram, Haryana, IndiaNo salary listed

About the Job

Requirements

  • 13+ years of data engineering experience focused on data warehouse architecture, pipeline development, and data modeling, including at least 2–3 years in a chapter lead, technical lead, or senior engineering leadership role.
  • Advanced SQL proficiency and hands-on Snowflake experience, including data modeling, performance optimization, security configuration, and analytical consumption-layer design.
  • Expert-level proficiency with dbt for data transformation and data model development, and hands-on Apache Airflow experience for pipeline orchestration and job scheduling.
  • Experience applying SCD, CDC, and DQ/DV frameworks in production data engineering environments, including building, maintaining, and debugging these patterns.
  • Ability to write clean, well-documented, version-controlled code using GitHub or Bitbucket.
  • Experience integrating data from complex, multi-platform marketing or enterprise technology ecosystems.
  • Working knowledge of AI and machine learning concepts as applied to data engineering, including intelligent pipeline orchestration, AI-assisted data quality, and Snowflake Cortex or equivalent capabilities.
  • Python scripting skills for pipeline development, automation, and data engineering tooling.
  • Experience with cloud platforms and familiarity with CI/CD pipeline tooling and version control workflows in production data engineering.
  • Experience working in Agile and Scrum delivery environments, including sprint ceremonies, backlog grooming, and cross-functional collaboration with product owners, architects, and data subject-matter experts.
  • Written and verbal communication skills to present architecture decisions, engineering trade-offs, and technical recommendations clearly to non-technical product owners and marketing stakeholders.
  • Experience with Jira and Confluence for delivery management and technical documentation.
  • Bachelor's degree in Computer Science, Information Science, Data Management, or a related field, or equivalent practical experience.

Responsibilities

  • Lead the data engineering chapter serving Global Marketing and Communications by setting technical direction, establishing engineering standards, and fostering engineers' skill development and career growth.
  • Provide architectural oversight and hands-on review of engineering work across the chapter, upholding code quality, architectural consistency, pipeline reliability, and data modeling standards.
  • Mentor and develop chapter engineers through technical reviews, structured feedback, growth opportunities, and capability building.
  • Partner with squad product owners to align engineering capacity, technical priorities, and sprint commitments with marketing analytics products and insight capabilities.
  • Contribute to hiring decisions, team structure, and data engineering development.
  • Design, document, and implement scalable data pipelines for marketing analytics models, dashboards, channel insight products, audience intelligence, and CRM operations using Snowflake, dbt, and Apache Airflow.
  • Build monitoring and alerting for match-rate quality, pipeline failures, and unexpected changes in merge or split volume.
  • Establish data lineage so resolved identities can be traced to source records and merge logic.
  • Build processes for both merging records and unmerging incorrectly merged records.
  • Implement data standardization, including name normalization, address formatting, and email canonicalization, before matching.
  • Integrate data across the marketing technology ecosystem into the marketing data environment in a structured, governed, and scalable manner.
  • Apply SCD, CDC, and DQ/DV frameworks across pipeline development to ensure data is accurate, complete, historically traceable, and fit for analytical use.
  • Evaluate and implement technical solutions, data engineering patterns, and platform capabilities; contribute MVPs and proofs of concept to assess feasibility.
  • Own marketing data engineering quality and governance standards, implementing monitoring, validation, and alerting to identify data-quality issues before they affect stakeholder-facing dashboards or analytical outputs.
  • Implement data performance and security policies aligned with governance objectives, regulatory requirements, and privacy obligations in partnership with enterprise data governance, IT security, and legal colleagues.
  • Maintain accessible documentation of data models, pipeline architecture, transformation logic, and engineering decisions.
  • Design end-to-end identity resolution architecture spanning CRM, marketing automation, web and behavioral data, campaign platforms, and third-party sources.
  • Define when to use deterministic matching, such as exact email, phone, or CRM ID matches, versus probabilistic matching, such as fuzzy name/address matching and behavioral signals.
  • Design the golden-record or unified-profile structure, including fields, conflict resolution, and source-system precedence by data type.
  • Build a confidence-scoring framework to classify matches for automatic merging, review, or rejection.
  • Define survivorship rules that determine which data persists in unified profiles after records merge.
  • Design identity architecture for scale and extensibility so new tools, regions, and business lines can be onboarded without redesigning the core model.
  • Monitor the health, performance, and reliability of marketing data pipelines and Snowflake; establish observability, alerting, and incident-response protocols.
  • Lead triage and resolution of critical technical incidents, communicate with product owners and stakeholders, and ensure systematic root-cause analysis and remediation.
  • Identify and address performance bottlenecks through regular performance reviews and platform optimization.
  • Build working relationships with global data and technology stakeholders, align marketing engineering with firm-wide data standards, and proactively manage dependencies.
  • Partner with IT architecture and platform teams on shared infrastructure decisions, including AWS cloud services, Azure Active Directory integration, and CI/CD tooling.
  • Engage with product portfolio management and cross-functional data product teams across finance, HR, legal, and other functions, contributing marketing analytics perspectives and tracking relevant data and security trends.
  • Set data engineering direction in line with MarTech strategy and standards, establish data standards, and ensure marketing platforms support current analytics needs and future intelligent data capabilities.
  • Partner with product owners, analysts, and insight leaders to build and maintain reliable, high-quality data infrastructure for marketing analytics and data products.

Desired Qualifications

  • Familiarity with marketing technology platforms such as Dynamics CRM, Adobe Analytics, Marketo, or Sprinklr, or equivalent platforms.
  • Experience with PowerShell or an equivalent tool.
  • AWS is preferred; Azure and Google Cloud Platform are also valued.
  • Familiarity with Oracle, SQL Server, or master data management systems.

About the Company

Boston Consulting Group

Global strategy and transformation consulting firm

BCG provides global management consulting, advising leaders in strategy and transformation across industries, with expertise in M&A, operations, pricing, sustainability, and AI. BCG X builds AI solutions, digital products, and new ventures by combining engineers, data scientists, designers, and venture builders for clients. Specialist units Inverto, Platinion, and Quantis support procurement, IT architecture, and sustainability, while the BCG Henderson Institute supplies research. The goal is to help clients achieve lasting performance improvements and durable value through strategic advisory plus hands-on technology execution.

Company size
10,001+
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1963

Recently Posted Jobs

Explore more opportunities at Boston Consulting Group

See more jobs