Senior Data Engineer: Production-Ready Pipelines

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

Benefits offered by this job

Competitive salary

Generous vacation days

Health & dental benefits starting day

Annual profit-sharing distribution

Parental leave

Career advisor

Job summary

CI&T is seeking a Senior Data Engineer in Colombia to help build scalable, reliable data solutions. You will industrialize data pipelines, define data contracts with Optim-core, and enable onboarding of new countries and segments.

The role focuses on dbt, Python, SQL, DuckDB to PostgreSQL migrations, and production-ready pipelines, while collaborating with cross-functional teams to meet business needs.

Qualifications

• Strong experience in software engineering with a focus on data engineering or data-intensive applications.
• Proficiency in Python and SQL.
• Hands-on experience with dbt and building data transformation pipelines.
• Experience with DuckDB and PostgreSQL, including data migration and query optimization.
• Experience with Azure cloud environments.
• Understanding of data modeling, data quality, versioning, and data contracts.
• Ability to design reusable solutions that support scalability and maintainability.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills, with the ability to translate business needs into reliable technical solutions.

Responsibilities

• Industrialize and optimize dbt pipelines, migrating data workflows from DuckDB to PostgreSQL and retiring interim PowerQuery solutions.
• Own the versioning of scope and constraints, ensuring consistency, traceability, and reliability across data processes.
• Define and maintain data contracts with Optim-core, ensuring the availability and quality of analytical data required for rule compliance.
• Build reusable and scalable onboarding processes to support the expansion into new countries and business segments.
• Develop and maintain data transformation workflows using Python, SQL, dbt, and PostgreSQL.
• Contribute to data architecture decisions, pipeline reliability, and engineering best practices.
• Collaborate with cross-functional teams to ensure data solutions meet business and technical requirements.

Skills

Python

SQL

dbt

DuckDB

PostgreSQL

Azure

Data modeling

Data quality

Data contracts

Versioning

Reusable solutions

Analytical thinking

Problem-solving

Communication

Collaboration

Tools

DuckDB

PostgreSQL

Azure

Job description

CI&T is seeking a Senior Data Engineer in Colombia to help build scalable, reliable data solutions. You will industrialize data pipelines, define data contracts with Optim-core, and enable onboarding of new countries and segments.

The role focuses on dbt, Python, SQL, DuckDB to PostgreSQL migrations, and production-ready pipelines, while collaborating with cross-functional teams to meet business needs.