jobapplier

[Job-32044] Senior Data Developer, Colombia

CI&T

Responsibilities

  • Database Development: Design, build and tune schemas, stored procedures, views, functions and indexes. Lead query-plan analysis and performance work.
  • Lakehouse Engineering: Build and maintain Databricks pipelines (PySpark / Spark SQL) and dbt models using Kimball dimensional modeling.
  • Dual-Layer Delivery: Support both the transactional SQL databases used by applications and the lakehouse models used for analytics.
  • Data Governance & Quality: Manage data access and lineage in Unity Catalog. Implement quality checks and source-to-target reconciliation, and protect sensitive personal data (masking, row-level access).
  • Engineering Practices: Version database changes in Git, deploy through CI/CD, and review peers' SQL.
  • Knowledge Transfer & Operations: Take over existing schemas and jobs from previous teams without disrupting production. Document data models and runbooks, and support incident resolution and root-cause analysis.
  • Collaboration: Work with the Data Architect on modeling standards, and with application developers on API and data contracts.
  • Mentorship: Mentor mid-level developers and explain technical trade-offs to client architects.

Requirements

Advanced/fluent English (C1 or above)

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

Preferred

  • Unity Catalog administration

Databricks certification (Data Engineer Associate / Professional)

  • Experience with orchestration and ingestion tools (Databricks Workflows, Airflow, ADF, Fivetran)
  • Experience with data quality frameworks (Great Expectations, dbt tests)
  • Exposure to BI tools (Power BI or Tableau)
  • Experience with regulated data (education, healthcare or privacy regulations such as LGPD)
  • Familiarity with AI-assisted development and agentic coding

Responsibilities

Nearshore Delivery: Work with North American stakeholders and teams in Brazil and Colombia, keeping strong overlap with US business hours.

Nice to have

#LI-TO1

Our benefits include

  • Premium Healthcare
  • Meal voucher
  • Maternity and Parental leaves
  • Mobile services subsidy
  • Sick pay-Life insurance
  • CI&T University
  • Colombian Holidays

Paid Vacations

  • And many others.
  • Collaboration is our superpower, diversity unites us, and excellence is our standard.
  • We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.