[Job-31836] Senior Data Developer, Brazil

Lever, Inc.; Brasil; Teletrabalho; BRL 624 000 - 780 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health and dental insurance

Meal and food allowance

Childcare assistance

Extended paternity leave

Wellhub/TotalPass gym partnerships

Profit Sharing and Results Participa—/

Life insurance

Continuous learning platform

Discount club

Language learning platform

Resumo da oferta

CI&T is seeking a Senior Data Engineer to build the curated data layer for a large-scale Finance data platform modernization for a major US mortgage lender, transforming raw replicated data into governed finance measures.

Responsibilities include building SQL transformations across staging to curated layers, adding data-quality checks, and enabling downstream BI consumption. Collaboration with a distributed team and client stakeholders is required.

Qualificações

• Solid hands-on data engineering experience with SQL-based transformations in a cloud data warehouse.
• Experience building dimensional/curated data models from normalized data sources.
• Experience with reconciliation and data-quality checks.
• Git-based development workflow and CI/CD promotion (dev → test/UAT → production).
• Fluent English (B2) for daily collaboration with a distributed team and client stakeholders.

Responsabilidades

• Build transformation logic across warehouse staging, conformed, and curated layers using versioned SQL.
• Recompute business logic and derived values from raw data with tested, versioned transformations.
• Flatten and conform source structures into standard dimensional attributes for reporting.
• Capture scattered logic into reusable transformation code in the curated layer.
• Implement layered reconciliation and data-quality checks from replication to report parity.
• Support downstream BI semantic models and reporting tools with curated objects.
• Participate in code reviews, CI/CD promotion, and automated regression testing.

Conhecimentos

SQL transformations

Dimensional data models

Data quality framework

Git workflow

CI/CD

English (B2)

Ferramentas

Snowflake

Power BI

Descrição da oferta de emprego

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.

Requirements:

• Solid hands-on data engineering experience, including nontrivial SQL-based transformation work on a cloud data warehouse (Snowflake strongly preferred).
• Experience building dimensional/curated data models from normalized or application-native source structures.
• Experience implementing or working within a reconciliation/data-quality framework (variance detection, exception handling).
• Solid Git-based development workflow and CI/CD promotion experience (dev → test/UAT → production).
• Fluent English (B2) — daily collaboration with a distributed engineering team and client stakeholders.

Nice to Have:

• Experience with Microsoft Fabric, Power BI, or another enterprise BI platform as a downstream consumer.
• Experience with financial/GL data modeling (ledger entries, chart of accounts, dimension sets).
• Experience in mortgage, lending, or financial-services data engineering.

Our 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!

More details about our benefits here: https://ciandt.com/br/pt-br/carreiras

#LI-TO1

At CI&T, inclusion starts at the first contact. If you are a person with a disability, it is important to present your assessment during the selection process. See which data needs to be included in the report by clicking here. This way, we can ensure the support and accommodations that you deserve. If you do not yet have the assessment, don't worry: we can support you in obtaining it.