Leukemia & Lymphoma Society Looking for ETL Tester at Rye, NY  Full Time

How many people can answer the question, “What do you do for a living?” with the answer, “I help find cures for cancer.” At LLS, employees take our mission seriously. Whether you work in one of our chapters, are an accountant at the national office or a specialist in our Information Resource Center, you work each day on making our mission a reality: Cure leukemia, lymphoma, Hodgkin’s disease and myeloma, and improve the quality of life of patients and their families. Join us and give new meaning to the word, “job.”

The Leukemia & Lymphoma Society (LLS) currently uses Salesforce as the CRM for patient education & services and fundraising. We want a technologist with a passion for excellence who thrives in a fast-paced, high-energy environment. As a member of the Digital Transformation team, you will primarily work on testing data integration and making sure data in the target systems is reliable, improving user experience for our organization. As a key member of the team, you will be responsible for creating test plans, coordinating testing activities and work to resolve and troubleshoot problems and bugs. You will perform thorough regression testing on our systems when enhancements are made and when bugs are resolved.

As a valued member of LLS, 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.

While employees may be permitted to work remotely, travel to the assigned office, HUB or Satellite Offices may be required as determined by the employee’s manager and the employee’s Strategic Talent Partner.

Duties and Responsibilities:

• Review Data Models, Data Mappings, Architectural Documentation to create/execute effective System Integration Test Plans and System Integration Test
• Validate data by creating and executing queries in the database and verify that the results match the expectations.
• Write complex queries to reconcile data with source data.
• Ensuring proper traceability from requirements to test artifacts.
• Use bug tracking software to track and report problems.
• Knowledge of Agile development practices, particularly scrum and sprint-based delivery.
• Help with functional testing other LLS when needed.

#LI-Remote

Education & Experience Requirements:

• Bachelor’s degree in computer science, engineering, mathematics, or related field of study; or equivalent education, training & experience.
• 3+ Years of Software Quality Assurance experience on enterprise level applications which includes ETL & Data Warehouse Testing.
• Ability to transform complex Business logic into executable database queries.
• Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes.
• Build tests and perform End to End testing.
• Experience working with SQL Server, Snowflake & MySQL Databases.
• Experience with Automation tools, preferably Selenium.
• Proven data analysis, data verification and problem-solving abilities.
• Excellent verbal and written communication skills.

Physical Demands & Work Environment:

• Must be able and willing to assume occasional on-call assignments related to off-hours system rollout work
• Physical demands are minimal and typical of similar jobs in comparable organizations
• Work environment is representative and typical of similar jobs in comparable organizations
• Average salary range is $56,662 – $81,739 , open to further discussion based on geography.

LLS 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. LLS seeks such skilled and qualified individuals to share our mission and where they will join a cohort of others who have chosen to call LLS home. LLS 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.