Career Services

By John Stabinger
Posted on 2 April 2020 | 2:40 pm
Alumni / Benefits & Services / Alumni Career Services

Alumni Career Services


Job Seeker Employer
Job Seekers, Welcome to ALUMNI CAREER CENTER
SR. DATA SCIENTIST
University of Washington
SAVE savedJobs
false
SAVE savedJobs

SR. DATA SCIENTIST

University of Washington

Email Print
Application
The application opened in a new tab.
By using this feature you agree to our Terms and Conditions and Privacy Policy.
Details
Posted:
May 13, 2022
Location:
Seattle, Washington
Salary:
Open
Type:
Full Time
Category:
Healthcare

A higher degree of healthcare.

All across UW Medicine, our employees collaborate to perform the highest quality work with integrity and compassion and to create a respectful, welcoming environment where every patient, family, student and colleague is valued and honored.

UW Medicine’s IT Services department has an outstanding opportunity for an Sr. Data Scientist!

UW Medicine’s Information Technology Services (ITS) department is a shared services organization that supports all of UW Medicine.  UW Medicine is comprised of Harborview Medical Center (HMC), UW Medical Center-Montlake (UWMC-Montlake), UW Medical Center-Northwest (UWMC-NW), Valley Medical Center (VMC), UW Primary Care (UWPC), UW Physicians (UWP), UW School of Medicine (SOM) and Airlift Northwest (ALNW).  In addition, UW Medicine shares in the ownership and governance of Children’s University Medical Group and Seattle Cancer Care Alliance (a partnership between UW Medicine, Fred Hutchinson Cancer Research and Seattle Children’s).  ITS is responsible for the ongoing support and maintenance of the infrastructure and applications which support all of these institutions, along with the implementation of new services and applications that are used to support and further the UW Medicine mission.

In collaboration with UW Medicine IT Services (ITS) and under the general guidance of the Manager, Analytics Data Operations, the primary focus of the Sr. Data Scientist is to work with customers to understand and translate business requirements into an efficient logical and physical data model, then manage the data model version control and change control.
 
The Sr. Data Scientist (1) plans with vision and foresight to provide high quality data, (2) identifies and defines common data requirements, and (3) designs conceptual structure and plans to the the current and long-term data requirements of UW Medicine constituents and in doing so.

