The Seattle Cancer Care Alliance, located in Seattle, Washington, is part of a dynamic collaboration among three organizations known nationally and internationally for their patient care and research: Fred Hutchinson Cancer Research Center, University of Washington, and Seattle Children's. Over the past 25 years, these institutions have worked together to support their mission of adult and pediatric oncology patient care services, research and education
The Data Warehouse Team within SCCA Information Technology is responsible for designing, developing and supporting SCCA data systems and integration for both operational and analytical purposes.
Under the guidance of the Data Warehouse Supervisor, the Data Warehouse Developer is responsible for developing BI solutions for the Enterprise Data Warehouse in the Microsoft stack of SQL tools. The role will consist of transferring and integrating data into the DW from source systems as well as partner data warehouses and repositories. In collaboration with team members, the Data Warehouse Developer will analyze and profile data to design, implement, and test procedures, packages, and processes to meet business needs.
Data may be acquired and distributed in a number of different ways and will require a willingness to learn and troubleshoot multiple systems. The Data Warehouse Developer will work with team members, end users, and other stakeholders to provide solutions with minimal operational disruption and high data integrity. As a member of an agile scrum team, the Data Warehouse Developer will participate in daily and weekly meetings to coordinate efforts during each sprint.
Additional responsibilities include the ability to: