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? **** As a condition of employment with American Red Cross, you are required to provide proof that you are fully vaccinated for COVID 19 or qualify for an exemption, except in states where it is prohibited by law. Accordingly, employment is conditioned on providing proof of vaccination or having an approved exemption prior to starting employment **** Join us-Where your Career is a Force for Good! Job Description: Our Commitment to COVID-19 Safety: The American Red Cross requires all new hires be fully vaccinated against COVID-19 as a condition of Employment, except in states where it is prohibited by law. This means that all individuals working for the organization must be fully vaccinated against COVID-19 by the start of their employment or seek an exemption. Upon being offered a position, individuals will be required to submit proof of vaccination. If you are unable to be vaccinated due to medical or religious reasons, you may qualify for an exemption. If seeking an exemption, you will be required to submit documentation at the time of offer and your request must be approved prior to hire. Why Choose Us? 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. We depend on the many generous contributions of time, blood, and money from the American public to support our lifesaving services and programs. At the American Red Cross, you will enjoy a collaborative work culture committed to the diversity of our people, programs, and services. If you share our passion for helping people, join us in this excellent career opportunity. We are seeking two Lead Data Warehouse Engineers! 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. About the job: As a Lead Data Warehouse Engineer for the American Red Cross, you will be part of a Data Management team that is modernizing and transforming our data and reporting capabilities across multiple verticals by implementing a new modernized data architecture. The Lead Data Warehouse Engineer will help develop, 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. The ideal candidate will possess strong data warehousing experience and the ability to develop scalable data pipelines that make data management and analytics/reporting faster, more insightful, and more efficient. In addition, the Lead Data Warehouse Engineer will: 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 and develop data integrations and a data quality framework. Write unit/integration/functional tests and document work. Perform data analysis required to troubleshoot data-related issues 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 we need from you: Education: 4-year college degree or equivalent combination of education and experience. Prefer academic backgrounds in Computer Science, Mathematics, Statistics, 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, EMR, EC2, Kinesis) is a plus. 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 in particular). 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. ++++++++++++++++++++++++++++ The legal stuff: Essential Functions/Physical Requirements: Depending on work assignment, may require ordinary ambulatory skills sufficient to visit other locations; or the ability to stand, walk and manipulate (lift, carry, move) light to medium weights of up to 20 pounds. Requires good hand-eye coordination, arm, hand and finger dexterity, including ability to grasp, and visual acuity to use a keyboard, operate equipment and read technical information. Overall mobility is essential. May include sitting for long periods of time, driving a vehicle and working under challenging conditions. Work Conditions: Work is performed indoors with some potential for exposure to safety and health hazards related to emergency services relief work. May travel and participate in meetings and conferences throughout chapter jurisdiction, state and Red Cross system. Because the Red Cross is a disaster response organization, staff may be asked to be on 24-hour call during period of major disaster. What’s in it for you: For those candidates located in Colorado or Connecticut, the annual salary range for this position is $140K. We do not offer an annual bonus for this role. Note that the American Red Cross sets salary ranges aligned to a specific geographic location in which the job or employee resides. The stated salary range in this posting is an average and may not be reflective of your individual circumstances. We will review specific salary information at the time of phone screening based upon your location. The American Red Cross is a diverse nonprofit organization that creates a culture of collaboration and team spirit. We offer our employee’s a competitive salary, wide range of generous benefits including health, dental, vision, life and disability insurance; flexible spending accounts; 401K retirement plan with match; paid time off, holidays and floating holidays and paid family leave. Also, we encourage professional development and provide growth opportunities. To be considered for this position, please visit to apply.
*LI-EH1 Apply now! Joining our team will provide you with the opportunity to make a difference every day. The American Red Cross is an Equal Opportunity/Affirmative Action 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. Interested in Volunteering? Life’s emergencies don’t stop, and neither do American Red Cross volunteers, who represent more than 90 percent of our workforce to help prevent and alleviate human suffering. You can make a difference by volunteering in a position that appeals to you and allows you to use your unique skills and talents. The Red Cross relies on generous volunteers who give their time and talent to help fulfill our lifesaving mission. 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 #J-18808-Ljbffr
integration-testing Agile Code review API Troubleshooting data-management Apache Spark Apache Kafka Data Storage ELT Linux Writing reports and proposals remote work data-modeling Mentoring data governance data-pipelines Unit testing Hadoop pair-programming OOP data-quality Business Intelligence (BI) Data Analyst Python Problem-solving data-warehouse functional-testing Data Architect Big data DevOps database-design SQL Technical Lead Analytics ETL