Lead Data Engineer - Military Veterans
at American Red Cross
As one of the nation’s premier humanitarian organizations, the American Red Cross is dedicated to helping people in need throughout the United States and, in association with other Red Cross networks, throughout the world. When you join our team, you have a direct impact on a meaningful mission, and you can help save lives every day. If you share our passion for helping people, join us in this excellent career opportunity. Work where your career is a force for good.
We are committed to the diversity of our workforce and to delivering our programs and services in a culturally competent manner reflecting the communities we serve. Our work environment is collaborative, respectful, and inclusive with a focus on building allyship and a culture of belonging that empowers all team members. Come to learn, grow, and succeed while sharing your passion for making a difference.
The Red Cross supports a variety of cultural and community resource groups for employees and volunteers. From the Ability Network, our Asian American & Pacific Islander Resource Group, the Latino Resource Group, and Red Cross PRIDE, to the Umoja African American Resource Group, our Veterans+ Resource Group, and the Women’s Resource Group, these networks provide connections, mentoring and help give voice to important concerns and opinions.
At the American Red Cross, your uniqueness can shine!
WHAT YOU NEED TO KNOW ABOUT THE JOB:
The Enterprise Data & Analytics Team is building out a team of well-rounded, full-stack Data Warehouse Engineers to support mission-transforming work through data at the American Red Cross. As a result, we are hiring for a Lead Data Warehouse Engineer for one our highly dynamic product teams to help do this exciting work!
As a Lead Data Warehouse 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 Warehouse 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 be in the Mid-Atlantic states (NC, SC, VA) &/or to work an East coast schedule & with off-shore resources.
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.
7+ 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, RDS, S3, EC2, EKS, Zero ETL)
Experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
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.
Proficient in object-oriented programming (Python is a must).
Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
Experience developing in a Linux environment.
Experience developing integrations across multiple systems and APIs is a plus.
Experience with Big Data tools like Spark, Hadoop, Kafka, etc. 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 $135K - $140K. 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. *
BENEFITS FOR YOU:
We take care of you, while you take care of others. As a mission-based organization, we believe our team needs great support to do great work. Our comprehensive benefits help you in balancing home and work, retirement, getting healthy and more. With our resources and perks, you have amazing possibilities at the American Red Cross to advance and learn.
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
]]>
NC
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.