Lead Data Warehousing Engineer (work from home)
Company: American Red Cross
Location: Richmond
Posted on: January 26, 2023
|
|
Job Description:
Please use Google Chrome or Mozilla Firefox when accessing
Candidate Home.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: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.By joining
the American Red Cross, you will enjoy a collaborative work culture
committed to the diversity of our people, programs, and services.
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? If you share our
passion for helping people, Join us- Where your Career is a Force
for Good!
About the job:
The Enterprise Data & Analytics Team is building out a team of Data
Warehouse Engineers to support mission-transforming work through
data at the American Red Cross. As a result we are hiring multiple
Lead Data Warehouse Engineers to help do this exciting work!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.
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.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 writing and
optimizing SQL queries and stored procedures in a business
environment with large-scale, complex datasets.* 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 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.++++++++++++++++++++++++++++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.What's in it for you:
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.**
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.
* Stay Healthy: Medical, Dental, Vision Plans
* Paid Family Leave: 12 weeks paid at 80%
* Relax with Time Away: PTO + Holidays
* Save for your Future: 401K with up to 4% Match
* Employee Assistance: 24/7 Mental Health Resources
* Disability and Insurance: Short + Long Term
* Service Awards and Recognition: 1 year + 5 year
* Career Development: Pay for Performance, Ongoing Education
To be considered for this position, please visit
www.redcross.org/jobs to apply.Diversity, Equity & Inclusion:
The Red Cross supports a variety of cultural groups for employees
and volunteers. From our Latino Resource Group, Umoja, Asian
American & Pacific Islanders, and Red Cross Pride, to the Ability
Network, Veterans+ and our Women's Resource Group, these networks
provide connections, mentoring and help give voice to important
concerns and opinions.
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.*LI-EH1
IND123Apply 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
Keywords: American Red Cross, Richmond , Lead Data Warehousing Engineer (work from home), Engineering , Richmond, Virginia
Click
here to apply!
|