Senior AWS Data Engineer
Posted Updated
Description
Casado in Brazil is seeking a Senior AWS Data Engineer to build and productionize data transformation layers for large-scale GA4 clickstream data. You will convert raw data from an S3 Bronze layer into Silver and Gold layers in Amazon Redshift, enabling analytics, BI, and AI use cases.
This hands-on role focuses on production delivery, building reliable data pipelines, shaping analytics-ready data models, implementing data access controls with Lake Formation, and optimizing Redshift workloads
Build and maintain production-grade data transformation pipelines using AWS Glue, Python, Matillion, or similar tools. Transform GA4/GA360 data into denormalized Silver/Gold tables for BI and AI use cases. Design and implement wide, denormalized domain-aligned Silver tables for BI workloads. Create Gold-layer aggregates to support reporting and AI/RAG workloads. Implement column-level security using AWS Lake Formation and manage access models for BI/AI/Data Science. Develop Redshift late-binding views for Tableau/Power BI consumption. Optimize Redshift workloads through proper distribution and sort keys, WLM, and performance tuning. 5+ years of Data Engineering experience with hands-on AWS production workloads. Strong SQL and Python skills, with production-grade data transformations. Experience with S3-based data lakes, Glue jobs, and data cataloging. Expertise in Redshift performance optimization (distribution and sort keys). Ability to design analytics-ready data models for BI and AI use cases.Skills
Sign in to read and join the discussion.