Lead Data Engineer

$140,000 - $150,000/Yr

American Red Cross - Charlotte, NC

Full-time - Mid Level

Charlotte, NC

Social Assistance

About the position

The Lead Data Engineer at the American Red Cross will play a crucial role in the Enterprise Data & Analytics Team, focusing on modernizing and transforming data and reporting capabilities. This position involves developing, testing, maintaining, and supporting an enterprise data warehouse system, ensuring data quality and automation, and collaborating with various teams to enhance data accessibility and decision-making across the organization.

Responsibilities

• Collaborate with analytics and business teams to improve data models that feed business intelligence tools.
• Build and implement scalable solutions that align with data governance standards and architectural roadmap.
• Design, develop, and test data integration solutions, including writing and automating tests.
• Manage automated deployments using Git pipelines for efficient version control and deployment.
• Monitor and troubleshoot deployment workflows for reliability and performance.
• Perform data analysis to troubleshoot data-related issues and assist in resolving them.
• Mentor less experienced team members through code reviews and pair programming.

Requirements

• 4-year college degree or equivalent combination of education and experience, preferably in Computer Science, Engineering, Mathematics, or related field.
• 7+ 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 schemas.
• Experience with cloud-based databases, specifically AWS technologies (e.g., Redshift, RDS, S3, EC2, EKS).
• Proficient in SQL queries and optimizing them for large-scale datasets.
• Experience creating ETL and/or ELT jobs.
• Familiarity with Agile software development methodologies.
• Excellent problem-solving and troubleshooting skills.
• Proficient in object-oriented programming, particularly Python.
• Experience with DevOps methodologies and tools (e.g., Git, Artifactory).
• Experience developing in a Linux environment.

Nice-to-haves

• Experience developing integrations across multiple systems and APIs.
• Familiarity with Big Data tools like Spark, Hadoop, Kafka.

Benefits

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