← All roles

[Job-31836] Senior Data Developer, Brazil

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

About the role

Senior Data Engineer to build the curated data layer and reconciliation logic for a large-scale Finance data platform modernization for a major US mortgage lender. Focus on transforming raw replicated data into governed Finance measures, with emphasis on versioned SQL transformations, data quality, and downstream BI consumption.

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.

Qualifications

  • 4+ years of hands-on data engineering experience, including nontrivial SQL-based transformation work on a cloud data warehouse.
  • Experience with Snowflake.
  • Experience building dimensional/curated data models from normalized or application-native source structures
  • Experience implementing Slowly Changing Dimensions (Type 2) — effective dating, current record flags, and history preservation
  • Experience implementing or working within a reconciliation/data-quality framework (variance detection, exception handling, tolerance management)
  • Familiarity with temporal data modeling — period state management, late-arriving facts, effective-dated dimension attributes
  • Solid Git-based development workflow and CI/CD promotion experience (dev → test/UAT → production)
  • Awareness of sensitive-data handling in a governed platform — access tiers, classification, security-aware engineering practices
  • Fluent English (B2) — daily collaboration with a distributed engineering team and US client stakeholders

Skills

Required:SQL-based data transformationSnowflakeDimensional/curated data modelingSlowly Changing Dimensions (Type 2)Data reconciliation / data quality frameworkTemporal data modelingGit / CI-CDSensitive data handlingEnglish communication

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