Senior Data Engineer - Scalable Pipelines & Data Contracts

Openkrill; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation

Paid sick time

Health & dental benefits day one

Profit-sharing distribution

Parental leave

Career advisor

Job summary

CI&T is seeking a Senior Data Engineer to build scalable, reliable data solutions. You will industrialize dbt pipelines, migrate from DuckDB to PostgreSQL, and implement robust data contracts to support rule compliance.

You will own data transformation workflows with Python and SQL, collaborate across teams, and help expand our data platform to new countries and business segments while adhering to engineering best practices. Experience with Azure cloud is a plus.

Qualifications

• Strong experience in software/data engineering or data-intensive applications.
• Proficiency in Python and SQL.
• Hands-on experience with dbt and building and maintaining data transformation pipelines.
• Experience with DuckDB and PostgreSQL, including data migration.
• 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.

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

Versioning

Data contracts

Communication

Collaboration

Tools

DuckDB

PostgreSQL

Azure

Job description

CI&T is seeking a Senior Data Engineer to build scalable, reliable data solutions. You will industrialize dbt pipelines, migrate from DuckDB to PostgreSQL, and implement robust data contracts to support rule compliance.

You will own data transformation workflows with Python and SQL, collaborate across teams, and help expand our data platform to new countries and business segments while adhering to engineering best practices. Experience with Azure cloud is a plus.