Dataset Developer II

Job ID
Regular Full-Time
Information Technology


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. These values are grounded in and expressed through the principles of diversity, equity and inclusion. 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. Fred Hutch is in pursuit of becoming an anti-racist organization. We are committed to ensuring that all candidates hired share our commitment to diversity, anti-racism and inclusion.


The Statistical Center for HIV/AIDS Research and Prevention (SCHARP) at Fred Hutch is a full service statistical and data management center focused on HIV prevention research. SCHARP has an annual budget of over $40 million, more than 180 employees and is currently managing over 40 active phase I – III clinical trials in over 150 clinical sites around the world. SCHARP is seeking a Dataset Developer II.


The Dataset Developer II is responsible for and leads the development of protocol and enterprise level standard datasets in SCHARP’s clinical data warehouse. SCHARP Dataset Developers use extract, transform, and load (ETL) and other data management processes and tools to develop datasets to support Programming, Analytics, and Reporting team requirements.


Responsibilities may include:


  • Independently implement and oversee enterprise-wide and study-specific derived datasets in SCHARP’s data warehouse using configurable transformation and other languages.
  • Collaborate with data standards analysts, programmers, data architects, reports analysts, statisticians and the data governance and data security team in the development and documentation of standard datasets used for reporting and analysis
  • Apply and adhere to CDISC data standards and guidelines where required in the production of reporting datasets and interpret and implement (SDTM) dataset specifications provided by data standards analysts or data services team members
  • Implement and provision reporting datasets to report analysts, programmers and statisticians for use in a Report Mart
  • Oversee and perform data cuts, data freezes, and study snapshots in SCHARP’s data warehouse using Python.
  • Collaborate with SCHARP software developers to report defects and suggest improvements to the data warehouse and associated systems
  • Set up, test and maintain version control of standard datasets in the central data warehouse system
  • Develop and document standard practices for implementing or modifying derived datasets to be used by all dataset developers.
  • Collaborate with the data standards and data governance teams on naming data objects (schemas, datasets) in the data warehouse
  • Oversee the curation of schemas, snapshots, and initial data permissions in the data warehouse.
  • Contribute to development and editing of applicable work instructions and standard operating procedures
  • Lead and/or supervise more junior dataset developers as necessary
  • Perform other duties as required.


Minimum Qualifications

  • Bachelor’s degree in computer science, or a scientific, technical, or health-related field, or a combination of commensurate education and work experience
  • At least 5 years of experience building and maintaining datasets, tables, or views within a database.
  • At least 2 years of experience working in an Extract-Load-Transform (ELT/ETL) system such as SQL Server Integration Services (SSIS), WhereScape Red, Talend, or Pentaho.
  • Strong knowledge of relational databases including tables, views, data types, and keys.
  • Knowledge of CDISC data standards, specifically SDTM
  • Experience with declarative operations such as writing data transformations such as filters, merges, and maps
  • Experience using a programming or scripting language such as Python
  • Experience querying databases using a query language such as SQL
  • Experience using a version control system such as Subversion
  • Ability to read and comprehend specifications
  • Excellent verbal and written communication skills
  • Demonstrated ability to work independently and as part of a team

Preferred Qualifications

  • Master’s degree in computer science or a scientific, technical, or health-related field
  • Experience with an expression language such as JEXL
  • Experience with data interchange formats such as XML and JSON
  • Experience in good clinical data management practices in health research
  • Experience working in a regulated environment
  • Experience working with Software Development Life Cycle methods

Fred Hutchinson Cancer Center has a mandatory COVID-19 vaccine requirement, with exceptions only for approved medical or religious accommodations. As a condition of employment, newly hired employees must, prior to their first day of employment:
Provide proof of being fully vaccinated against COVID-19 ; OR
Initiate the accommodations process to request a religious or medical accommodation (medical accommodations require a healthcare provider’s certification).


A statement describing your commitment and contributions toward greater diversity, equity, inclusion, and antiracism in your career or that will be made through your work at Fred Hutch is requested of all finalists.

The annual base salary range for this position is from $91,936 to $145,318 and pay offered will be based on experience and qualifications.  


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), paid parental leave (up to 4 weeks), and partially paid sabbatical leave (up to 6 months).  

Our Commitment to Diversity

We are proud to be an Equal Employment Opportunity (EEO) and Vietnam Era Veterans Readjustment Assistance Act (VEVRAA) Employer. We are committed to cultivating a workplace in which diverse perspectives and experiences are welcomed and respected. We do not discriminate on the basis of race, color, religion, creed, ancestry, national origin, sex, age, disability (physical or mental), marital or veteran status, genetic information, sexual orientation, gender identity, political ideology, or membership in any other legally protected class. We are an Affirmative Action employer. We encourage individuals with diverse backgrounds to apply and desire priority referrals of protected veterans. If due to a disability you need assistance/and or a reasonable accommodation during the application or recruiting process, please send a request to our Employee Services Center at or by calling 206-667-4700.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed