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.
About Us:
At CI&T, our rapid growth is fueled by the innovative solutions we create for our global clients. We are seeking Senior Data Engineers to build the curated data layer and reconciliation logic for a large-scale Finance data platform modernization at a major US mortgage lender — turning raw replicated data into governed, business-defined Finance measures. Two openings on this squad.
Responsibilities:
• Build transformation logic across the warehouse's staging, conformed, and curated layers in versioned SQL, using incremental, declarative transformation patterns.
• Recompute application-layer business logic — such as account balances and other derived values not present in raw replicated data — as tested, versioned transformation logic.
• Flatten and conform key-value/dimension-set source structures into standard dimensional attributes for reporting.
• Capture logic currently scattered across spreadsheets and point-report formulas as reusable, versioned transformation logic inside the curated layer.
• Implement layered reconciliation and data-quality checks, from replication integrity through report-level parity.
• Support enablement of downstream consumers (the BI semantic model and other reporting tools) against approved curated objects — never against raw source tables.
• Participate in code review, CI/CD promotion, and automated regression testing as part of an engineered data SDLC.
#LI-TO1
Skills Required
- 4+ years of hands-on data engineering experience, including substantial SQL transformation work on a cloud data warehouse
- Experience with Snowflake
- Experience building dimensional or curated data models from normalized or application-native source structures
- Experience implementing Slowly Changing Dimensions Type 2, including effective dating, current-record flags, and history preservation
- Experience with reconciliation or data-quality frameworks, including variance detection, exception handling, and tolerance management
- Familiarity with temporal data modeling, including period state management, late-arriving facts, and effective-dated dimension attributes
- Solid Git-based development workflow and CI/CD promotion experience across development, test/UAT, and production
- Awareness of sensitive-data handling, access tiers, data classification, and security-aware engineering practices
- Fluent English for daily collaboration with distributed engineering teams and U.S. client stakeholders
- Experience with dbt or a similar versioned SQL transformation framework
- Experience with Power BI or another enterprise BI platform
- Experience with financial or GL data modeling, including ledger entries, chart of accounts, fiscal calendars, and accounting period state
- Experience in mortgage, lending, or financial-services data engineering
What We Do
CI&T is your end-to-end digital transformation partner. As a digital native, we bring a 27-year track record of accelerating business impact through complete and scalable digital solutions. With a global presence of 6,000+ professionals in strategy, research, data science, design and engineering, we unlock top-line growth, improve customer experience and drive operational efficiency.
