Lead Data Engineer

American Red Cross

. Develop, test, maintain, and support an enterprise data warehouse system and corresponding data .

Posted 10/12/2026full-timeRemote • United StatesSenior💰 $145,000 - $160,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data engineering and business intelligence, with a strong focus on database technologies, data warehouse design, and cloud-based solutions. Proficient in advanced SQL, Python programming, and ETL processes, while effectively collaborating with cross-functional teams to enhance data quality and reporting capabilities.

Highest-signal resume keywords

Data EngineeringAdvanced SQL Query WritingPython ProgrammingAWS TechnologiesETL/ELT Job Creation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Warehouse Schema DesignDatabase TechnologiesData Integration SolutionsData AnalysisAutomated TestingAgile MethodologiesDevOps MethodologiesObject-Oriented ProgrammingData Quality FrameworkDBT

Soft Skills

Problem-SolvingDocumentation SkillsMentoring

Tools & Technologies

AWS RedshiftAWS RDSAWS S3AWS EC2AWS EKSGitArtifactory

Industry Keywords

Business IntelligenceData IntegrationData AnalyticsCloud-Based DatabasesData Quality

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloudEC2ETLPythonSQL

About the role

Key responsibilities & impact

Develop, test, maintain, and support an enterprise data warehouse system and corresponding data
Design and implement database standards
Modernize and transform data and reporting capabilities across multiple verticals
Collaborate with analytics and business teams to improve data models feeding business intelligence tools
Build and implement scalable solutions for data integrations, storage, reporting, and analytics
Design, develop, and test data integration solutions
Write, automate, and document unit, integration, and functional tests
Manage automated deployments using Git pipelines
Collaborate with multiple teams to streamline deployment workflows
Monitor and troubleshoot pipelines for reliability and performance
Perform data analysis to troubleshoot data-related issues
Build a data quality framework and assist with resolving data issues
Mentor less experienced team members through code reviews, pair programming, and hands-on interactions
Work as an individual contributor under limited supervision

Requirements

What you’ll need

4-year college degree or equivalent combination of education and experience
10 years of relevant work experience in data engineering, business intelligence or related field
Experience with database technologies and data warehouse schema design patterns, particularly snowflake and star
Experience with cloud-based databases and AWS technologies, including Redshift, RDS, S3, EC2, EKS, and Zero ETL
Advanced SQL query writing and optimization experience with large-scale, complex datasets
Proficient in object-oriented programming
Required coding experience in Python
Experience creating ETL and/or ELT jobs
Experience with Agile software development methodologies
Experience with DevOps methodologies and tools, including Git and Artifactory
Process-oriented with strong documentation skills
Strong problem-solving and troubleshooting skills
Authorized to work in the United States
Ability to work a rotational weekend support schedule once every 8 weeks
Experience with DBT is preferred
Experience developing integrations across multiple systems and APIs is a plus

Benefits

Comp & perks

Medical, Dental Vision plans
Health Spending Accounts & Flexible Spending Accounts
PTO: Starting at 19 days a year; based on type of job and tenure
11 paid holidays comprised of six core holidays and five floating holidays
401K with up to 6% match
Paid Family Leave
Employee Assistance
Short + Long Term Disability and Insurance
Service Awards and recognition
Competitive compensation and benefits
Mentors who empower your growth along a purposeful career path