Software Development Engineer II – WHIMOSAAIC

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 worlds 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 worlds 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)establishedthe Womens Health Initiative (WHI) in 1991 to address the most common causes of deathdisabilityand impaired quality of life in postmenopausal women.

The Womens Health Initiative (WHI) is one of the largest and most comprehensive studies of womens health and is at the forefrontinwomens health study results have been published in top medical journals and have had a significant impact on womens 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)locatedat Fred Hutchinsonis responsible forstudy implementation and coordination of statistical epidemiologicnutritionaland clinical aspects of the WHI andis responsible fordata collectionmanagementand addition to the WHI CCC NIH has recently launched a program for a new coordinating center(MOSAAIC CC)andFred Hutch has been chosen to coordinate this national effort. Theobjectiveis to provide scientific statistical and culturalexpertiseand coordination support toestablisha 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 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 iscommensurate 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 andmaintaindatabase-driven applications and data management solutions to support research study operations.
• Develop optimize andmaintainOracle 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 issuesidentifyroot causes and implement corrective actions.
• Support data collection management reporting and delivery processes for WHI MOSAAIC and affiliated research studies.
• Create andmaintaintechnical documentation.
• Maybe responsible forproviding on-call support.
• Perform other responsibilities as assigned.

MINIMUM QUALIFICATIONS:

• Bachelors 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 .
• 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 communicationand interpersonal skills.
• Ability to work effectively in a collaborative multidisciplinary environment.

The annual base salary range for this position is from $99486 to $157227 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).