Job Title: AWS Data Engineer - Healthcare/Rx Claims - 254549
Work Location: Remote in the US
Position Type: Full Time Employment - Direct Hire
Position Level: Mid-Level / Team Member, 5-7 years
Compensation Range: $125,00 - $140,000 / year
DAY TO DAY RESPONSIBILITIES - Working in a team environment to design, implement, and support the scalability of cloud-native data solutions-including data lakes and warehouses
- Working within an AWS environment, and with AWS services like Redshift, Aurora, S3, Lambda, and Airflow.
- Building, automating and maintaining robust ETL pipelines using AWS Glue, Lambda, and Step Functions to ingest and process complex healthcare / pharmacy datasets.
- Working in a DataOps environment to optimize the performance of data pipeline
- Maintaining data governance. Enforcing strict data security protocols, access controls, and compliance frameworks to safeguard sensitive healthcare information.
- Monitoring, troubleshooting and fine-tuning data streams and storage architectures to maximize speed, minimize costs, and enhance query efficiency via strategic partitioning and caching.
- Providing application and database support, writing and optimizing clean Python code, advanced SQL queries, and complex stored procedures to support internal data applications.
- Partnering closely with product and analytics teams to translate business requirements into highly functional, scalable data models.
REQUIRED QUALIFICATIONS, EXPERIENCE AND SKILLS - 8-10+ years professional experience as a Data Engineer
- Deep expertise in AWS cloud-native ecosystems, specifically utilizing Glue, Lambda, Step Functions, Redshift, Aurora, and RDS PostgreSQL.
- Certification as an AWS Certified Data Engineer
- Expert-level proficiency in Python and SQL, including views, triggers, stored procedures, and database optimization
- Direct, hands-on experience working with Healthcare Claims, Pharmacy / Rx Claims is highly preferred, and will be given preference
- Must be permanently authorized to work in the US (Visa sponsorship not offered)
- Exceptional communication skills with the ability to build trust across business units and consistently deliver precise, accurate work in a fast-paced environment.
