Senior Data Engineer: Scalable Pipelines, Data Contracts

CI&T; United States; Remote; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health & dental benefits starting day

Paid parental leave

Dedicated career advisor

Job summary

CI&T seeks a Senior Data Engineer to industrialize data pipelines, strengthen data contracts, and deliver high-quality analytical data for rule compliance. You will lead dbt migrations from DuckDB to PostgreSQL, own scope/versioning, and build scalable onboarding processes for new countries and segments.

The role emphasizes SQL/Python development, data modeling, and collaboration with cross-functional teams to drive reliable, scalable data solutions.

Qualifications

• Experience in data engineering or data-intensive applications.
• Proficiency in Python and SQL.
• Hands-on dbt experience.
• 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 scale and maintainability.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration with stakeholders.

Responsibilities

• Industrialize and optimize dbt pipelines, migrating data workflows to PostgreSQL and retiring interim PowerQuery-like solutions.
• Own versioning of scope and constraints, ensuring consistency across data processes.
• Define and maintain data contracts with Optim-core for reliable analytical data.
• Build reusable onboarding processes to expand to new countries and segments.
• Develop 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 meet business and technical requirements.
• Drive production-ready data engineering solutions with strong governance and quality.
• Support data migration from interim tools to scalable production architectures.

Skills

Strong analytical and problem-solving

Excellent communication

Team collaboration

Reusable scalable design

Software engineering

Tools

dbt

DuckDB

PostgreSQL

Python

SQL

Azure

Job description

CI&T seeks a Senior Data Engineer to industrialize data pipelines, strengthen data contracts, and deliver high-quality analytical data for rule compliance. You will lead dbt migrations from DuckDB to PostgreSQL, own scope/versioning, and build scalable onboarding processes for new countries and segments.

The role emphasizes SQL/Python development, data modeling, and collaboration with cross-functional teams to drive reliable, scalable data solutions.