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 a Data Modeler!
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 Campus (UWMC-Montlake), UW Medical Center-Northwest Campus (UWMC-NW), Valley Medical Center (VMC), UW Neighborhood Clinics (UWNC), 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 Data Operations Manager, the primary focus of the Data Modeler 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 Analytics Group has a dual report into both ITS and UW School of Medicine and provides operational oversight for the major analytics platforms and tools at UW Medicine, and is a key support function as UW Medicine transitions towards value based health care. Within this Group, the Analytics DataOps Team is responsible for the end to end platforms supporting the data solutions we provide for enterprise data warehouse, reporting, analytics related data extracts, visualization and decision support. The platforms include Epic Cogito, Microsoft SQL Server, reporting tools, BOE and Tableau, with ongoing efforts to consolidate and simplify this stack.
The Data Modeler (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.
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.
This position will collaborate with customers, management/leadership and a team of Analytics analysts, data architects and developers along with the partners of UW Medicine to to translate business rules into usable conceptual, logical, and physical models and database designs, identify and analyze data flaws, develop and integrate solutions, and maintain data models and architecture. The data models will support applications used in the daily work of practitioners, clinicians, faculty, students and UW Medicine staff.
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.
Work 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.
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.
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. Present the model specification in design review meetings.
Analyze the SQL queries used to produce current data marts to integrate new build with existing infrastructure. Work with senior architects to plan data mart extensions or the creation of new data marts as appropriate
Implement extensions to existing data marts using a SQL query-based data warehouse development tool. Work with senior architects to implement new data mart components as required.
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.
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%)
Utilizes 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.
Coordinates with Business Analysts, Data Architects, Structured Query Language (SQL) Administrators, BI Administrators, and technology professionals to understand and document technical requirements, capabilities, and limitations.
Works as part of a large team and works towards shared business and department goals.
Responsible for 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.
Works independently on assigned tasks with minimal assistance.
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.
Bachelor's degree in Computer Science, Information Systems, or related field or equivalent combination of education/experience.
4+ years experience must include the following:
2+ years' experience supporting developers using enterprise reporting tools (examples are MS PowerBI, Tableau and/or Business Objects).
2+ years' experience with any version of SQL. The data warehouse tools we use are SQL based, not drag and drop tools. Working in this environment requires SQL fluency.
Minimum of one Epic Data Model certifications, or completion within first 6 months of employment.
Experience with a formal Data Modeling methodology.
The successful candidate will also possess:
Values consistent with those of UW Medicine's mission to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow's physicians, scientists, and other health professionals.
Proven customer service orientation with a history of delivering high quality products on time.
Excellent written and oral communication abilities with the ability to convey a positive and professional image in person, on the telephone and in correspondence.
Ability to translate complex issues into comprehensible ideas and concepts with both technical and non-technical staff. This position works with data consumers who are often not IT professionals and requires the ability to describe requirements, models and specifications efficiently, clearly, precisely and in a manner that is readily understood both by data consumers and other data architects and developers.
Strong interpersonal skills with the ability to work effectively with a diversity of personalities while forging effective partnerships.
Flexibility with proven ability to conform to shifting priorities, demands, and timelines through analytical and problem-solving capabilities.
Strong organizational, multitasking, and collaboration skills in various work environments including complex, matrix environments with proven attention to detail.
Proven ability to work creatively and analytically in a problem-solving environment demonstrating teamwork, innovation, and excellence.
Self-motived, action oriented and results driven with ability to adapt to change. This position requires working with data that is often complex, confusing, noisy and of heterogenous data quality. Working towards an acceptable model often requires problem-solving skills, creativity and persistence.
Proven ability to work in an ambiguous environment and collaborate across multiple areas in order to achieve a common business objective.
Decisiveness in resolving business problems, making decisions, and identifying priorities.
Must be able to learn, understand, and apply new technologies.
Previous experience in and knowledge of healthcare systems.
Experience with Business Objects Enterprise/Crystal Reports.
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, UWNC, 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.
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.