Data Engineer II – Team Lead 100% remote work * **Responsibilities:** Responsible for coordinating a team of development engineers focused on data engineering, automation, and handling large volumes of data. Development and implementation of best practices in complex ETL or distributed processing projects. * **Skills:** ESSENTIAL TECHNICAL SKILLS AND KNOWLEDGE: **Advanced SQL: for data modeling, validation, query optimization, and generation of consumption tables.** PostgreSQL / MySQL: intermediate-level proficiency in connection setup, complex queries, and basic administration. **Python (ETL and automation): Intermediate experience developing scripts for data transformation.** Linux / CLI: basic–intermediate level—script execution, server navigation, and process monitoring. **AWS (basic–intermediate: S3, Redshift, RDS): managing file storage, executing bulk loads, and performing basic cloud database administration.** Git: version control for scripts and collaboration in technical workflows. **Relational data modeling: structuring data to facilitate querying, maintenance, and analysis.** Docker: for standardizing and deploying reproducible environments. DESIRABLE (BUT NOT MANDATORY) TECHNICAL SKILLS: **AWS IAM / CloudWatch: basic access management and monitoring of automated processes.** Advanced web scraping (Selenium, requests): automating information extraction from websites. **Power BI: understanding the data flow into reports or dashboards.** Fargate, Athena, AWS Glue: familiarity with modern large-scale data storage and processing solutions. **Airflow: designing, executing, and monitoring automated data pipelines.** Parquet, CSV, JSON: knowledge of working with various data interchange formats. SOFT SKILLS: **Problem-solving: ability to identify bottlenecks and act swiftly.** Effective communication: clarity when explaining technical processes to non-technical stakeholders. **Accountability and follow-up: completing tasks without requiring constant supervision.** Organization: efficiently managing multiple concurrent workflows. **Results-oriented mindset: beyond fixed working hours, delivering complete and functional solutions is highly valued.** Clear documentation: ability to produce useful technical records for other team members. **Mentorship: willingness to support junior or trainee colleagues.** Strategic thinking: proactively proposing improvements. **Change management: ability to adapt to and drive new practices within existing processes. * Experience: Early leadership opportunity – chance to lead a team Minimum 2 years of hands-on experience in data engineering, automation, and handling large volumes of data. **Experience in complex ETL or distributed processing projects is desirable.** Bachelor’s degree in Systems Engineering, Computer Science, Information Technology, or related fields. * **Work Schedule: Monday to Friday** * **Working Hours: 9:00 AM – 6:00 PM, Monday to Friday; occasional Saturdays** * **Education:** * **Employment Type:** Full-time remote work * **Compensation:** Salaries and wages * **Salary Range:** Negotiable * **Benefits:** Statutory benefits * **Relocation Required:** No * **Willingness to Travel:** Yes * **Personal Vehicle Required:** No * **City:** Puebla * **State:** PUEBLA * **Country:** Mexico * **Other Languages:** Spanish, English * **Commercial Systems:** Office and Power BI * **Advanced Systems:** **Advanced SQL,** PostgreSQL / MySQL **Python (ETL and automation),** Linux / CLI **AWS (S3, Redshift, RDS),** Git **Relational data modeling,** Docker **AWS IAM / CloudWatch,** Advanced web scraping (Selenium, requests) **Power BI: understanding the data flow into reports or dashboards,** Fargate, Athena, AWS Glue **Airflow,** Parquet, CSV, JSON Job Type: Full-time Salary: $30,000.00 – $40,000.00 per month Application Questions: * 1 How many years of experience do you have in data engineering, automation, and handling large volumes of data? * 2 Do you have experience leading data engineering teams? * 3 Please describe a data engineering best practice you applied in a real project and how it impacted your team’s work. * 4 Among the following technologies (advanced SQL, Python for ETL, Linux CLI, AWS S3/Redshift/RDS, Docker, Airflow, Power BI), which have you used practically in real-world projects? For each selected technology, briefly describe an example of what you did (e.g., query optimization, pipeline development, containerized deployment, etc.). * 5 What was your most recent salary? Do you have professional references? Work Location: Remote position