Location: Mexico (Remote)
Engagement: FullTime Contractual
We’re seeking a highly skilled Data Engineer with handson experience in SQL, ETL tools (especially Talend), and data pipeline development. This role requires someone who can not only write performant queries and build robust data pipelines but also understand and implement modern data warehousing practices.
Design and implement efficient data ingestion and ETL pipelines using Talend or similar tools
Write and optimize advanced SQL queries, including window functions and Common Table Expressions (CTEs)
Clean, structure, and transform large datasets from multiple sources
Collaborate with stakeholders to align data processes with business goals
Monitor and enhance data quality, integrity, and reliability
Support predictiveprescriptive modeling initiatives by preparing analytical datasets
Document processes and solutions clearly for crossfunctional use
4+ years of professional experience as a Data Engineer
Strong SQL expertise including:
Complex joins, subqueries
Window functions (ROW_NUMBER, RANK, LAGLEAD)
CTEs and performance tuning
Handson experience with Talend, Informatica, SSIS, or similar ETL platforms
Solid understanding of dimensional modeling, data warehousing concepts (SCDs, factdimension tables)
Experience handling largescale relational andor cloudbased databases
Familiarity with data pipeline design and error handling
Proficient in English (written and spoken)
Experience using Python for data transformation tasks
Knowledge of cloud data services (AWS, GCP, or Azure)
Familiarity with realtime data streaming tools or frameworks
Clio - Cloud-Based Legal Technology
VIPRE Security Group
Growth Acceleration Partners
MTP Brasil
Zoom