Data Architect & Canonical Model Lead

*About Us: *

BDIPlus, a US-based leading transformation Consulting & Customer Data Platform (CDP) company, is dedicated to delivering cutting-edge capabilities and solutions that foster the development of enduring competitive advantages. Our innovative solutions showcase our unparalleled proficiency in technology and our profound domain expertise within the Financial Services and Insurance sectors. By synergizing our unmatched technical skills with a comprehensive grasp of each client’s institutional landscape and distinctive areas for improvement, we empower them to convert data into actionable and well-organized information. This facilitates precise decision making, increased efficiency, and rampant business growth.

*About the Role *

We're seeking an experienced Data Architect & Canonical Model Lead to own the canonical data model across multiple teams and systems. You'll design cross-system entity models for policy, customer, and distributor data, lead architecture reviews, and — critically — see those models through to production: implemented in AWS, deployed through automated pipelines, and governed by contracts and quality checks that run without manual intervention.

This is not a documentation role. Models you design are expected to be enforced in running systems.

Key Responsibilities

Canonical modelling and architecture:

• Own canonical data model reconciliation across teams, ensuring consistency and accuracy.
• Design and maintain cross-system entity models for policy, customer, distributor, claims, and product domains.
• Lead architecture reviews for alignment with enterprise data standards.
• Identify gaps and inconsistencies across systems and drive resolution.
• Mentor engineers and analysts on modelling and architecture practice.

Implementation and production systems

• Translate canonical models into physical implementations: warehouse and lakehouse schemas, event and API payload contracts, and mappings from source systems.
• Define and enforce data contracts between producers and consumers — schema, semantics, ownership, and SLAs — with breaking-change detection in CI.
• Design integration patterns across batch, CDC, and event-driven paths; own how entities are keyed, versioned, deduplicated, and resolved across systems.
• Model slowly changing dimensions, effective-dating, and bitemporal history where policy and regulatory reporting require point-in-time accuracy.
• Embed automated data quality into pipelines — schema, referential integrity, freshness, and reconciliation checks between source and canonical layers, with alerting and quarantine rather than silent failure.
• Own lineage, cataloguing, and metadata so any field can be traced to source and to consumer.

AWS and deployment

• Design and govern the data platform on AWS: S3-based lake with Glue Catalog, Redshift and/or Athena, Lake Formation for access control, and Glue, EMR, or Databricks for processing.
• Define deployment practice for data assets — schemas, models, and pipelines managed as code through Git, with CI/CD, environment promotion (dev/test/prod), and reviewable, reversible schema migrations.
• Manage infrastructure as code (Terraform or CloudFormation) and set standards for the teams building on the platform.
• Set orchestration and observability standards across pipelines, including monitoring, alerting, cost visibility, and incident response for data outages.

Governance

• Ensure compliance with data governance, security, privacy, and retention standards.
• Design access controls, masking, and tokenisation appropriate to a regulated environment, and support audit and regulatory reporting requirements.

Qualifications & Skills

• 5–8 years in data architecture, data modelling, or a closely related role.
• Proven ownership of canonical or enterprise data models and reconciliation processes.
• Strong cross-system entity modelling — particularly policy, customer, and distributor domains.
• Deep modelling fundamentals: conceptual/logical/physical modelling, normalisation, dimensional modelling (Kimball), Data Vault or equivalent, and entity resolution across systems with conflicting keys.
• AWS hands-on: S3, Glue, Athena or Redshift, Lake Formation, IAM. Table formats such as Iceberg or Delta Lake.
• SQL at an advanced level; Python for pipeline, validation, and tooling work.
• Data integration and ETL/ELT design across batch and streaming; dbt or equivalent transformation frameworks.
• Deployment practice for data platforms — Git, CI/CD, infrastructure as code, environment promotion.
• Automated data quality and validation tooling in production use.
• Modelling tools (Erwin, SqlDBM, ER/Studio, or equivalent) and the ability to keep models synchronised with what's actually deployed.
• Excellent communication and stakeholder management — you'll influence standards you don't have direct authority over.

Preferred Skills

• Insurance, financial services, or another regulated industry — policy administration, claims, or distribution systems.
• Industry data models: ACORD, OMG, or similar.
• Data governance frameworks and tooling (Collibra, Alation, AWS DataZone).
• Event streaming (Kafka, Kinesis) and schema registry practice.
• Master data management and identity resolution.
• Legacy modernisation — mainframe or policy admin system migration to cloud.
• Cost optimisation for large-scale data platforms.

Our Purpose and Culture:
At BDIPlus, our mission is to help enterprises utilize their resources more efficiently, implement effective information management, and empower them by enabling richer insights and intelligence.

We are driven by a single purpose: empower the technology transformation. We are passionate about creating foundational technology platforms for enterprise data and information management. Our employees are at the heart of the work we do at BDIPlus. We are committed to encouraging and celebrating innovation, creativity, and hard work among our team members.

Working at BDIPlus offers:
A diverse, fun, highly intelligent, and innovative team. Provident Fund A competitive salary and an annual bonus. Standard time off, sick leave, and holidays. An environment where creative thinking is encouraged, and innovation drives everything we do.