Job Description
Title: Data Engineer
(work from home)
Location: Raleigh, NC, United States
Full Time
WHAT YOU NEED TO KNOW ABOUT THE JOB:
We are seeking 1 Data Engineer to join a newly formed Data Engineering team that is focused on making critical data at the American Red Cross available to our business teams. Using the agile framework, you will build end-to-end pipelines based on rigorous engineering standards and coding practices to deliver data that is accessible and of the highest quality. The Data Engineer will also contribute to the modernization of our architecture and tools to help increase our output, scalability, and speed.
The Data Engineer will design and develop highly scalable and extensible data pipelines which enable collection, storage, distribution, modeling, and analysis of large data sets from numerous channels. This position requires an innovative software engineer who is passionate about data & data quality. The ideal candidate will have data warehousing and integration experience and the ability to develop scalable data pipelines that make data management and analytics/reporting faster, more insightful, and more efficient.
WORK LOCATION & SCHEDULE:
The candidate will primarily work virtually from a home with occasional in-person meetings as necessary. Preference for candidate to work an east coast schedule.
WHERE YOUR CAREER IS A FORCE FOR GOOD (Key Responsibilities):
- Develop, test, document and maintain scalable data pipelines.
- Build out new data integrations including APIs to support continuing increases in data volume and complexity.
- Follow data governance processes and guidelines to ensure data availability, usability, consistency, integrity, and security.
- Build and implement scalable solutions that align to our data governance standards and architectural road map for data integrations, data storage, reporting, and analytic solutions.
- 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.
- Design and develop data integrations and a data quality framework. Write unit/integration/functional tests and document work.
- Design, implement, and automate deployment of our distributed system for collecting and processing streaming events from multiple sources
- Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.
PAY INFORMATION:
The annual salary range for this position is $120K – $125K. 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.**
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 in Computer Science, Mathematics, Statistics, or related technical field.
- 3+ years of relevant work experience in analytics, data engineering, business intelligence or related field.
- Experience with or knowledge of Agile software development methodologies.
- Experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
- Proficient with object oriented-programming (Python in particular.)
- Experience developing integrations across multiple systems and APIs.
- Experience with data warehouse technologies.
- Experience creating ETL and/or ELT jobs.
- Excellent problem solving and troubleshooting skills.
- Process oriented with great documentation skills.
- Experience developing in a Linux environment.
- Experience with cloud-based databases, specifically AWS technologies (e.g. Redshift, RDS, S3, EMR, EC2, Kinesis) is a plus.
- Familiarity with designing data schemas and operating SQL/NoSQL database systems is a plus.
- Familiarity 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).
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 4% Match
- Paid Family Leave
- Employee Assistance Programs
- Disability and Insurance: Short + Long Term
- Service Awards and Recognition