Data Engineer

Role Overview

• Design and administer data systems: Implement cloud-native data solutions across cloud services such as AWS Glue, AWS Lambda, AWS Step Functions, Redshift, Aurora, Amazon S3, MWAA-Airflow.
• Design and implement scalable data architectures using AWS cloud services, including data lakes, data warehouses, bulk data ingestion, and transaction processing.
• Collaborate with customers and teammates to comprehend data requirements and translate business needs into well-designed data models.
• Assemble large, complex data sets that meet functional business requirements.
• Stay current with AWS services and recommend suitable tools for specific data engineering tasks.
• Develop and support the internal applications using Python, SQL, and Stored Procedures.
• Build reliable data processes: Develop, implement, and maintain ETL processes to ingest, clean, and transform complex health care data into our application data platforms.
• Automate manual processes and to optimize data delivery and reduce operational friction.
• Optimize data pipeline performance: Monitor and tune data pipelines and data storage for performance, cost, and reliability.
• Implement caching mechanisms and data partitioning strategies to enhance query efficiency and reduce data processing times.
• Lead and collaborate company-wide: Provide technical guidance and mentorship within the data engineering team and foster a collaborative and innovative environment.
• Partner closely with product and analytics team to understand business goals and engineer solutions to the right problems.
• Protect and govern data responsibly: Implement and enforce data security measures and maintain data governance standards and access controls to protect sensitive data.
• Ensure compliance with health care data regulations and industry best practices.

Requirements

• Bachelor’s degree in computer science, Informatics, Information Systems, or another quantitative field.
• 10+ years of experience in data engineering or a similar role with demonstrated technical leadership experience.
• Expertise building and administering, including writing views, stored procedures, and triggers, in AWS-native data systems (Redshift, Aurora, RDS PostgreSQL, Glue, Lambda, Step Functions, MWAA-Airflow).
• Strong Python and SQL experience, including advanced query design and database optimization.
• Experience with healthcare data (Medical Claims, Rx Claims) or similar healthcare data is required.
• Ability to develop subject-matter expertise and partner thoughtfully with business teams.
• Trusted partner: reliable to deliver accurate work in a timely manner.
• A passion for working with a team to improve how data drives meaningful outcomes.

Tech Stack

• Airflow
• Amazon Redshift
• AWS
• Cloud
• ETL
• Postgres
• Python
• SQL

Benefits

• Great Health Insurance
• 401K Match
• Time Off
• Parental Leave