Data Engineer III

Rightway

Data Engineer III at Rightway defining and deploying mission-critical data infrastructure for healthcare insights. Leveraging AWS and AI tooling for data pipelines and operations.

Posted 7/6/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $125,000 - $150,000 per yearWebsite

Tech Stack

Tools & technologies

AirflowAmazon RedshiftApacheAWSPostgresPythonSQL

About the role

Key responsibilities & impact

Write production-level Python and SQL code, with a strong emphasis on complex SQL for data transformation, pipeline logic, and analytical query optimization.
Leverage AI tools and large language models to augment engineering workflows — from code generation and query optimization to automated testing, documentation, and process improvement.
Utilize AWS services such as Lambda, Glue, and Fargate for scalable data operations.
Build and maintain large-scale data pipelines using Apache Airflow.
Oversee the maintenance of Extract, Load, and Transform (ELT) processes using DBT.
Design optimized database schemas in PostgreSQL and Amazon Redshift to ensure data integrity and high performance.
Identify opportunities to apply AI-driven automation to repetitive or high-volume data engineering tasks, reducing manual effort and improving throughput.

Requirements

What you’ll need

Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent work experience.
5+ years of industry experience as a data engineer.
Expert-level SQL skills, including query optimization, schema design, and working with large-scale datasets in production environments.
Strong Python proficiency with experience writing and maintaining production-grade code.
Skilled in working with AWS systems in a production environment.
Experienced in scaling data infrastructure to handle high volumes of data.
Demonstrated ability to incorporate AI tools (e.g. GitHub Copilot, LLM-assisted development) into an engineering workflow to improve speed and quality.
Experience working with medical and pharmacy claims data (extra credit).

Benefits

Comp & perks

Compensation offered will be determined by geographic location, experience, and qualifications.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonSQLDatabase Schema DesignQuery OptimizationData TransformationData Pipeline DevelopmentELT Processes with DBTPostgreSQLAmazon RedshiftAI-Driven Automation