What's your preference?
Job Description
- Req#: b1c89882-eb01-41d1-8827-acbc118c1211
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
\n
\nOur 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.
About the company
CI&T is an information technology and software engineering company.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.