Senior Data Developer, Colombia

Ciandt; Colombia; On-site; COP 120,000,000 - 180,000,000; Full time

Benefits offered by this job

Premium Healthcare

Meal voucher

Maternity and Parental leaves

Mobile services subsidy

Sick pay-Life insurance

CI&T University

Colombian Holidays

Paid Vacations

Job summary

CI&T in Colombia is seeking a Senior Data Developer to build and optimize a large-scale Finance data platform. You will implement transformation logic across staging, conformed, and curated layers in SQL, and ensure data quality and governance for downstream BI consumers.

You will work with Snowflake, dbt, and Git-based CI/CD, implement Slowly Changing Dimensions, and collaborate with US client stakeholders in a distributed team.

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 — daily collaboration with a distributed engineering team and US client stakeholders.

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.

Skills

SQL-based transformations

Snowflake

Git CI/CD

Data modeling

English fluency

Tools

dbt

Job description

Este site está equipado com recursos de acessibilidade. Pressione option+c para ativar o perfil cego ou option+p para acessar o menu de acessibilidade e ajuste a experiência de navegação de acordo com suas necessidades. Skip to main content

Senior Data Developer, Colombia

Colombia

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:

• 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 — daily collaboration with a distributed engineering team and US client stakeholders

Nice to Have:

• 4+ years of hands-on data engineering experience, including nontrivial SQL-based transformation work on a cloud data warehouse.
• Experience with dbt or a similar versioned SQL transformation framework
• Experience with Power BI or another enterprise BI platform as a downstream consumer
• Experience with financial/GL data modeling — ledger entries, chart of accounts, fiscal calendars, accounting period state
• Experience in mortgage, lending, or financial-services data engineering

#LI-TO1

Our benefits include:

• - Premium Healthcare
• - Meal voucher
• - Maternity and Parental leaves
• - Mobile services subsidy
• - Sick pay-Life insurance
• - CI&T University
• - Colombian Holidays
• - Paid Vacations

And many others. Collaboration is our superpower, diversity unites us, and excellence is our standard. We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.

word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1

mmMwWLliI0fiflO&1