Senior Data Engineer

Job#:
Job Description
Senior Data Engineer (Snowflake, Python, ETL) - Apex Systems Mexico
(Hybrid in Guadalajara Jalisco, 3 days at the office per week)

Who We Are
Apex Systems is a global technology services firm delivering digital, data, and cloud solutions that accelerate business transformation. Through our
Mexico Delivery Center (MDC)
, we design and implement modern data platforms that empower enterprise clients to unlock the full potential of their data.

Position Overview
We are seeking a
Lead Data Engineer
with strong expertise in
Snowflake
,
Python
, and
ETL development
to join our Mexico Delivery Center. This role is responsible for leading the design and delivery of scalable data architectures and pipelines, ensuring quality, performance, and alignment with client business goals. The ideal candidate combines deep technical knowledge with leadership and mentoring capabilities.

Key Responsibilities

• Lead the design, development, and optimization of end-to-end data pipelines using Snowflake and Python.
• Architect and implement ETL/ELT processes for large-scale data ingestion, transformation, and integration.
• Define and enforce data modeling, naming conventions, and coding standards across projects.
• Collaborate with architects, analysts, and business stakeholders to translate requirements into technical designs.
• Drive performance tuning, scalability, and cost optimization in Snowflake environments.
• Develop reusable frameworks, templates, and automation scripts to accelerate delivery.
• Mentor and guide mid-level and junior engineers, fostering technical growth and best practices.
• Partner with DevOps teams to implement CI/CD pipelines, data quality validation, and automated testing.
• Support data governance and compliance efforts, ensuring secure and auditable data operations.

Required Qualifications

• 5+ years of experience in data engineering or data architecture roles.
• Proven expertise with Snowflake (data warehouse architecture, query optimization, role-based security).
• Strong proficiency in Python for data transformation, automation, and integration scripting.
• Deep experience with ETL/ELT tools (Azure Data Factory, Airflow, Informatica, or similar).
• Advanced SQL skills for large-scale analytics and performance tuning.
• Solid understanding of data modeling (star/snowflake schemas) and data warehouse design.
• Experience implementing solutions in cloud platforms (Azure, AWS, or GCP).
• Excellent communication skills and ability to lead technical discussions with global stakeholders.
• English proficiency (B2+ level) for client-facing collaboration.

Preferred Skills

• Familiarity with Databricks, Azure Synapse, or BigQuery.
• Experience with data observability, data lineage, and metadata management tools.
• Exposure to MLOps or AI/ML pipeline orchestration.
• Knowledge of containerization (Docker, Kubernetes) and infrastructure as code (Terraform).
• Certifications such as SnowPro Advanced Architect, AWS Data Analytics, or Azure Data Engineer Associate.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including Great Place to Work and Great Place for Women to Work in Mexico.
PDN-a07e4d56-d145-4c06-88da-4d8593652be1