Software Development Engineer II – WHI/MOSAAIC
About the Organization
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. The center is renowned for global leadership in bone marrow transplantation, HIV/AIDS prevention, immunotherapy, and COVID-19 vaccines, earning a reputation as one of the world’s leading cancer, infectious disease, and biomedical research centers.
Fred Hutch operates eight clinical care sites offering medical oncology, infusion, radiation, proton therapy, and related services, with network affiliations across five states. The Women’s Health Initiative (WHI), established by the NIH in 1991, is one of the largest and most comprehensive studies of women’s health, investigating strategies to prevent and control common causes of morbidity and mortality among postmenopausal women. The WHI Clinical Coordinating Center (CCC) at Fred Hutch manages study implementation, data collection, and analysis. Additionally, Fred Hutch coordinates the MOSAAIC CC, a new NIH program focusing on a population-based cohort of Asian Americans, Native Hawaiians, and Pacific Islanders.
About the Role
WHI and MOSAAIC at Fred Hutch is seeking a Software Development Engineer II to join its Database and Applications Unit. This intermediate-level position supports the core WHI and MOSAAIC studies, as well as dozens of ancillary studies, by designing, developing, and maintaining database-driven applications and data management solutions. The role is hybrid, requiring a minimum of three days per week at the South Lake Union campus.
Responsibilities
- 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.
- Provide on-call support as needed.
- Perform other responsibilities as assigned.
Requirements
- 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.
- Proficiency in 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.
Pay
The annual base salary range for this position is from $99,486 to $157,227, with pay offered based on experience and qualifications.
Benefits
- Medical, vision, and dental insurance.
- Flexible spending accounts.
- Life and disability insurance.
- Retirement plans.
- 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).
- Paid parental leave (up to 4 weeks).
Schedule
This is a hybrid role with a minimum of three days per week required at the South Lake Union campus.