Remote OK
$89k–$128k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Snowflake, SQL, ETL/ELT, AWS, Azure
Remote OK
$96k–$139k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Microsoft M365 Copilot, Generative AI, Data Science, LLM Prompt Design, Retrieval-Augmented Generation (RAG)
Boca Raton, Florida, United States · Hybrid
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Event Logistics, Data Management, Volunteer Coordination, CRM Management, Budget Management
Fairfield, Connecticut, United States · Hybrid
$78k–$87k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Peer To Peer Fundraising, Volunteer Management, Relationship Building, Strategic Planning, Donor Cultivation
Rye Brook, New York, United States · Hybrid
$103k–$119k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Major Gift Fundraising, Portfolio Management, Donor Cultivation, Donor Stewardship, Salesforce
Fort Lauderdale, Florida, United States · Hybrid
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Peer To Peer Fundraising, Volunteer Management, Relationship Building, Strategic Planning, Donor Cultivation
Melville, New York, United States · Hybrid
$57k–$63k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Event Logistics, Data Management, Volunteer Coordination, CRM Systems, Budget Management
Allentown, Pennsylvania, United States · Hybrid
$70k–$72k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Peer-to-Peer Fundraising, Volunteer Management, Relationship Building, Strategic Planning, Donor Cultivation
Columbia, South Carolina, United States · Hybrid
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Peer To Peer Fundraising, Volunteer Management, Relationship Building, Strategic Planning, Donor Cultivation
Remote OK
$76k–$110k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Business Analysis, Requirements Elicitation, Agile Frameworks, Process Mapping, Stakeholder Management
Chicago, Illinois, United States · Hybrid
$74k–$80k/yr
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our region…
Skills: Peer To Peer Fundraising, Volunteer Management, Relationship Building, Strategic Planning, Donor Cultivation
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Design, build, and maintain scalable data architecture and the Enterprise Data Warehouse using Snowflake. Partner with integration and BI teams to optimize data models and ensure data quality across pipelines.
Requires a Bachelor's degree in Computer Science or a related field and over 5 years of experience implementing large-scale data solutions. Must have hands-on expertise with Snowflake, SQL, and cloud platforms like AWS, Azure, or GCP.
How many people can answer the question, "What do you do for a living?" with the answer, "I help find cures for cancer." At Blood Cancer United, employees take our mission seriously. Whether you work in one of our regions, are an accountant at the national office or a specialist in our Information Resource Center, you work each day on making our bold goal a reality: to enable patients with blood cancer to gain more than one million years of life by 2040. Join us and give new meaning to the word, "job."
Summary: As part of a mission centric, locally delivered and nationally powered organization, this role serves as the individual that provides technical expertise in the design, build, optimization, implementation, and maintenance of a data solution. This role will be responsible for developing the Enterprise Data Warehouse, ensuring that operational data enables analytics and business intelligence across the organization.
Duties and Responsibilities:
Design, build, and maintain scalable and secure data architecture in Snowflake.
Develop and optimize Snowflake objects (tables, dynamic tables, views, warehouses).
Manage Snowflake Security and Access.
Partner with our Integration team on ETL pipelines in and out of the data warehouse using Snowflake-native tools and other tools available (i.e. Informatica and MuleSoft).
Build and manage deployment of Snowflake changes across environments, including production (GitHub).
Ensure data quality, integrity, and lineage across pipelines.
Write and optimize query performance and warehouse usage. Monitor Snowflake compute costs.
Developing scripts for moving data and ETL/ELT between AWS and Snowflake
Work with cloud technologies such as AWS, S3, Azure, GCP, and blob storage.
Support the production environment for the Enterprise Data Warehouse by handling issues such as Ingestion and transformation problems.
Perform unit testing and clearly document build so others can easily understand the implementation.
Partner with data analysts, governance, and Business Intelligence teams to enable analytics.
Support the Data Architect and Business Intelligence with optimized data models.
Translate business requirements into scalable data solutions.
Maintain a working knowledge of the LLS mission and programs to promote Organizational initiatives.
Perform other related duties as assigned.
#LI-Remote
Education & Experience Requirements:
Bachelor’s degree in Computer Science, Information Systems, or related field.
5+ years of designing and implementing a fully operational production grade large scale data solution.
Hands-on experience with Snowflake Data Cloud.
Understanding of enterprise data management concepts (governance, engineering, science, lake, warehouse, sharing and applications)
Experience using GitHub for deployments.
Strong SQL skills
Experience with cloud platforms such as AWS, Azure, or GCP
Knowledge of data modeling techniques (Kimball, Data Vault).
Excellent presentation and communication skills, both written and verbal
Ability to problem solve in an environment with unclear requirements
Physical Demands & Work Environment:
Physical demands are minimal and typical of similar jobs in comparable organizations
Work environment is representative and typical of similar jobs in comparable organizations
Weekend and evening work may be required
Employee Value Proposition:
As a valued member of Blood Cancer United, you are eligible for a comprehensive benefits package. Our offerings include medical, dental, and vision insurance; life insurance; flexible spending accounts; a 403b retirement plan along with generous paid time off. In addition, we observe federal paid holidays throughout the year, and offer a wellness program and an employee assistance program.
We are excited to share the base pay range for this position is $89K to $128K. The offered compensation may vary based on factors such as geographic location, business need, market conditions, proficiencies, skills, education, and experience. Additionally, at Blood Cancer United we place a high value on internal pay equity and will consider the current compensation of similarly situated roles and direct team members. Base compensation is only one component of our Total Rewards program, which also includes an annual incentive plan and a competitive benefits package.
The statements herein are intended to describe the general nature and level of work being performed by employees, and are not to be construed as an exhaustive list of responsibilities, duties, and skills required of employees. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Disclaimer
Blood Cancer United is an equal employment opportunity employer committed to diversity and inclusion in its workplace. All qualified applicants will receive consideration for employment without regard to sex, gender, gender identity and expression (including transgender status), sexual orientation, pregnancy, age, race, color, creed, national origin/ancestry, citizenship, religion, genetic predisposition or information, physical or veteran status, or any other characteristic protected by law. Blood Cancer United seeks such skilled and qualified individuals to share our mission and where they will join a cohort of others who have chosen to call Blood Cancer United home. Blood Cancer United complies with all applicable laws which prohibit discrimination and harassment in the workplace, and is committed to maintaining a diverse and inclusive environment supportive of all of our employees and the communities we serve.
We are Blood Cancer United, and we believe everyone with blood cancer deserves a longer, better life. That’s why we are on a mission to find a cure and improve the quality of life for everyone with blood cancer. How? We fund life-saving blood cancer research around the world, provide free information and support services for patients and their families, and are the voice for those seeking access to quality, affordable, coordinated care. With your help, we have invested more than $1.8 billion in groundbreaking research supporting many of today’s most innovative approaches to treatment—helping those with blood cancer not only survive but also thrive.
Offices: 1201 15th St NW, Suite 410, Washington, District of Columbia 20005, US
We are Blood Cancer United, and we believe everyone with blood cancer deserves a longer, better life. That’s why we are on a mission to find a cure and improve the quality of life for everyone with blood cancer. How? We fund life-saving blood cancer research around the world, provide free information and support services for patients and their families, and are the voice for those seeking access to quality, affordable, coordinated care. With your help, we have invested more than $1.8 billion in groundbreaking research supporting many of today’s most innovative approaches to treatment—helping those with blood cancer not only survive but also thrive.
Offices: 1201 15th St NW, Suite 410, Washington, District of Columbia 20005, US
