Role Description We at Coforge are hiring Position (21826) for an experienced Tech Lead – Data Engineering with 8–10 years of overall experience to lead the design and development of modern data pipelines and platforms. In this role, you will architect and oversee ETL/ELT pipelines using Matillion, Snowflake, AWS, Python, and SQL, ensuring scalable and high-performance data solutions. You will combine hands-on technical work with leadership responsibilities, guiding a team of engineers and collaborating across functions. Bilingual fluency in English and Spanish is required. Responsibilities - Design & Develop Data Pipelines: Lead the end-to-end design, development, and optimization of ETL/ELT pipelines and data integration workflows using Matillion and Snowflake on AWS, ensuring data is clean, reliable, and readily accessible for analytics. - Technical Leadership: Own architectural decisions for the data platform and warehouse. Provide hands-on coding as well as mentorship, code reviews, and technical guidance to the data engineering team to uphold best practices and high coding standards. - Data Warehouse Architecture: Oversee the architecture of a modern cloud Data Warehouse solution. Implement data modeling and schema design that supports large-scale, scalable analytics and adheres to performance and security standards. - Cross-Functional Collaboration: Work closely with cross-functional teams (e.g., Data Science, Analytics, Product, DevOps) to translate business requirements into technical solutions. Ensure the data engineering strategy aligns with broader organizational goals. - AI/ML Integration: Collaborate with data science and AI teams to integrate machine learning and AI use cases into the data platform. Ensure that data pipelines and platforms can support AI/ML-driven applications (e.g., providing prepared datasets, enabling model training and inference), even though this role is not focused on model development. - Quality & Performance Assurance: Establish data quality checks, monitoring, and alerting within pipelines. Optimize ETL processes for efficiency (tuning SQL queries, managing resource usage) and ensure high availability and reliability of data workflows. Qualifications - Data Pipeline & ETL Tools: Expert hands-on skills in building ETL/ELT pipelines with Matillion (or similar ETL orchestrators) and deep proficiency in Snowflake data warehousing. - Programming & Database: Strong programming ability in Python and advanced SQL expertise for data transformation, analysis, and performance tuning. Solid understanding of relational and non-relational data stores; able to design efficient database schemas. - Cloud & Modern Data Stack: Extensive experience with AWS (and related data services) for developing and deploying data infrastructure. Familiarity with modern Data Warehouse architectures and tools in a cloud environment (e.g., data lakes, columnar storage, etc.). - Technical Leadership & Collaboration: Proven ability to lead engineering teams – excellent skills in technical mentoring, code review, and project leadership. Strong communication skills for collaborating with diverse stakeholders and driving cross-team initiatives. - AI/ML Concepts: Working knowledge of AI/ML concepts as they apply to data engineering (e.g., data preparation for machine learning, enabling ML model pipelines). Able to engage with data scientists to ensure the data platform effectively supports analytics and AI use cases. Requirements - Experience: 8-10 years - Location: Hermosillo, Mexico - Mode: Remote Company Description At Coforge, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.