Senior Data Engineer for Finance Data Platform

Ciandt; Colombia; Remote; COP 381,934,000 - 572,902,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 is seeking Senior Data Engineers to build the curated data layer and reconciliation logic for a large-scale Finance data platform modernization for a major US mortgage lender. Two openings on this squad.

You will implement layered transformations in Snowflake, derive business measures, and ensure data quality and governance while collaborating with a distributed team and US client stakeholders.

Qualifications

• 4+ years of hands-on data engineering with SQL-based transformations in a cloud data warehouse.
• Experience with Snowflake and dimensional/curated data models.
• Experience implementing Slowly Changing Dimensions (Type 2) and data reconciliation frameworks.
• Familiarity with temporal data modeling and data quality checks.
• Strong Git-based development workflow and CI/CD promotion.
• Fluent English and collaboration with US stakeholders.

Responsibilities

• Build transformation logic across staging, conformed, and curated layers in SQL in Snowflake.
• Recompute application-layer logic and derive measures from raw data via versioned transformations.
• Flatten source structures into standard dimensional attributes for reporting.
• Capture scattered logic into reusable, versioned transformation code in the curated layer.
• Implement data-quality checks and reconciliation across data pipelines.
• Support downstream BI semantic models and reporting tools with curated objects.
• Participate in code reviews and CI/CD processes as part of the data SDLC.

Skills

Data engineering

SQL

Snowflake

Dimensional model

SCD Type 2

Git

CI/CD

English

Data quality

Tools

dbt

Power BI

Job description

CI&T is seeking Senior Data Engineers to build the curated data layer and reconciliation logic for a large-scale Finance data platform modernization for a major US mortgage lender. Two openings on this squad.

You will implement layered transformations in Snowflake, derive business measures, and ensure data quality and governance while collaborating with a distributed team and US client stakeholders.