Job Description – Data Architect

Key Responsibilities:

• 
  Design DB2 ↔ Azure integration and hybrid data architectures.

• 
  Define cloud-based
  Operational Data Store (ODS)
  strategy and data models.

• 
  Implement DB2-to-Azure ingestion using
  CDC, replication, streaming, and batch
  .

• 
  Design Azure-to-DB2
  write-back/mirroring
  solutions.

• 
  Design data pipelines using ADF, Databricks, Synapse, Event Hub, and Azure Functions.

• 
  Define real-time and near-real-time data synchronization patterns.

• 
  Establish data governance, lineage, security, reconciliation, and audit frameworks.

• 
  Drive target-state architecture, modernization roadmap, and cost optimization.

• 
  Provide technical leadership, architecture reviews, and guidance to engineering teams.

Required Skills:

• 
  10+ years in Data Architecture/Data Engineering.

• 
  Strong expertise in
  IBM DB2/Mainframe and PostgreSQL
  .

• 
  Strong Azure data platform experience:
  ADF, ADLS Gen2, Databricks, Synapse, Event Hub/Service Bus
  .

• 
  Hands-on knowledge of
  CDC and replication
  technologies such as Q Replication, Kafka, or Debezium.

• 
  Experience with
  ODS, hybrid architecture, data modeling, and bi-directional data flows
  .

• 
  Strong SQL and data consistency/reconciliation knowledge.

• 
  Programming experience in
  Python/Java
  .

• 
  Experience with DataStage or similar integration tools.

• 
  Snowflake and data governance experience is an added advantage.