About the Role
We are seeking a full-time Data Engineer III to define and deploy mission-critical data infrastructure. This role focuses on processing large healthcare datasets to generate insights that improve member health, leveraging deep expertise in SQL and Python within the AWS ecosystem. AI tooling will be used to augment workflows and improve platform reliability and efficiency.
Responsibilities
- 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
- 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.
Skills
- SQL
- Python
- AWS
- Apache Airflow
- DBT
- PostgreSQL
- Amazon Redshift
- AI tooling
- Serverless architecture
- Master Data Management
- Data governance
- Terraform
- CloudFormation
Location
- New York City
- Denver
- Dallas
Work Type
- Full-time
Experience Level
- 5+ years of industry experience as a data engineer
Education Level
- Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent work experience.
Salary/Compensations
- $125,000 - $150,000 annually
Benefits
- Bonus
- Equity
About the Company
- Rightway is on a mission to harmonize healthcare for everyone, everywhere. Our products guide patients to the best care and medications by inserting clinicians and pharmacists into a patient’s care journey through a modern, mobile app. Rightway is a front door to healthcare, giving patients the tools they need along with on-demand access to Rightway health guides, human experts that answer their questions and manage the frustrating parts of healthcare for them.
- Since its founding in 2017, Rightway has raised over $200mm from investors including Khosla Ventures, Thrive Capital, and Tiger Global.
- We’re headquartered in New York City, with satellite offices in Denver and Dallas.
- Our clients rely on us to transform the healthcare experience, improve outcomes for their teams, and decrease their healthcare costs.
Equal Opportunity
- Rightway is proud to be an Equal Opportunity Employer that believes in the strength of diverse thought, beliefs, backgrounds, and education. We foster an inclusive culture where differences are celebrated to drive the best business decisions possible. We do not discriminate on any basis protected by applicable law. All employment decisions are based on merit, qualifications, need, and performance.
