jobapplier

[Job - 31832] Principal Data Architect, Colombia

CI&T

This job is closed: the employer no longer lists it.

Responsibilities

  • you build alongside the development team through design and build, not a review-from-a-distance seat.
  • This position calls for a hybrid architect: someone who can design and defend complex technical decisions in front of the client's data and cloud teams at a strategic level, while also working hands-on with the development team to validate and build the solution. A strong grounding in software and data development is essential — profiles limited to analytics work alone will not have the depth this role requires.
  • 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.
  • 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.

Preferred

  • Experience with Microsoft Dynamics 365 Business Central or another ERP as a source system for financial/GL reporting.
  • Experience in mortgage, lending, or broader financial-services data platforms.
  • Familiarity with AI-assisted development toolchains inside a governed software development lifecycle (SDLC), where AI output is always a draft requiring human sign-off on production logic.

Responsibilities

Requirements for this challenge

  • 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.
  • Strong command of data governance fundamentals: classification, masking, row-level access, lineage.
  • Fluent English (C1) — direct engagement with client architecture, security, and executive stakeholders.

Nice to Have

#LI-JP3

Our benefits include

  • 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.
  • Collaboration is our superpower, diversity unites us, and excellence is our standard.
  • We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.
Browse open jobs