Senior Data Engineer - Build Production-Ready Data Pipelines

CI&T; Portugal; On-site; EUR 65,000 - 90,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation days

Paid sick time

Health & dental benefits starting day

Profit sharing

Parental leave

Career advisor

Job summary

CI&T is seeking a Senior Data Engineer to build scalable, reliable data solutions and industrialize data pipelines for the expansion into new countries and business segments. You will own data contracts with Optim-core and contribute to data architecture decisions.

The role focuses on developing dbt pipelines, migrating DuckDB workflows to PostgreSQL, and delivering high-quality analytical data to support rule compliance, in a collaborative, growth-oriented environment.

Qualifications

• Strong experience in software engineering with a focus on data engineering.
• Proficiency in Python and SQL.
• Hands-on experience with dbt and building and maintaining data transformation pipelines.
• Experience with DuckDB and PostgreSQL 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 enable scalability and maintainability.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills 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

Data engineering

Analytical skills

Communication

Tools

dbt

DuckDB

PostgreSQL

Azure

Job description

CI&T is seeking a Senior Data Engineer to build scalable, reliable data solutions and industrialize data pipelines for the expansion into new countries and business segments. You will own data contracts with Optim-core and contribute to data architecture decisions.

The role focuses on developing dbt pipelines, migrating DuckDB workflows to PostgreSQL, and delivering high-quality analytical data to support rule compliance, in a collaborative, growth-oriented environment.