16 days ago
Mexico City, MexicoMid Level
Responsibilities
- Build and maintain scalable ETL/ELT pipelines for batch, streaming, and high-frequency time-series ingestion.
- Evolve the AWS data lakehouse by optimizing storage, performance, cost, and data consistency.
- Manage orchestration workflows with complex dependencies and error handling.
- Deliver production-ready, analytics-optimized datasets while engaging with end users to understand data consumption.
- Implement data governance, security controls, and audit policies across the AWS ecosystem.
- Build monitoring, alerting, and data quality testing to support platform reliability.
Requirements
- Bachelor’s degree in Computer Science, Computer Engineering, or a closely related discipline.
- At least 3 years of hands-on data engineering experience on AWS with modern data lakehouse architectures.
- English proficiency at B2 level or above.
- Production experience with open table formats, preferably Apache Iceberg, including table design, partitioning, and schema evolution.
- Experience with AWS Glue, Athena, Lambda, and S3.
- Experience designing and maintaining ETL/ELT pipelines for batch and streaming workloads.
- Proficiency in Python, PySpark or Python Shell, and advanced SQL including window functions, CTEs, and execution-plan tuning.
- Experience with analytical data modeling in a lakehouse context, including medallion architectures, incremental loads, deduplication, and historical backfills.
- Infrastructure-as-code experience with Terraform or CloudFormation.
- Preferred experience with Step Functions, Kinesis, Lake Formation, DynamoDB, boto3, pyiceberg, pyarrow, CI/CD for Glue or Lambda, and large-scale time-series or IoT/telemetry data.
- Prior energy-sector experience is not required.
Benefits
- US-based roles offer medical, dental, and vision insurance, a 401(k) with company match, paid time off, company holidays, and annual performance-based bonus eligibility.
- Mexico-based roles offer a 30-day Christmas Bonus (Aguinaldo), major medical expenses and life insurance, paid time off and holidays under local policy, and annual performance bonus eligibility.
- All roles offer professional development and growth opportunities.
- Benefits vary by role and location and are subject to change.
About ON.energy
ON.energy builds and operates battery energy storage and hyperscale power systems for AI data centers, mission-critical facilities, and front-of-the-meter grid assets, combining patented hardware with proprietary controls, analytics, and AI-powered management software. Headquartered in Miami, it develops projects across the Americas and beyond, and recently announced a 5 GW partnership, with about 3 GW under construction across multiple hyperscale data-center campuses.