Areas of responsibility include, but are not limited to:
  • understanding and defining information needs;
  • developing and maintaining data models through analysis and solution design, detailed data design, data model and design quality management and data implementation;
  • analyzing and aligning with other business models; and
  • defining and maintaining data technology architecture, data integration architecture, data warehouse (DW)/business intelligence (BI) architecture, taxonomies and namespaces, and meta-data architecture.

    • The Sr. Data Scientist will perform “advanced to complex” level work responsibilities, which are defined by being a lead resource for small to medium scale project and performing progressively more complex production tasks, including mentoring more junior staff as well as “advanced to complex” analytics solutions development and project work. This includes being the lead Sr. Data Scientist resource for multiple projects with durations longer than 3-months, and level of effort estimate of 500 or more hours per project. These projects should have increased visibility and impact at the department leadership level.

    The Sr. Data Scientist will work closely with customers and a team of Analytics analysts. data architects and developers to translate business rules into usable conceptual, logical, and physical models and database designs.

    This position must be able to work independently and within a team environment managing multiple priorities in a fast-paced environment.

    RESPONSIBILITIES

    Provide Advanced to Complex Data Modeling, Analysis, and Solution Design (30%)
  • Understand and translate business needs into data models supporting long-term solutions.
  • Implement data strategies, build data flows and develop conceptual data models with the Application Development team.
  • Collaborate with analytics solution consumers, business analysts and developers to create initial model requirements (grains, additive and non-additive measures, conformed attributes, etc.). 
  • Troubleshoot data anomalies and performance issues that arise during design and development. Assist DBAs in troubleshooting poorly performing reports and poorly performing extraction, transformation and loading (ETL) code.  Work with ETL developers to identify areas for improvements in ETL infrastructure.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Validate business data objects for accuracy and completeness.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Develop data models according to company standards.
  • Optimize and update logical and physical data models to support new and existing projects.
  • Recommend opportunities for reuse of data models in new environments.
  • Understand and implement effective customer-focus solutions using the Epic Caboodle data model.

    • Provide Advanced to Complex SQL Development (25%)
  • Perform discovery and prototype work in SQL, and work with data consumers to proceed from initial models and requirements to an actionable specification that meets the user’s needs. Lead design review meetings and other Sr. Data Scientists in reviewing specification for new models.
  • Analyze the SQL queries used to produce current data marts to integrate new build with existing infrastructure.  Plan data mart extensions and the creation of new data marts as appropriate.  Assist junior architects in planning appropriate extensions of existing data marts.
  • Implement extensions to existing data marts using a SQL query-based data warehouse development tool. Assist junior architects in implementing new data mart components, possibly taking over development of more complex components.
  • Develop of SQL databases for a wide variety of applications and business uses, including backend data for web applications, data storage, and relational databases.
  • Use data architecture and management to develop and scale SQL databases based on their departmental needs.
  • Write and optimize SQL queries to store, sort, and retrieve data for basic and complex commands to retrieve and manage data across multiple tables.
  • Analyze existing SQL queries for performance improvements.
  • Continually seek out methods to better handle data and increase system efficiency by writing more complex and optimized queries, changing the way data is stored or structured, or bringing data onto a new server that can better meet the needs of the organization.
  • Propose and develop new methodologies, suggest new queries, and institute best practices to further enhance database performance.

    • Provide Advanced to Complex Data Model and Design Quality Management (20%)
  • Maintain conceptual, logical and physical data models along with corresponding metadata.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
  • Review modifications to existing software to improve efficiency and performance.
  • Examine new application design and recommend corrections if required.

    • Planning and Documentation (20%)
  • Utilize industry best practices, creating and documenting best practices and technical requirements.
  • Understand and ensure effective enterprise-level communication about the Epic Caboodle data model/product roadmap, including connections and impacts to other Epic and Analytic platform solutions/tools.
  • Coordinate with Business Analysts, Data Architects, Structured Query Language (SQL) Administrators, BI Administrators, and technology professionals to understand and document technical requirements, capabilities, and limitations.
  • Manage modest internal projects as required, including, planning, facilitating project meetings and managing projects from start to finish. 
  • Contribute to a large team and work towards shared business and department goals. Collaborate with the project management teams to satisfy requirements for modest projects internal to the team.
  • Contribute to all project planning related to data modeling tasks including effort and completion date estimates.
  • Perform and complete all tasks in the agreed upon time lines.

    • Other (5%)
  • Support data warehouse infrastructure operations as part of an on-call rotation. 
  • Participate in all aspects of improving the team, including education/training of other team members and contributing to process/communication improvement initiatives.
  • Work with manager to set professional goals for career development.           
  • Act as back-up for other team members and functions, as needed.

    • REQUIREMENTS

  • Bachelor's degree in Computer Science, Information Technology, Business Administration, or related field or equivalent combination of education/experience.

    • 6+ years’ experience must include:
  • Currently holds two or more current Epic certifications (or equivalent with other EHR systems) OR has obtained Epic proficiency (or equivalent) and has consistently demonstrated technical competencies for 4+ years in relevant/functional business area.
  • 6+ years recent IT experience.
  • 5+ years' experience with Business Objects Enterprise and/or Crystal Reports.
  • Extensive experience leading small to medium scale projects with SQL. The data warehouse tools we use are SQL based, not drag and drop tools.  Working in this environment requires SQL fluency. 
  • 5+ years’ experience with Epic Clarity Clinical Data Model and Reporting.
  • Extensive experience leading small to medium scale projects through the complete report development lifecycle.Extensive understanding of Data Modeling best practices.
  • Extensive subject matter domain expertise.  Functioning independently in this position requires deep domain expertise in several data domains and developing additional subject matter expertise as need to support other team members.
  • Extensive understanding of basic principles of data normalization/ denormalization, abstraction and dimensionality as interface, etc.
  • Extensive knowledge of optimizing and troubleshooting database development for performance, including analyzing query statistics and knowledge of how data in a relational database is stored, retrieved and processed.
  • Extensive experience in project management.

    • DESIRED

  • Previous experience in and knowledge of academic healthcare systems and/or operational environments.
  • Advanced degree (e.g., Master’s, PhD, etc.)
  • Experience with formal agile project management methods desirable.

    • CONDITIONS OF EMPLOYMENT

  • This is an Information Technology deadline-driven work environment.
  • Program operates within the confines of standard IT methodology: Design Review, IT Project Management, Change Control, Risk Assessment, and Code Management.
  • The individual in this position is expected to work normal daytime hours. The majority of work is performed in an office environment during normal business hours or by telecommuting with manager approval; however, significant off-hours and weekends may be needed to resolve problems and respond to emergencies. This individual is expected to be available for emergencies (business continuity/disaster recovery efforts) on a 24x7 basis as needed.
  • Must have the ability to meet in person as directed by manager.
  • Because of the physically separated sites for UW Medicine, this position requires the ability to travel to alternative work locations as needed.
  • Interacts with a variety of individuals within UW Medicine and ITS specifically.
  • Must coordinate projects without direct supervisory authority.
  • Must work within the constraints of multiple technical environments.
  • ITS provides services to all UW Medicine organizations – HMC, UWMC-Montlake, UWMC-NW, VMC, UWPC, UWP, SOM, and ALNW.  The individual in this position must learn many organizational structures and cultures and continually foster collaboration.
  • Ability to communicate effectively in English, both verbally and in writing.

    • #monster

    Internal Number: 198846
    About University of Washington
    Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.
    More Jobs from This Employer
    BACK TO TOP
    false
    Help is on the way!
    We're sorry you are having trouble applying for this job.

    Please try loading this job using the following link before submitting your help request:
    Powered By Naylor Association Solutions