Snowflake Data Engineer (Ingeniero de Datos Snowflake)

Snowflake Data Engineer (Ingeniero de Datos Snowflake)Location: Mexico (Mexico City, Guadalajara, Monterrey) – Hybrid as per Infosys Mexico policy (CST/EST time)Role OverviewAs a Snowflake Data Engineer, you will be designing and optimizing data pipelines and architectures within the Snowflake cloud platform. The role requires strong SQL skills, expertise in Snowflake features such as Virtual Warehouses, Streams, and Tasks, and experience with ETL/ELT processes for efficient data ingestion and transformation. Key capabilities include data modeling, performance tuning, integration with various data sources and BI tools, and ensuring security and governance compliance.Key ResponsibilitiesDesign, build, and optimize data pipelines and ETL/ELT processes using Snowflake.Develop and maintain DBT models (views, tables, incremental models) including tests for data quality.Perform data ingestion from AWS S3 using Snowpipe, COPY command, external/internal stages. Implement performance tuning, query optimization, and Snowflake feature usage (Materialized Views, Secure Views, Streams, Tasks, Time Travel, Zero-Copy Cloning).Manage version control, branching, and CI-related workflows using GitHub. Work with AWS services such as S3, Lambda, IAM, EC2 for data movement and transformation. Collaborate with cross-functional stakeholders (data analysts, data scientists, product teams) to deliver high-quality data solutions. Troubleshoot pipeline, ingestion, and DBT job issues to ensure reliability and SLA adherence.Basic QualificationsBachelor’s degree or foreign equivalent in Computer Science or related field.7+ years of IT experience, including data engineering and cloud solutions.Bilingual (Spanish & English) – strong verbal and written communication.Proven experience implementing AWS services such as S3, Lambda, IAM, EC2 for data movement and transformations.Mandatory SkillsSnowflakeDBT - Developing DBT modelsBuilding scalable data pipelinesEnabling high quality transformationsIntegrating data across AWS based architecturesPreferred SkillsFamiliarity with CI/CD using GitHub.Strong problem-solving, leadership, and stakeholder management skills.Other RequirementsAbility to work under tight timelines and manage complex requirements.Flexible to work during CST/EST time zones and meet for hand-over activities to India team if needed.Self-motivated, proactive, and a strong team player. EEO Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.