Principal Data Architect, Colombia

Ciandt; Colombia; Híbrido; COP 120.000.000 - 180.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Premium Healthcare

Meal voucher

Maternity and Parental leaves

Mobile services subsidy

Sick pay-Life insurance

CI&T University

Colombian Holidays

Paid Vacations

Descripción de la vacante

CI&T is seeking a Principal Data Architect in Colombia to own the target architecture for a large-scale data platform modernization. You will work hybrid, design the lakehouse-to-warehouse model on Snowflake, and build the certified BI semantic layer while guiding the dev team through implementation and governance.

Fluent English is required, and experience with Fabric/OneLake is a plus. You will mentor engineers, drive architectural decisions, and ensure successful cutover readiness across

Formación

• Solid experience delivering enterprise data platform modernization.
• Experience with Snowflake layered raw/staging/curated models.
• Experience with Fabric/OneLake or comparable lakehouse platforms.
• CDC-based replication pipelines from relational sources.
• Governed BI semantic layers consumed by multiple tools.
• Strong data governance fundamentals: classification, masking, lineage.

Responsabilidades

• Own end-to-end target architecture for cloud data modernization.
• Maintain architecture decision records for transformation/CDC/load strategies.
• Design curated data layer and dimensional models for reporting.
• Develop a single certified BI semantic model used across tools.
• Collaborate hands-on inside the codebase with the dev team.
• Lead discovery with client architecture, security, and platform teams.
• Ensure design validation, baseline lock, and cutover readiness.
• Mentor the team on transformation patterns and data quality.

Conocimientos

Data architecture

Hands-on delivery

Cloud data platforms

CDC pipelines

BI semantic layer

Data governance

Herramientas

Snowflake

Microsoft Fabric/OneLake

Qlik Replicate

Fivetran

Debezium

Power BI

Descripción del empleo

Principal Data Architect, Colombia

At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.

With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.

We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.

At CI&T, our rapid growth is fueled by the innovative solutions we create for our global clients. We are seeking a hands-on Principal Data Architect to own the target architecture for a large-scale data platform modernization at a major US mortgage lender - migrating Finance reporting off a legacy on-premises source system onto a governed cloud data platform (Azure, Microsoft Fabric, and Snowflake), with CDC-based replication and a certified BI semantic layer. This is deliberately a hands-on role: 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.

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.

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.
• 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.

Nice to Have

• 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.

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.