Data Engineer

Location/Remote: 100% remote within the United States; must be willing to work Mountain Time Zone hours

Employment Type: Permanent / Direct Hire / Full-time

Compensation: up to $120k base salary (depending on experience) + 15% annual bonus

Benefits:

• 100% medical premiums covered for employees
• Coverage for dependents on medical, dental, vision, life, and supplemental insurances (e.g., critical illness)
• Short- and Long-Term Disability (STD/LTD)
• HSA & FSA options
• Unlimited PTO
• Up to 12 weeks paid parental leave
• 401(k) with 5% company match

Position Overview

We are looking for a Data Engineer with strong expertise in building ETL pipelines using AWS Glue and other native AWS services. This role is ideal for someone passionate about automating and optimizing data workflows, with deep experience in Python, SQL, and cloud-first data architecture. You will be responsible for developing and maintaining scalable data pipelines that support business-critical analytics and operational use cases.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using AWS Glue for batch processing of structured and semi-structured data.
• Build event-driven workflows using AWS Lambda, Step Functions, and CloudWatch Events.
• Leverage Amazon S3 for data lake storage and ingestion, implementing optimized partitioning and lifecycle policies.
• Use Amazon Redshift and Athena for querying and transforming large datasets.
• Manage access and infrastructure securely using IAM roles and policies.
• Monitor data workflows and job health using CloudWatch, CloudTrail, and custom alarms.
• Develop reusable Python modules to automate and streamline data processing tasks.
• Perform schema design, table creation, and stored procedure development in Redshift and PostgreSQL.
• Support data migrations and schema changes across Redshift clusters and other database systems.
• Collaborate closely with analytics and product teams to deliver high-quality, reliable data solutions.

Required Skills & Experience

• 5+ years of experience developing with Python for ETL workflows, automation, and scripting
• 5+ years of experience working with SQL, including query optimization, stored procedure development, and data modeling
• 4+ years of hands-on experience working with AWS services including AWS Glue, Lambda, Step Functions, S3, Redshift, Athena, CloudWatch, and IAM
• Strong understanding of building, maintaining, and optimizing data pipelines end-to-end
• Experience working with semi-structured data (e.g., JSON, XML) and transforming it into structured formats
• Comfortable working in fast-paced environments, owning pipelines from design to deployment
• Proficient with version control tools such as Git, SVN, or similar
• Excellent communication and collaboration skills, with a strong focus on data quality and reliability

Preferred Qualifications

• Experience with healthcare data (HL7, Medical Claims, Rx Claims) or similar healthcare data is preferred.
• Experience with Apache Airflow or Amazon MWAA
• Familiarity with building custom data ingestion tools using Pandas or similar Python libraries
• Exposure to telemetry data or real-time event pipelines
• Experience in gaming, media, or other high-volume data environments

Education & Certifications

• Bachelor s degree in Computer Science, Engineering, Data Science, or a related technical field (or equivalent hands-on experience)
• Relevant industry certifications in AWS, data engineering, or cloud technologies are a plus