Remote Lead Data Engineer - Cloud Data Warehouse & ETL

American Red Cross; Charleston (SC); Remote; USD 145,000 - 160,000; Full time

Benefits offered by this job

Medical, Dental Vision plans

401K with up to 6% match

PTO: 19 days/year plus holidays

Job summary

The American Red Cross is hiring a Lead Data Engineer for its Enterprise Data Analytics team. You will modernize data architecture, build scalable data pipelines, and support enterprise data warehouse initiatives across verticals.

The role is fully remote with occasional in-person meetings and East Coast coordination preference. Ideal candidates have 10+ years in data engineering, strong SQL and Python skills, experience with AWS Redshift, Snowflake, and DBT, and a background in data governance

Qualifications

• Bachelor's degree or equivalent combination of education and experience in a technical field.
• 10 years of relevant work experience in data engineering, BI, or related field.
• Experience with data warehouse design patterns (Snowflake/Star schemas).
• Cloud database experience with AWS (Redshift preferred).
• Advanced SQL skills and query optimization in large datasets.
• Proficient in Python; DBT experience preferred.
• Experience with ETL/ELT jobs and data integrations.
• Experience with Agile software development and DevOps tools.

Responsibilities

• Collaborate with analytics and business teams to improve data models for BI tools.
• Build scalable data integration and storage solutions following architectural roadmap.
• Design, develop, test, and document data pipelines and tests.
• Manage automated deployments via Git pipelines and version control.
• Mentor teammates through code reviews and pairing.

Skills

SQL

Python

Data modeling

ETL/ELT

Git/DevOps

Agile

Education

Bachelor's degree in CS/Engineering/Math

Tools

AWS (Redshift, RDS, S3, EC2, EKS)

Snowflake

DBT

Job description

The American Red Cross is hiring a Lead Data Engineer for its Enterprise Data Analytics team. You will modernize data architecture, build scalable data pipelines, and support enterprise data warehouse initiatives across verticals.

The role is fully remote with occasional in-person meetings and East Coast coordination preference. Ideal candidates have 10+ years in data engineering, strong SQL and Python skills, experience with AWS Redshift, Snowflake, and DBT, and a background in data governance