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. Owning architecture, CDC pipelines, governed BI semantics, and hands-on delivery.
Responsibilities:
- Own the end-to-end target architecture spanning CDC replication, lakehouse landing (Fabric/OneLake), and a layered cloud data warehouse 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
- Recompute source-system runtime-calculated values and conform key-value dimension structures into standard reporting attributes
- Design the strategy for a single certified BI semantic model with governed, versioned metric definitions
- Work hands-on inside the codebase alongside the development team through design and build
- Lead technical discovery with client architecture, security, and platform teams
- Resolve interoperability and network/identity design questions
- Own architecture quality gates, including design validation, baseline lock, and cutover readiness
- Produce evidence 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 on enterprise data platform modernization programs
- Proven experience architecting cloud data platforms on Snowflake, including layered raw/staging/curated models and incremental transformation patterns
- 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 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)
- Experience with Microsoft Dynamics 365 Business Central or another ERP as a source system for financial/GL reporting (nice to have)
- Experience in mortgage, lending, or broader financial-services data platforms (nice to have)
- Familiarity with AI-assisted development toolchains inside a governed software development lifecycle (nice to have)
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
- Health and Well-being team, inclusion specialists, and affinity groups
- Support and accommodations for people with disabilities during the selection process
Similar Jobs
Principal Data Architect
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.
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.