Senior Data Engineer (AWS/BI/SQL)

Overview

We are seeking a Senior Data Engineer who thrives on building high-quality, resilient data solutions at scale. In this role, you will design and deliver serverless data pipelines and event-driven microservices on AWS, optimize complex SQL workloads in Redshift, and contribute to analytics and quality engineering automation. This position is ideal for an engineer who enjoys hands-on work across data engineering, analytics enablement, and automated testing within a modern AWS stack.

Responsibilities

• Collaborate with product, architecture, and engineering teams to design, build, test, deploy, and support data-intensive services and features.
• Build and maintain production-grade, event-driven microservices using Node.js and Python.
• Design and operate serverless ETL pipelines and automate data ingestion and transformation into Redshift.
• Optimize complex SQL for performance and reliability, including joins, window functions, and large-scale aggregations.
• Integrate Redshift Serverless with AWS services and BI tools for real-time analytics and dashboards.
• Implement unit testing, code reviews, and quality engineering and automation practices.
• Apply AWS security, performance, and cost optimization best practices.
• Document data models, data contracts, and operational runbooks.

What You Bring

• 5+ years of professional experience as a Data Engineer or Software Engineer focused on data platforms and analytics.
• Expert-level SQL skills for extraction, transformation, optimization, and reporting.
• Hands-on experience with Redshift Serverless and related AWS services.
• Proficiency with core AWS services used in data and event-driven architectures.
• Production experience with Python and Node.js.
• Working knowledge of AI or ML technologies in a data engineering context.

Engagement Details

This is a full-time, remote position with Codex Studios, offering the opportunity to work with a cutting-edge technology stack and a vibrant, collaborative team.