MSK is looking for candidates who are passionate about data and excited to help create a world class oncology data infrastructure in support of MSKs mission to control and cure cancer. The right individual will have a deep understanding of large scale Data Warehousing environments and the ability to apply this knowledge to implement and solve diverse data-centric healthcare use cases.
The Enterprise Data Group is seeking a Data Warehouse Developer experienced in data warehousing development. The candidate will support DataStage ETL development, data analysis and querying utilizing SQL, and be able to work with data governance tools to integrate ontologies into a robust enterprise data architecture. This candidate will apply Agile software development methodologies to facilitate project developments.
Collectreq uirements; analyze the raw data; participate in creation of the logical design; work with DBAs on the physical design, code of the ETL processes.
System testing, participation in User Acceptance Testing (UAT) and implementation of the process.
Adhere to the project developmentlifecyclemethodology and for every developmentprojectproduce necessary documentation that will include plans, diagrams, data dictionaries, etc.
Participate in off hours production support on revolving basis.
Respond to scheduled and ad hoc requests for off hours resolution of production problems.
BS or BA degree in Computer Information Science or related field.
One or more years working full time in an organization supporting data warehousing environment
Strong working knowledge of SQL, working knowledge of DataStage ETL tool with an ability to deliver efficient, reliable and error-free code, some exposure to database design both relational (3rd form) and star schema, some exposure to UNIX (AIX),strong ability to interrogate and analyze data, knowledge of MS Office tools (Outlook, PowerPoint, SharePoint, Visio, Project)
Strong working knowledge of Data Governance products (Informatica or IBM) and integration of Data Governance with ETL tools is required
Working experience with healthcare applications is preferred
Working knowledge of programming languages such as Python or Java is a plus
Exposure to Agilesoftware development methodologies such as Scrum would be valuable
Very good written and verbal communication skills, ability to plan and follow established plans, ability to follow established guidelines and policies.
While the position is 9 to 5, it will require periodic and ad hoc off hours support including weekends and holidays.
Internal Number: 2019-29452
About Memorial Sloan-Kettering Cancer Center
As one of the world's premier cancer centers, Memorial Sloan-Kettering Cancer Center is committed to exceptional patient care, leading-edge research, and superb educational programs. The close collaboration between our physicians and scientists is one of our unique strengths, enabling us to provide patients with the best care available today as we work to discover more effective strategies to prevent, control, and ultimately cure cancer in the future. Our education programs train future physicians and scientists, and the knowledge and experience they gain at Memorial Sloan-Kettering has an impact on cancer treatment and the biomedical research agenda around the world.