← All roles

[Job - 31832] Principal Data Architect, Brazil

CI&T· Theta – Prod_Theta /
Apply on company site
Hybrid (Brazil)HomeofficePosted 3w ago

About the role

Hands-on Principal Data Architect leading a large-scale data platform modernization for a major US mortgage lender, combining design, build, and mentoring across CDC-based replication, lakehouse (Fabric/OneLake), and Snowflake-based data warehousing, with a certified BI semantic layer.

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 layerData governance

Benefits

  • Health and dental insurance
  • Meal and food allowance
  • Childcare assistance
  • Extended paternity leave
  • Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass
  • Profit Sharing and Results Participation (PLR)
  • Life insurance
  • Continuous learning platform (CI&T University)
  • Discount club
  • Free online platform dedicated to physical, mental, and overall well-being
  • Pregnancy and responsible parenting course
  • Partnerships with online learning platforms
  • Language learning platform
  • And many more!
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