Software Development Engineer II - WHI/MOSAAIC

Fred Hutchinson Cancer Center is an independent, nonprofit organization providing adult cancer treatment and groundbreaking research focused on cancer and infectious diseases. Based in Seattle, Fred Hutch is the only National Cancer Institute-designated cancer center in Washington.

With a track record of global leadership in bone marrow transplantation, HIV/AIDS prevention, immunotherapy and COVID-19 vaccines, Fred Hutch has earned a reputation as one of the world's leading cancer, infectious disease and biomedical research centers. Fred Hutch operates eight clinical care sites that provide medical oncology, infusion, radiation, proton therapy and related services, and network affiliations with hospitals in five states. Together, our fully integrated research and clinical care teams seek to discover new cures to the world's deadliest diseases and make life beyond cancer a reality.

At Fred Hutch we value collaboration, compassion, determination, excellence, innovation, integrity and respect. Our mission is directly tied to the humanity, dignity and inherent value of each employee, patient, community member and supporter. Our commitment to learning across our differences and similarities make us stronger. We seek employees who bring different and innovative ways of seeing the world and solving problems.

The National Institutes of Health (NIH) established the Women's Health Initiative (WHI) in 1991 to address the most common causes of death, disability and impaired quality of life in postmenopausal women.

The Women's Health Initiative (WHI) is one of the largest and most comprehensive studies of women's health and is at the forefront in women's health research. WHI study results have been published in top medical journals and have had a significant impact on women's health. The WHI is designed to investigate strategies for the prevention and control of some of the most common causes of morbidity and mortality among postmenopausal women, including cancer, cardiovascular disease, and osteoporotic fractures.

The WHI Clinical Coordinating Center (CCC), located at Fred Hutchinson, is responsible for study implementation and coordination of statistical, epidemiologic, nutritional and clinical aspects of the WHI and is responsible for data collection, management and analysis. In addition to the WHI CCC, NIH has recently launched a program for a new coordinating center (MOSAAIC CC) and Fred Hutch has been chosen to coordinate this national effort. The objective is to provide scientific, statistical, and cultural expertise and coordination support to establish a population-based cohort focusing on Asian Americans, Native Hawaiians and Pacific Islanders, studying health conditions and disease burden that are unique and common for this population.

WHI and MOSAAIC at Fred Hutch is seeking a software developer to join its Database and Applications Unit. This Unit supports the core WHI and MOSAAIC studies as well as dozens of ancillary studies. Our mission is to collect and maintain the highest quality data in support of this important research, from application design through the delivery of analytic data sets. Salary is commensurate with experience.

Software Development Engineer II - Intermediate level position that works on moderately complex projects and assignments.

This role will have the opportunity to work partially at our campus and remotely. This position is a hybrid role with a minimum three days per week at our South Lake Union campus.

Design, develop, and maintain database-driven applications and data management solutions to support research study operations.
• Develop, optimize, and maintain Oracle SQL, PL/SQL, and PostgreSQL database objects, including stored procedures, functions, views, packages, and queries.
• Collaborate with researchers, analysts, data managers, and study staff to translate research and business requirements into technical solutions.
• Ensure data quality, integrity, security, and performance across study applications and databases.
• Maintain, enhance, and refactor existing applications and database systems.
• Develop and execute testing plans for database and application changes.
• Troubleshoot production issues, identify root causes, and implement corrective actions.
• Support data collection, management, reporting, and delivery processes for WHI, MOSAAIC, and affiliated research studies.
• Create and maintain technical documentation.
• May be responsible for providing on-call support.
• Perform other responsibilities as assigned.

MINIMUM QUALIFICATIONS:

• Bachelor's degree in computer science or equivalent combination of education and experience.
• Minimum of 3-6 years of directly related experience.
• Strong analytical abilities and problem-solving skills.
• Proficiency with relational databases.
• Understanding of Object-Oriented Programming concepts, data structures and algorithms.
• Understanding of specific programming languages such as SQL, PL/SQL, PG/plSQL, Javascript, and React
• Other department-determined skills or experience may be required.

PREFERRED QUALIFICATIONS:

• Strong Proficiency in SQL Development, preferably in both Oracle and Postgres.
• Experience designing, developing, and optimizing complex SQL queries, stored procedures, functions, and database objects.
• Experience with database design principles, data modeling, data integrity, and performance tuning.
• Ability to understand business and research requirements and translate them into technical solutions.
• Experience supporting clinical research, public health, epidemiological, academic, or scientific research environments.
• Familiarity with clinical studies, longitudinal research studies, research data collection systems, or research data management workflows.
• Experience working with healthcare, clinical, or research datasets.
• Experience developing web applications using JavaScript, HTML, CSS, React, or Node.js.
• Familiarity with RESTful APIs and system integrations.
• Experience with Oracle Forms and Reports.
• Experience with statistical, scientific, or research-focused applications and databases.
• Experience working with source control systems such as Git.
• Strong communication and interpersonal skills.
• Ability to work effectively in a collaborative, multidisciplinary environment.

The annual base salary range for this position is from $99,486 to $157,227, and pay offered will be based on experience and qualifications.

This role will have the opportunity to work partially at our campus and remotely.

Although Fred Hutch is not sponsoring most H-1B visas at this time, candidates who already hold an H-1B sponsored by another organization and are currently in the U.S. may be eligible for this position.

Fred Hutchinson Cancer Center offers employees a comprehensive benefits package designed to enhance health, well-being, and financial security. Benefits include medical/vision, dental, flexible spending accounts, life, disability, retirement, family life support, employee assistance program, onsite health clinic, tuition reimbursement, paid vacation (12-22 days per year), paid sick leave (12-25 days per year), paid holidays (13 days per year), and paid parental leave (up to 4 weeks).