Principal Data Architect
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Principal Data Architect modernizing a major US mortgage lender’s Finance data platform with Azure, Microsoft Fabric, and Snowflake. Designing CDC pipelines, governed semantic models, and dimensional data architecture at CI&T.
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 interoperability
- Design the curated data layer and dimensional model, including recomputing source-system runtime-calculated values 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, including design validation, baseline lock, and cutover readiness
- Produce evidence required for client stakeholder sign-off
- Mentor the development team on transformation patterns, incremental materialization, and reconciliation/data-quality design
Requirements:
- 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
- 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
Benefits:
- Premium Healthcare
- Meal voucher
- Maternity and Parental leaves
- Mobile services subsidy
- Sick pay-Life insurance
- CI&T University
- Colombian Holidays
- Paid Vacations
- Inclusive and safe work environment
- Diversity and inclusion initiatives
Similar Jobs
Principal Data Architect
Principal Data Architect modernizing a major US mortgage lender’s finance data platform with Azure, Microsoft Fabric, and Snowflake. Owning architecture, CDC pipelines, governed BI semantics, and hands-on delivery.
Geospatial Data Engineer
Geospatial Data Engineer building scalable GIS pipelines and data products for Arden University. Supporting evidence-based decisions across its expanding digital higher-education ecosystem.
Data Engineer
Senior Data Engineer building data ingestion, Snowflake, and CI/CD infrastructure. Supporting analytics across the business for a client in Gdynia, Poland.
Data Engineer
Lead Data Engineer designing scalable data-processing systems for Kainos, a UK digital technology services company. Leading engineers, ensuring software quality, and delivering secure ETL/ELT solutions.
Junior Data Engineer
Junior Data Engineer building Microsoft Fabric pipelines and data quality checks for Kreate’s plastic manufacturing operations. Supporting dashboards, planning, and daily reporting across ERP, HR, and retail data.
Data Engineer – Product, Pricing & Inventory Data
Data Engineer building scalable product, pricing, and inventory data products for INTERSPORT’s e-commerce platform. Ensuring data quality, integration, governance, and availability for digital products and analytics.
Data Engineer – Tracking & Behavioral Data
Data Engineer für Tracking und Verhaltensdaten bei INTERSPORTs E-Commerce-Digitalunit. Aufbau von Event-Infrastruktur, Datenpipelines und Datengrundlagen für Analytics, Personalisierung und A/B-Tests.
Data Engineer – Commerce and Customer Data
Data Engineer developing scalable commerce and customer data products for INTERSPORT’s e-commerce unit. Building ETL/ELT pipelines supporting analytics, product development, and AI applications.
Data Engineer – Fulfillment & Logistics Data
Data Engineer building fulfillment and logistics data products for INTERSPORT’s e-commerce platform. Developing pipelines, data models, and tracking integrations for orders, deliveries, returns, and partner performance.
Senior Data Engineer – Fluent English
Engenheiro de Dados Sênior desenvolvendo soluções analíticas com Azure, Snowflake e DBT. Atuando em pipelines, modelagem, APIs e governança de dados para clientes corporativos.
Senior Director of Data Engineering
Founding data leader scaling CuraLinc Healthcare’s mental-health analytics platform. Owning governed pipelines, executive dashboards, client reporting, and data team growth.
Junior Data Engineer – Snowflake
Analista de Dados Júnior na Keyrus, empresa internacional de dados e IA, atuando remotamente com Snowflake, SQL e soluções de Cloud Data Platform.
Data Engineer
Data Engineer building scalable data pipelines and integrations for VSP Vision, a vision-care company. Supporting analytics, data quality, and strategic business data use.
Principal Commercial Data Engineer
Principal Data Engineer architecting MGM Resorts’ commercial Lakehouse and analytics ecosystem. Modernizing Gaming, Hospitality, Loyalty, and Marketing data platforms for analytics and AI/ML.
Senior Denodo Data Engineer
Senior Denodo Data Engineer building secure, scalable data virtualization solutions for WLG’s enterprise clients. Supporting analytics, reporting, operational use cases and AI-enabled data services.
Senior Data Engineer
Senior Data Engineer building Teleport's internal data platform for AI infrastructure identity security. Designing warehouses, pipelines, and trusted business metrics across the company.
IS Data Warehouse Architect, II
Data warehouse architect designing data models, ETL specifications, and analytics architectures for CareOregon’s health insurance operations. Analyzing data sources and coordinating vendors from home in Oregon.
Data Engineer
Data Engineer managing SQL Server databases, performance, security, upgrades, and recovery. Supporting DMI’s secure managed IT and digital services for government and commercial clients.
Staff Data Engineer
Staff Data Engineer architecting KnowBe4’s event-driven, AI-powered security data platform in Brazil. Guiding technical strategy, cloud architecture, data engineering, and AI safety guardrails.
Senior Data Engineer, Brazil
Senior Data Engineer building high-scale, near real-time data pipelines for KnowBe4’s digital workforce security platform. Supporting global product teams from Brazil across US time zones.