Lead Data Engineer

American Red Cross; Charlotte (NC); Remote; USD 140,000 - 150,000; Full time

Job summary

A non-profit humanitarian organization in Charlotte is seeking a Lead Data Engineer to modernize data and reporting capabilities. This role requires over 10 years of experience in data engineering, proficiency in SQL and Python, and experience with AWS cloud services. The position is 100% remote with a rotational weekend support schedule. Benefits include competitive salary, medical plans, and generous PTO.

Benefits

Medical, Dental, and Vision plans

401(k) with up to 6% match

PTO starting at 19 days a year

Paid Family Leave

Qualifications

• 10+ years in data engineering or related field.
• Experience with database technologies and data-warehouse schema design.
• Advanced SQL skills for large datasets.
• Proficiency in object-oriented programming, coding in Python.

Responsibilities

• Collaborate to improve data models for business intelligence tools.
• Build scalable solutions aligned with data governance standards.
• Design and test data integration solutions.
• Manage automated deployments using Git pipelines.
• Monitor and troubleshoot data pipelines for reliability.

Skills

Data engineering

SQL

Python

Cloud databases (AWS)

Data warehouse schema design

Problem solving

Education

4-year college degree in Computer Science or related field

Tools

DBT

Git

ETL/ELT tools

Job description

Join us – Where your Career is a Force for Good!

Job Description:

Why Choose Us?

Joining the American Red Cross means becoming part of the world’s largest humanitarian network, contributing to life‑changing missions, mentoring growth, and receiving competitive compensation and benefits. You’ll work in a welcoming, diverse environment that honors your contributions both inside and outside of work.

What You Need to Know About the Job

The Enterprise Data & Analytics Team is building a full‑stack Data Engineering team to support mission‑transforming work. We are hiring a Lead Data Engineer for a highly dynamic product team, responsible for modernizing and transforming data and reporting capabilities across multiple verticals by building scalable data pipelines, designing data warehouses, and ensuring high data quality and automation. The role is 100% virtual with occasional in‑person meetings, prefers an East Coast schedule for offshore coordination, and requires a rotational weekend support schedule once every 8 weeks.

Key Responsibilities

• Collaborate with analytics and business teams to improve data models that drive business‑intelligence tools.
• Build scalable solutions aligned with data governance standards and architectural roadmap for integrations, storage, reporting, and analytics.
• Design, develop, and test data integration solutions, including writing, automating, and documenting tests.
• Manage automated deployments using Git pipelines to ensure version control and efficient deployment.
• Streamline deployment workflows, monitor, and troubleshoot pipelines for reliability and performance.
• Perform data analysis for troubleshooting, build a data‑quality framework, and resolve data issues.
• Act as a tech lead by mentoring team members through code reviews, pair programming, and hands‑on interactions.

What You Need to Succeed (Required/Minimum Qualifications)

• Education: 4‑year college degree or equivalent, preferably in Computer Science, Engineering, Mathematics, or related fields.
• Experience:
  • 10+ years in data engineering, business intelligence, or a related field.
  • Experience with database technologies and data‑warehouse schema design (snowflake and star).
  • Cloud‑based databases, especially AWS (Redshift, RDS, S3, EC2, EKS).
  • Advanced SQL skills for large, complex datasets.
  • Proficiency in object‑oriented programming; coding experience in Python is required.
  • Preferred: DBT, ETL/ELT job creation, Agile methodology, DevOps tools (Git, Artifactory), integration via APIs.
  • Excellent problem‑solving, documentation, and process orientation.

Pay Information

Annual salary range: $140,000 – $150,000. No annual bonus for this role.

Benefits for You

• Medical, Dental, and Vision plans
• Health Spending Accounts & Flexible Spending Accounts
• PTO: Starting at 19 days a year (varies by role and tenure)
• Holidays: 11 paid holidays (6 core + 5 floating)
• 401(k) with up to 6% match
• Paid Family Leave
• Employee Assistance
• Disability and Insurance (short & long term)
• Service Awards and recognition

The American Red Cross is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law. Qualified applicants with arrest or conviction records will be considered in accordance with applicable fair‑chance ordinances.