It is an exciting time to be a part of the Informatics and Analytics (I&A) department at Dana-Farber. I&A is a core component of the Institute, using data, AI, and software to drive operational innovation that is accelerating DFCI?s mission to defy cancer and improve the lives of our patients, caregivers, and staff. Dana-Farber has embraced the capabilities of AI and Analytics as a core enabler of this mission, both of which require a solid, interconnected data foundation to be utilized to their fullest.

Join the Enterprise Data Systems team at Dana-Farber's I&A/Enterprise Data and Analytics organization, where we lay the groundwork for business intelligence and analytics across various business units, including research. We seek a detail-oriented and experienced ETL (Extract, Transform, Load) QA Engineer II to join our team. The ETL QA engineer II will validate data sources, extract data, apply transformation logic, and load the data into the target systems. The ideal candidate will have a strong understanding of database structures, theories, principles, and practices and hands-on experience with ETL processes and testing methodologies.

Located in Boston and the surrounding communities, Dana-Farber Cancer Institute is a leader in life-changing cancer research and patient care breakthroughs. We are united in our mission of conquering cancer, HIV/AIDS, and related diseases. We strive to create an inclusive, diverse, and equitable environment where we provide compassionate and comprehensive care to patients of all backgrounds and design programs to promote public health, particularly among high-risk and underserved populations. We conduct groundbreaking research that advances treatment, educate tomorrow's physicians/researchers, and work with excellent partners, including other Harvard Medical School-affiliated hospitals.

PRIMARY DUTIES AND RESPONSIBILITIES:

• • As a Quality Developer, you will be responsible for ensuring the highest level of software quality and reliability through comprehensive testing methodologies
  • Collaborate with software development teams to understand requirements, design specifications, and implementation details
  • Design, develop, and maintain automated test frameworks for data-driven testing and integration testing, incorporating Snowflake and SQL
  • Identify, analyze, and troubleshoot software defects, documenting and tracking issues to ensure timely resolution
  • Conduct root cause analysis for test failures, working closely with development teams to resolve issues and improve software quality
  • Collaborate with cross-functional teams to understand business requirements, ensuring alignment between quality assurance activities and organizational goals

MINIMUM JOB QUALIFICATIONS:

• Bachelor?s degree Computer Science, Software Engineering, or equivalent industry experience
• 2 +  years of experience with manual Software testing.
• Understanding of quality assurance testing methodologies and the software development life cycle
• Experience in writing complex SQL queries, Should have experience testing multiple test phases in medium to large projects and have adequate experience and clear understanding of data warehouse and data mart testing.
• Hands-on experience with Snowflake data platform and its testing methodologies
• Solid QA experience in Manual Testing
• Expertise in SQL language for data validation, manipulation, and querying

KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:

• Capability in managing the testing projects right from requirement analysis, preparing test strategies, estimation, schedule tracking, and UAT support
• Excellent bug reporting skills and documenting follow up and resolution
• Good understanding of Relational database and ability to write SQL scripts
• Experience of Python will be a plus
• Understanding of code repositories and Git
• Hands-on experience using technology to support agile software development processes
• Ability to contribute to the implementation of multiple concurrent projects in a fast-paced scientific and multidisciplinary environment.
• Ability to handle a variety of tasks, effectively solve problems with numerous and complex variables and be able to shift priorities flexibly 
• Ability to communicate technical topics to technical and non-technical audiences.
• Ability to motivate and inspire others in a team-oriented, collaborative environment
• Strong interpersonal and collaboration skills; excellent verbal and written communications skills
• Ability to work in a very complex organizational structure with diplomacy, patience, and respect
• Proficient with Microsoft Office applications, JIRA, MS Office 365 (Confluence, Excel, Word, Presentation)

At Dana-Farber Cancer Institute, we work every day to create an innovative, caring, and inclusive environment where every patient, family, and staff member feels they belong.  As relentless as we are in our mission to reduce the burden of cancer for all, we are equally committed to diversifying our faculty and staff.  Cancer knows no boundaries and when it comes to hiring the most dedicated and diverse professionals, neither do we. If working in this kind of organization inspires you, we encourage you to apply.

Dana-Farber Cancer Institute is an equal opportunity employer and affirms the right of every qualified applicant to receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, national origin, sexual orientation, genetic information, disability, age, ancestry, military service, protected veteran status, or other characteristics protected by law.

EEOC Poster