Senior Data Engineer: Lakehouse, Governance & Analytics

CI&T; United States; Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health and dental insurance

Meal and food allowance

Childcare assistance

Extended paternity leave

Wellness partnerships (Gympass/Total—)

Profit Sharing and Results Particip

Life insurance

CI&T University

Language learning platform

Job summary

CI&T is seeking a Senior Data Developer to own the relational and lakehouse data behind a higher-education platform, ensuring data correctness, performance, and governance. You will take ambiguous data problems from analysis to production, making sound modeling trade-offs and maintaining a high quality bar across the team.

Responsibilities include designing schemas, building Databricks pipelines, dbt models, and dual-layer delivery for transactional and analytics workloads, while mentoring

Qualifications

• Fluent English (C1 or above) required.
• Expert SQL skills including stored procedures, window functions, CTEs, indexing and execution plans.
• Strong experience with relational databases (SQL Server / Azure SQL preferred; PostgreSQL or similar).
• Hands-on production experience with Databricks, PySpark, Delta Lake and dbt.
• Solid experience with Kimball dimensional modeling and data warehouse design.
• Experience with Git, CI/CD for database changes and Jira.

Responsibilities

• Design, build and tune schemas, stored procedures, views, functions and indexes.
• Build and maintain Databricks pipelines and dbt models using Kimball dimensional modeling.
• Support transactional databases and lakehouse models for analytics.
• Manage data access, lineage and quality checks; protect sensitive data.
• Version database changes in Git and deploy through CI/CD; review peers’ SQL.
• Document data models and runbooks; support incident resolution and root-cause analysis.
• Collaborate with Data Architect and application developers on data contracts; mentor junior developers.
• Coordinate nearshore delivery with North American stakeholders and teams in Brazil and Colombia.

Skills

Advanced English

SQL

Relational databases

Dimensional modeling

Data warehouse design

Git

CI/CD for database changes

Jira

Tools

Databricks

PySpark

Delta Lake

dbt

Job description

CI&T is seeking a Senior Data Developer to own the relational and lakehouse data behind a higher-education platform, ensuring data correctness, performance, and governance. You will take ambiguous data problems from analysis to production, making sound modeling trade-offs and maintaining a high quality bar across the team.

Responsibilities include designing schemas, building Databricks pipelines, dbt models, and dual-layer delivery for transactional and analytics workloads, while mentoring