[Job-26879] MidLevel Data Engineer, Colombia

AI overview

Contribute to a key data modernization initiative by migrating core systems from Amazon Redshift to Snowflake while building and optimizing data pipelines.
We are tech transformation specialists, uniting human expertise with AI to create scalable tech solutions. With over 8,000 CI&Ters around the world, we’ve built partnerships with more than 1,000 clients during our 30 years of history. Artificial Intelligence is our reality.  Mission: We are hiring mid-level Data Engineers to support a data modernization initiative migrating core systems from Amazon Redshift to Snowflake. This role is hands-on and delivery-focused, working under a Principal Data Architect and alongside a Data Product Manager. This is not a senior or architecture role. The focus is on implementing ingestion pipelines, transformations, and data models following established standards. Responsibilities Data Pipeline Development Build and maintain data ingestion pipelines from APIs and SFTP sources Implement ELT transformations using SQL and dbt (or similar) Support incremental loads, historical backfills, and schema changes Monitor and troubleshoot pipeline failures Snowflake Implementation Create and maintain Snowflake tables, views, and tasks Optimize queries and warehouse usage for performance and cost Follow defined modeling, naming, and governance standards Collaboration Work closely with the Data Architect to implement target designs Collaborate with the Data Product Manager on data requirements Participate in agile ceremonies (standups, planning, reviews) Document pipelines and data assumptions clearly Required Qualifications Technical Skills 3–6 years of experience as a Data Engineer Strong SQL skills (analytical queries, joins, performance tuning) Hands-on experience with cloud data warehouses (Snowflake preferred; Redshift, BigQuery, or similar acceptable) Experience building pipelines using APIs and/or SFTP Experience with ELT frameworks (dbt preferred) Cloud & Data Foundations Experience working in AWS environments (S3, IAM basics) Understanding of data modeling concepts (staging, facts, dimensions) Exposure to orchestration tools (Airflow or similar) Communication Advanced English (spoken and written) Comfortable collaborating with US-based stakeholders Ability to raise risks and blockers proactively Nice to Have Snowflake certifications Financial services or regulated industry experience Python for data processing or automation Experience supporting production data platforms If you like it, just apply and good luck! #LI-JM2
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.

Perks & Benefits Extracted with AI

  • Health Insurance: Premium Healthcare
  • Other Benefit: Colombian Holidays
  • Paid Parental Leave: Maternity and Parental leaves
  • Paid Time Off: Paid Vacations

CI&T is the digital technology agency empowering agile growth for the world's biggest companies by leveraging advanced technologies including Cloud, IoT, Big Data, Machine Learning/AI, Social, Mobility. For over 20 years, CI&T has been a trusted partne...

View all jobs
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Engineer Q&A's
Report this job
Apply for this job