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:
-Health and dental insurance
-Meal and food allowance
-Childcare assistance
-Extended paternity leave
-Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass;
-Profit Sharing and Results Participation (PLR);
-Life insurance
-Continuous learning platform (CI&T University);
-Discount club
-Free online platform dedicated to physical, mental, and overall well-being
-Pregnancy and responsible parenting course
-Partnerships with online learning platforms
-Language learning platform
And many more!
At CI&T, inclusion starts at the first contact. If you are a person with a disability, it is important to present your assessment during the selection process. See which data needs to be included in the report by clicking here.This way, we can ensure the support and accommodations that you deserve. If you do not yet have the assessment, don't worry: we can support you in obtaining it.
We have a dedicated Health and Well-being team, inclusion specialists, and affinity groups who will be with you at every stage. Count on us to make this journey side by side.
