Lead Data Engineer
$140k/y-$150k/y
American Red Cross2 days ago
Highlight
RemoteFull-timeDirector
Summary
American Red Cross is seeking a Lead Data Engineer to join their Enterprise Data & Analytics Team in a fully remote position. The role involves modernizing and transforming data and reporting capabilities across multiple verticals.
About the Role
As a Lead Data Engineer, you will develop, test, maintain, and support an enterprise data warehouse system. You will collaborate with analytics and business teams to improve data models, build scalable solutions, and manage automated deployments. The position requires a strong focus on data quality and automation, with responsibilities including troubleshooting data-related issues and mentoring less experienced team members.
About You
Required:
- 4-year college degree or equivalent combination of education and experience 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 cloud-based databases, specifically AWS technologies (e.g., Redshift, RDS, S3, EC2, EKS).
- Advanced experience using SQL queries and optimizing SQL queries in a business environment with large-scale datasets.
- Experience with various database technologies and data warehouse schema design patterns (snowflake and star).
- Proficient in object-oriented programming with hands-on coding experience in Python.
- Excellent data analysis and problem-solving skills.
- Experience with DevOps methodologies and tools (e.g., Git, Artifactory).
- Proficient in use of AI tools for coding efficiency.
- Experience in daily Engineering operations, support, and issue resolution.
- Experience with Agile software development methodologies.
- Self-motivated with the ability to work independently and as part of a team.
- Strong professionalism, interpersonal, written/verbal communication, and problem-solving skills.
Preferred:
- Experience with Informatica or similar software solutions.
- Experience with Apache Airflow, Mage, or similar orchestration services.
- Experience with AWS services (S3, Postgres, IAM).
- Experience with DBT.
- A sense of passion and eagerness to contribute to the mission of the Red Cross.
Benefits
- Medical, Dental, and 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.
- Disability and Insurance: Short + Long Term.
- Service Awards and recognition.
American Red Cross
The American Red Cross prevents and alleviates human suffering in the face of emergencies by mobilizing the power of volunteers and the generosity of donors. Each day, thousands of people – people just like you – provide compassionate care to those in need. Our network of generous donors, volunteers and employees share a mission of preventing and relieving suffering, here at home and around the world. We roll up our sleeves and donate time, money and blood. We learn or teach life-saving skills so our communities can be better prepared when the need arises. We do this every day because the Red Cross is needed - every day.
Philadelphia, PA