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.