Senior AWS Data Engineer: Pipelines & Analytics

Brillio; Región Centro; On-site; MXN 900,000 - 1,300,000; Full time

Job summary

Brillio is hiring a Senior Data Engineer in Mexico to design and optimize scalable data pipelines using AWS services, including Glue, Lambda, and Redshift. You will build robust data models, write complex SQL, and develop Python-driven ingestion workflows for analytics at scale.

The role emphasizes real-time and batch processing with S3, EventBridge, and Aurora, plus performance tuning of data warehouses. 2–4 years of hands-on AWS data engineering experience is preferred.

Qualifications

• 2–4 years of hands-on AWS data engineering experience.

Responsibilities

• Design, develop, and optimize scalable data pipelines and ETL workflows using AWS services (Glue, Lambda, Step Functions, Redshift).
• Implement and maintain robust database architectures with data modeling and query optimization.
• Write, review, and optimize complex SQL queries for data extraction and loading across AWS stores.
• Develop Python-based data ingestion, transformation, and automation workflows.
• Monitor, troubleshoot, and ensure high availability of cloud-based data pipelines.
• Collaborate with application support teams to resolve Hypercare tickets and provide data guidance.
• Integrate S3, EventBridge, and Aurora for real-time and batch processing.
• Improve data processing performance through warehousing best practices.

Skills

Athena

SNS

SQS

CloudWatch

Macie

Spark

Scala

Kinesis

CloudFormation

EMR

Open Search

DynamoDB

Amazon API Gateway

SCT

Redshift

DMS

Oozie

Education

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline

Tools

AWS Glue

AWS Lambda

AWS Step Functions

Amazon EventBridge

Amazon S3

Amazon Redshift

Amazon Aurora

Database design and data modeling

Complex SQL query development

Python programming for data engineering and ETL automation

AWS CloudWatch

Data warehousing concepts and performance tuning

AWS Athena

AWS EMR

AWS OpenSearch

CloudFormation

Amazon SNS

Amazon SQS

AWS Macie

Spark

Scala

Amazon DynamoDB

Amazon Kinesis

Job description

Brillio is hiring a Senior Data Engineer in Mexico to design and optimize scalable data pipelines using AWS services, including Glue, Lambda, and Redshift. You will build robust data models, write complex SQL, and develop Python-driven ingestion workflows for analytics at scale.

The role emphasizes real-time and batch processing with S3, EventBridge, and Aurora, plus performance tuning of data warehouses. 2–4 years of hands-on AWS data engineering experience is preferred.