[Job-32044] Senior Data Developer, Colombia
Summary
Senior Data Developer at CI&T in Colombia who owns the relational and lakehouse data layer behind a higher-education platform: designing and tuning SQL schemas, building Databricks (PySpark) and dbt pipelines, governing data in Unity Catalog, and mentoring mid-level developers while overlapping US business hours.
At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.
With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.
We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.
This role combines deep hands-on data engineering with technical ownership of a critical data layer. The Senior Data Developer will own the relational and lakehouse data behind a higher-education platform's program, student and enrollment data. That data has to be correct, fast and well governed, so that analytics, CRM and partner-facing applications can trust it. Success depends on taking ambiguous data problems from analysis to production on your own, making sound performance and modeling trade-offs, and keeping a high quality bar across the team.
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.
Nearshore Delivery: Work with North American stakeholders and teams in Brazil and Colombia, keeping strong overlap with US business hours.
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
Nice to have:
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
#LI-TO1
Skills
As published by lever · 19 questions · 1 written answer
Basics
Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL
Short answers (5)
- How comfortable do you feel working in an English-speaking environment?
- Please, confirm country and city where you are currently living
- When will you be available to start working with us? (DD/MM/AAAA)
- If the previous answer is Yes, please share the name(s) of these individuals. optional
- Confirm the name of the company where you work/ Confirme o nome da empresa em que você trabalha atualmente
Pick from a list (13)
- [EN] What is your level of confidence when communicating and collaborating in an English-speaking work environment? optional
- [ES] What is your level of confidence when communicating and collaborating in an Spanish-speaking work environment? optional
- How did you hear about our job opening? optional
- Do you have any relatives (such as parents, siblings, in-laws, spouses, or children, stepchildren, stepfather/stepmother, son-in-law/daughter-in-law), close friends, or acquaintances (with whom you have a significant and ongoing relationship) who currently work at CI&T?
- Are you legally authorized to work in Colombia?
- Do you require any type of accessibility for the selection process and/or in your daily life??
- Will you now or in the future require sponsorship for Colombia's employment visa status?
- Would you like to tell us your gender identity? We ask about gender identity to better understand and support the diverse identities of our employees and to ensure our workplace is inclusive. optional
- Are you part of the LGBTQIAP+ community? optional
- How would you self-declare? Collecting information on ethnic backgrounds allows us to ensure our diversity and inclusion efforts are effective and to address any potential disparities. optional
- To understand better your necessities or any accommodations you need for our process & interviews, we would like to know if you are a person with disabilities? optional
- If applicable, please tell us what type of disability you have: (Edit to include options:) optional
- By selecting the option below, I declare that I have read, understood, and agree to the terms of this document, and I consent to the processing of my personal data by CI&T and Lever for the purposes described herein. Read the document here: https://drive.google.com/file/d/1dMaskYl2VD1AtN9MfiHrZiA-YFYwq8aI/view optional
Written answers (1)
- What is your salary expectation? (please inform the gross amount in Colombian Pesos)