Data Engineer II

Summary

Join Rightway as a full-time Data Engineer II and contribute to the development and maintenance of mission-critical data infrastructure. You will process large healthcare datasets to generate insights that improve the health of over 1 million members. This role involves writing production-level Python and SQL code, utilizing AWS services, and building data pipelines. You will also design database schemas and maintain ELT processes. The ideal candidate has 2+ years of experience, expertise with the AWS ecosystem, and proficiency in Python and SQL. Rightway offers a competitive salary and a collaborative work environment.

Requirements

• 2+ years of related experience
• Expertise with the AWS ecosystem in a production environment
• Proficiency writing production-ready Python and SQL code
• In-depth experience with data environments including ETL
• Experience scaling data infrastructure to handle high volumes of data

Responsibilities

• Write production-level Python and SQL code
• Use AWS services such as Lambda, Glue, Fargate, and ECS
• Use Apache Airflow to build batch data pipelines
• Use DBT to maintain Extract, Load, and Transform (ELT) processes
• Design database schemas in PostgreSQL, and Amazon Redshift to optimize data integrity and performance

Preferred Qualifications

• Experience with medical and pharmacy claims data
• Experience deploying applications using serverless architecture
• Experience managing AWS services such as Lambda, Glue, and Fargate
• Use infrastructure-as-code services such as Terraform or Cloudformation

Benefits

$110,000 - $135,000