The Seattle Cancer Care Alliance (SCCA), 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 Manager, the Data Engineer is responsible for developing BI solutions for the Enterprise Data Warehouse in the Microsoft stack of SQL tools. This includes designing and implementing strategies for new data acquisition, data distribution, and workflow orchestration as the data warehouse expands its offerings into AWS. The role will also be responsible for 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 Engineer will analyze and profile data to design, implement, and test procedures, packages, and processes to meet business needs.
Data are acquired and distributed in a number of different ways and will require a willingness to learn and troubleshoot multiple systems, old and new. The Data Engineer 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 team, the Data Engineer will participate in daily and weekly meetings to coordinate efforts.
Additional responsibilities include the ability to:
Work with analyst partners to understand their information needs and business requirements
Work with teammates to design and build new infrastructure on MS stack and (eventually) AWS
Work with SDET to perform end-to-end data analysis and ensure data quality gaps are identified
Communicate and resolve issues and questions during development, testing, and release of new code
Collaboratively work with other members of the Data Warehouse team, IT and Business partners
Mentor team members
Work on multiple projects in parallel
5+ years of demonstrated data warehousing & business intelligence experience
Minimum 5 years development experience using T-SQL
Ability to manage business expectations and deliver customer-focused solutions
Experience translating business challenges into flexible/extensible/simple and elegant solutions
Strong analytical and organizational skills and an ability to multi-task
Strong understanding of database design
Ability to work independently and to adapt to new and changing technologies
Excellent written and verbal communication skills
Programming skills in PowerShell and/or C#
Strong understanding of Visual Studio Solutions and Projects
Experience using AWS for data processing
SQL Server indexing and performance tuning
Understanding of HIPAA regulations
Familiarity with diverse kinds of healthcare and/or clinical data
Experience with Cerner and/or Epic healthcare systems
Familiarly with the Systems/Software Development Life Cycle
Experience with Agile software development
We are committed to cultivating a workplace in which diverse perspectives and experiences are welcomed and respected. We are proud to be an Equal Opportunity and VEVRAA Employer. We do not discriminate on the basis of race, color, religion, creed, ancestry, national origin, sex, age, disability, marital or veteran status, 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 firstname.lastname@example.org or by calling 206-667-4700.
At Fred Hutchinson Cancer Research Center, teams of world-renowned scientists and humanitarians work together to prevent, diagnose and treat cancer, HIV/AIDS and other diseases. Researchers are discovering new ways to detect cancers earlier, improve treatments, and learn how to prevent cancers from growing. Although Fred Hutchinson opened its doors in 1975, its history began about 20 years before that. In 1962 Fred Hutchinson envisioned a center devoted to studying cancer, a disease that took his brother’s life. Today Fred Hutchinson is contributing to the next waves of breakthrough treatments and prevention strategies. Fred Hutchinson collaborates with the Seattle Cancer Alliance, the National Cancer Institute, and the University of Washington.