CI&T

Midlevel Data Engineer

CI&T

full-time

Posted on:

Location Type: Remote

Location: Colombia

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowAmazon RedshiftAWSBigQueryCloudSQL

About the role

  • Support a data modernization initiative migrating core systems from Amazon Redshift to Snowflake
  • 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
  • Create and maintain Snowflake tables, views, and tasks
  • Optimize queries and warehouse usage for performance and cost
  • Follow defined modeling, naming, and governance standards
  • 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

Requirements

  • 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)
  • Experience working in AWS environments (S3, IAM basics)
  • Understanding of data modeling concepts (staging, facts, dimensions)
  • Exposure to orchestration tools (Airflow or similar)
  • Advanced English (spoken and written)
  • Comfortable collaborating with US-based stakeholders
  • Ability to raise risks and blockers proactively
Benefits
  • Premium Healthcare
  • Meal voucher
  • Maternity and Parental leaves
  • Mobile services subsidy
  • Sick pay-Life insurance
  • CI&T University
  • Colombian Holidays
  • Paid Vacations

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLdbtdata ingestionELT transformationsdata modelingperformance tuningpipeline buildingcloud data warehousesdata governanceorchestration tools
Soft skills
collaborationcommunicationproactive risk managementdocumentationagile methodology