← All roles

[Job - 31832] Principal Data Architect, Colombia

CI&T· Theta – Prod_Theta / Homeoffice / Remote
Apply on company site
RemoteHomeofficePosted 3w ago

About the role

Hands-on Principal Data Architect responsible for end-to-end target architecture for large-scale data platform modernization (Azure, Microsoft Fabric, Snowflake) with CDC-based replication and a certified BI semantic layer, including design-and-build collaboration with the development team.

Responsibilities

  • Own the end-to-end target architecture spanning CDC replication, lakehouse landing (Fabric/OneLake), and a layered cloud data warehouse (raw/staging → conformed → curated) on Snowflake.
  • Author and maintain architecture decision records covering transformation mechanism, CDC/load strategy, semantic-model storage mode, warehouse isolation, and cross-platform (lakehouse-to-warehouse) interoperability.
  • Design the curated data layer and dimensional model, including recomputing source-system runtime-calculated values that don't exist in raw replicated data, and conforming key-value dimension structures into standard reporting attributes.
  • Design the strategy for a single certified BI semantic model consumed by all downstream reporting tools, with metric definitions versioned in one governed place.
  • Work hands-on inside the codebase alongside the development team through the design-and-build core.
  • Lead technical discovery with client architecture, security, and platform teams; resolve open interoperability and network/identity design questions.
  • Own quality gates for architecture decisions — design validation, baseline lock, cutover readiness — and produce the evidence client stakeholders need to sign off.
  • Mentor the development team on transformation patterns, incremental materialization, and reconciliation/data-quality design.

Qualifications

  • Solid experience in data architecture, including hands-on delivery (not review-only) on enterprise data platform modernization programs.
  • Proven experience architecting cloud data platforms on Snowflake, including layered raw/staging/curated models and incremental transformation patterns (e.g., dynamic or materialized tables).
  • Experience with Microsoft Fabric/OneLake, or a comparable lakehouse platform, including cross-platform interoperability between a lakehouse and a cloud data warehouse.
  • Experience architecting change-data-capture (CDC) based replication pipelines (e.g., Qlik Replicate, Fivetran, Debezium, or similar) from a relational source into a cloud platform.
  • Experience designing governed, certified BI semantic layers (Power BI or equivalent) consumed by multiple reporting tools.
  • Strong command of data governance fundamentals: classification, masking, row-level access, lineage.
  • Fluent English (C1) — direct engagement with client architecture, security, and executive stakeholders.

Skills

Required:Data architectureSnowflakeMicrosoft Fabric/OneLakeCDC-based replicationBI semantic model designData governanceEnglish fluency

Benefits

  • Premium Healthcare
  • Meal voucher
  • Maternity and Parental leaves
  • Mobile services subsidy
  • Sick pay-Life insurance
  • CI&T University
  • Colombian Holidays
  • Paid Vacations
  • And many others.
Last updated Oct 21, 2026. Interested? Apply on the company site.

About CI&T

Technology Transformation Specialists

A global technology consulting and digital transformation firm that combines human expertise with AI to develop innovative solutions.

Technology transformationAISoftware developmentCloud servicesDigital experienceData analyticsApplication modernizationConsulting
Company profileWebsite

More open roles at CI&T