The vision of Biomedical Informatics and Data Science (BIDS) is to develop enterprise-level, consolidated information technology infrastructure that will provide exceptional IT capabilities to the National Cancer Institute (NCI) in support of basic, translational, and clinical cancer and AIDS research. The Biomedical Applications Development Center (BADC) is part of BIDS and is primarily involved in developing informatics system to support precision medicine initiatives. Specifically, BADC provides modern cloud architectures, computer science, informatics, bioinformatics, data warehousing, data science, and help desk support for the enterprise applications developed in support of precision medicine. KEY ROLES/RESPONSIBILITIES-THIS POSITION IS CONTINGENT UPON FUNDING APPROVAL This career requires the successful candidate to use modern cloud technologies to create Star Schemas for data warehousing and relational data modeling to create 3rd normal form (3NF) OLTP databases for use in a MySQL and/or PostgresSQL environments, namely RedShift and Aurora. These schemas will be used to support the reporting needs of the Data Science and Bioinformatics teams in the creation of Pharmaceutical Reports, Genomic Reports, Trial Reports, and various other reports needed for the successful conduction of clinical trials. Further, strong knowledge of Extraction, Transformation and Loading (ETL) techniques will be required for the moving of data from the OLTP and OLAP schemas. BASIC QUALIFICATIONS Possession of a Bachelor's degree from an accredited college or university (according to CHEA) in a STEM field including Computer Science, Programming, Software Engineering, Mathematics, Database, or other Engineering Field is required. (Additional qualifying experience may be substituted for the required education). Foreign degrees must be evaluated for US equivalency In addition to the educational requirements, a minimum of six (6) years of data management experience Strong programming/scripting skills with demonstrated experience Must be able to maintain a security clearance Familiarity with interactive databases and data validation Must be detail oriented with strong analytical skills and the ability to prioritize multiple tasks/projects Strong problem solving, planning, and organizational skills Ability to work effectively within a team configuration Ability to exercise judgment within broadly defined practices and policies in selecting methods, techniques and evaluation criteria for obtaining results Ability to create schemas using 3NF and Star Diagramming practices Proficient in SQL and another programming language PREFERRED QUALIFICATIONS Possession of a Masters' degree from an accredited college or university (according to CHEA) in the Life in a STEM field including Computer Science, Programming, Software Engineering, Mathematics, Database, or other Engineering Field is required. Experience with AWS Cloud technologies including RedShift and Aurora Proficient in Python Experience with clinical and genomic data Experience with cancer research data/projects Knowledge of statistical methods and analysis Other Clinical job experience Equal Opportunity Employer (EOE) | Minority/Female/Disabled/Veteran (M/F/D/V) | Drug Free Workplace (DFW)