Senior Data Engineer

As a Senior Data Engineer, you bring a strong passion for software engineering excellence and a drive to turn that passion into consistent, high-quality product development. You’re customer-obsessed, analytically sharp, and thrive working with native AWS services to solve challenging business problems.

You’ll partner closely with Product Owners, Architects, Developers, and fellow Engineers to design, define, and implement product features, conduct system-level validation, and verify functionality throughout the development lifecycle. This role sits at the intersection of data engineering, analytics, and quality engineering - you’ll build robust data pipelines while also contributing to testing and automation practices that keep the platform resilient and performant.

This role has a strong emphasis on Amazon Redshift - including Redshift Serverless, complex SQL development, and integrating Redshift with the broader AWS data ecosystem.

What You’ll Do

Design & Implementation (~70%)

• Build and maintain data pipelines and microservices using AWS services including Redshift, Lambda, S3, SQS, SNS, DynamoDB, QuickSight, and OpenSearch
• Write and optimize complex SQL for data extraction, transformation, and reporting
• Create and maintain automated functional and system tests that replicate real-world scenarios
• Develop code and test automation to support security features and technical scoping, ensuring high-quality, reliable feature delivery
• Support continuous integration practices and help the team continuously raise the bar on code quality
• Coordinate with other engineers, architects, UX, and infrastructure teams as needed

Strategy & Communication (~20%)

• Help implement cloud-first architectural solutions and best practices
• Participate in agile ceremonies - sprint planning, backlog grooming, daily standups, and sprint demos
• Participate in peer reviews of software engineering artifacts

Team Coordination (~10%)

• Mentor team members by developing training materials on current and future product architecture
• Provide constructive feedback on code and design artifacts to technical staff

• Ideally 6+ years of software development experience in a production environment
• Expertise writing and optimizing complex SQL queries (SELECT, JOIN, GROUP BY, HAVING, window functions, etc.)
• Expertise integrating Redshift/Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB, and Kinesis, along with BI tools like Tableau, QuickSight, or Looker for real-time analytics and dashboards
• Expertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into Redshift
• Required: Python. Nice to have: React and Node.js
• Experience building event-driven, serverless cloud applications on AWS
• Solid technical grounding in cloud computing, DevOps, and microservices architecture
• Excellent communication skills, with the ability to translate technical concepts into business-friendly language
• Proven ability to build strong working relationships with stakeholders and customers
• Strong analytical, conceptual, and problem-solving skills
• Ability to prioritize and execute effectively in a fast-paced, high-pressure environment

Core Technology Focus

Redshift/SQL, AWS Lambda, AWS S3, AWS SNS/SQS, AWS Step Functions, AWS DynamoDB, AWS CloudFormation, Python, Node.js, and applied Generative AI. This is a long-term remote contract opportunity with recurring engagement renewals. Interested candidates should apply with an updated resume highlighting relevant AWS and Redshift experience.