Senior Data Engineer (AWS/BI/SQL)
Posted 1 day ago by Codex Studios, LLC
Negotiable
Undetermined
Remote
Remote
Summary: We are looking for a Senior Data Engineer to create high-quality data solutions using AWS technologies. The role involves designing serverless data pipelines, optimizing SQL workloads in Redshift, and contributing to analytics and quality engineering automation. Ideal candidates will have hands-on experience in data engineering and a passion for building resilient data systems. This position is fully remote and offers the chance to work with a modern technology stack.
Key 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.
Key Skills:
- 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.
Salary (Rate): £75,000 yearly
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: Senior
Industry: IT
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.