Fred Hutchinson Cancer Research Center & Seattle Cancer Care Alliance

  • Data Warehouse Developer

    Job ID
    11443
    Type
    Regular Full-Time
    Company
    Seattle Cancer Care Alliance
    Location
    US-WA-Seattle
  • Overview

    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.

    Responsibilities

    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:

    • Work with analyst partners to understand their information needs and business requirements
    • Collaborate in the planning and design of new and existing BI solutions
    • Perform end-to-end data analysis and ensure data quality gaps are identified
    • Communicate and resolve issues and questions during the development, testing, and roll-out of BI solutions
    • Collaboratively work with other members of the Data Warehouse team, IT and Business partners
    • Mentor team members
    • Work on multiple projects in parallel

    Qualifications

    Required:

    • 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 physical database design and modeling
    • Ability to work independently and to adapt to new and changing technologies
    • Ability to communicate in English, both verbally and in writing

    Desired:

    • Programming skills in C# and/or PowerShell
    • Strong understanding of Visual Studio Solutions and Projects
    • Experience AWS or other cloud platforms and technologies
    • 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, preferably Scrum

    Our Commitment to Diversity

    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 escmail@fredhutch.org or by calling 206-667-4700.

    Options

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