Lead Data Engineer

American Red Cross; Charlotte (NC); Teletrabalho; USD 145 000 - 160 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, Dental Vision plans

HSA & FSA

PTO 19 days/yr

11 paid holidays

401K with up to 6% match

Paid Family Leave

Employee Assistance

Disability insurance

Service Awards

Resumo da oferta

The American Red Cross is hiring a Lead Data Engineer to join our Enterprise Data Analytics team. You will help modernize our data architecture, design scalable data pipelines, and oversee data warehouse development to support mission-critical reporting and analytics.

This 100% remote role is ideal for someone who thrives on data quality, automation, and mentoring teammates while coordinating with an East Coast schedule for offshore alignment.

Qualificações

• 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 Snowflake and Star/Snowflake schema design patterns.
• Experience with AWS technologies (Redshift, RDS, S3, EC2, EKS, etc.).
• Advanced SQL skills for large-scale datasets and query optimization.
• Proficiency in Python; OO programming.
• DBT experience preferred.
• ETL/ELT development experience.
• Experience with Agile software development methodologies.
• Strong problem-solving and troubleshooting skills.
• Strong documentation skills and process orientation.
• Experience with DevOps tools (Git, Artifactory).
• Experience with multi-system integrations and APIs is a plus.
• Education + experience combine to meet requirements; management experience not substitutable.

Responsabilidades

• Collaborate with analytics and business teams to improve data models for BI tools and drive data-driven decisions across the organization.
• Build scalable solutions aligned to data governance and architectural roadmap for data integrations, storage, reporting, and analytics.
• Design, develop and test data integration solutions; write and document unit/integration/functional tests.
• Manage automated deployments using Git pipelines with version control and deployment automation.
• Collaborate with multiple teams to streamline deployment workflows and monitor pipeline reliability and performance.
• Perform data analysis to troubleshoot data issues and build a data quality framework.
• Mentor junior team members through code reviews and hands-on guidance.

Conhecimentos

Data engineering

SQL

Python

ETL/ELT

Agile

DevOps

Problem solving

Documentation

APIs

Formação académica

Bachelor's degree in CS/Engineering/Math

Ferramentas

Snowflake

Redshift

S3

DBT

Git

Descrição da oferta de emprego

United States, North Carolina, Charlotte

Oct 12, 2026

Please use Google Chrome or Mozilla Firefox when accessing Candidate Home. By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the world's largest humanitarian network? Join us-Where your Career is a Force for Good!

Job Description

Why Choose Us? Joining The American Red Cross is like nothing else - it's as much something you feel as something you do. You become a vital part of the world's largest humanitarian network. Joining a team of welcoming individuals who are exceptional, yet unassuming. Diverse, yet uncompromising in unity. You grow your career within a movement that matters, where success is measured in people helped, communities made whole, and individuals equipped to never stop changing lives and situations for the better.

When you choose to be a force for good, you'll have mentors who empower your growth along a purposeful career path. You align your life's work with an ongoing mission that's bigger than all of us. As you care for others, you're cared for with competitive compensation and benefits. You join a community that respects who you are away from work as much as what you do while at work.

What You Need To Know About The Job

The Enterprise Data & Analytics Team is building out a team of well‑rounded, full‑stack Data Engineers to support mission‑transforming work through data at the American Red Cross. As a result, we are hiring for a Lead Data Engineer for one our highly dynamic product teams to help do this exciting work!

As a Lead Data Engineer for the American Red Cross, you will be part of our Enterprise Data Analytics team that is modernizing and transforming our data and reporting capabilities across multiple verticals by implementing a new modernized data architecture and technical stack.

The Lead Data Engineer will help develop, test, maintain and support an enterprise data warehouse system and corresponding data and will be responsible for database design and implementation of agreed upon standards. This position requires an innovative engineer who is passionate about data, data quality & automation. The ideal candidate will possess strong data warehousing experience and the ability to develop and deploy scalable data pipelines that make data management and analytics/reporting faster, more insightful, and more efficient.

The work location is 100% virtual from a home office with occasional in‑person meetings as necessary. Preference for candidate to work an East coast schedule for coordination with off‑shore resources.

This position also requires the ability to work a rotational weekend support schedule once every 8 weeks.

Where your career is a force for good (Key Responsibilities)

• Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data‑driven decision making across the organization.
• Build and implement scalable solutions that align to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions.
• Design, develop and test data integration solutions. Write, automate and document unit/integration/functional tests.
• Manage automated deployments using Git pipelines, ensuring code changes are efficiently version‑controlled and deployed.
• Collaborate with multiple teams to streamline deployment workflows, monitor and troubleshoot pipelines for reliability and performance.
• Perform data analysis required to troubleshoot data‑related issues by building a data quality framework and assist in the resolution of data issues.
• Serve as tech lead by mentoring less experienced members of the team through code reviews, pair programming and similar hands‑on interactions.

Scope: Individual contributor that works under limited supervision. Apply subject matter knowledge. Capacity to understand specific needs or requirements to apply skills/knowledge. Qualified candidates must be authorized to work in the United States. The American Red Cross does not sponsor employment visas.

What You Need To Succeed (Required/Minimum Qualifications)

• Education: 4-year college degree or equivalent combination of education and experience. Prefer academic backgrounds in Computer Science, Engineering, Mathematics, or related technical field.
• 10 years of relevant work experience in data engineering, business intelligence or related field.
• Experience with a variety of database technologies and data warehouse schema design patterns (snowflake and star in particular).
• Experience with cloud‑based databases, specifically AWS technologies (e.g., Redshift (preferred), RDS, S3, EC2, EKS, Zero ETL)
• Advanced experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large‑scale, complex datasets.
• Proficient in object‑oriented programming. Coding experience in Python is a required.
• Experience with DBT is preferred.
• Experience creating ETL and/or ELT jobs.
• Experience with Agile software development methodologies.
• Excellent problem solving and troubleshooting skills.
• Process oriented with great documentation skills.
• Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
• Experience developing integrations across multiple systems and APIs is a plus.
• Combination of candidate's education and general experience satisfies requirements so long as the total years equate to description's minimum education and general experience years combined (Management experience cannot be substituted).

Pay Information

The annual salary range for this position is $145K - $160K. We do not offer an annual bonus for this role.

Note that American Red Cross salaries are aligned to the specific geographic location in which the work is primarily performed. Other factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have and comparison to other employees already in this role. We will review specific salary information at the time of phone screening based upon your location & experience.

This job will be posted for a minimum of five business days and extended if the applicant pool needs to be expanded.

Benefits for You

• Medical, Dental Vision plans
• Health Spending Accounts & Flexible Spending Accounts
• PTO: Starting at 19 days a year; based on type of job and tenure
• Holidays: 11 paid holidays comprised of six core holidays and five floating holidays
• 401K 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 for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers, San Diego Fair Chance Ordinance, the California Fair Chance Act and any other applicable state and local laws.

AmeriCorps, the federal agency that brings people together through service, and its partners - the Peace Corps, AmeriCorps Alums, National Peace Corps Association, and the Service Year Alliance - launched Employers of National Service to connect national service alumni with opportunities in the workforce. American Red Cross is proud to be an EONS partner and share our employment opportunities with the network of organizations.

Interested in Volunteering? Visit redcross.org/volunteertoday to learn more, including our most-needed volunteer positions.

To view the EEOC Summary of Rights, click here: Summary of Rights