Lead Data Engineer

Role Description

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?

The Enterprise Data & Analytics Team is a full-stack Data Engineering team supporting mission-transforming work through data at the American Red Cross. We are seeking a Lead Data Engineer for one of our highly dynamic product teams to help do this exciting work!

As a Lead Data Engineer, you will be part of our 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.

This role is best suited for individuals with enterprise data warehouses experience who have developed and deployed scalable data pipelines that made data management and analytics/reporting faster, more insightful, and more efficient and can clearly articulate their hands-on involvement in prior work.

The work location is remote with in-person meetings as necessary. Preference for candidate to work an East coast schedule for coordination with off-shore resources and ability to come into a Red Cross office as necessary. This position also requires the ability to work a rotational weekend support schedule once every 8 weeks.

Qualifications

• 4-year college degree in Computer Science, Engineering, Mathematics, or related technical field or equivalent combination of education and experience.
• 10 years of relevant work experience in data engineering, business intelligence or related field.
• Current hands-on experience with a variety of database technologies and data warehouse schema design patterns.
• Cloud-based databases, specifically AWS technologies.
• Advanced experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
• Python coding.
• AI-assisted tools (e.g., GitHub Copilot, Duo) for code development, testing, and documentation across the SDLC.
• Creating ETL and/or ELT jobs.
• DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
• Agile software development methodologies.

Requirements

• Leading data engineering teams in an onshore/offshore model, including mentoring junior engineers through code reviews, pair programming, and establishing team best practices.
• Excellent problem solving and troubleshooting skills.
• Process oriented with great documentation skills.
• Passion, energy, and commitment to the humanitarian mission of the Red Cross.

Benefits

• Medical, Dental, & Vision Plans
• Health Spending Accounts & Flexible Spending Accounts
• PTO + Holidays
• 401K with up to 6% Match
• Paid Family Leave
• Employee Assistance Programs
• Disability and Insurance: Short + Long Term
• Service Awards and Recognition