As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem solving skills and dedication to build stronger minds and a healthier world.
UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty. All of which has allowed the UW to be nationally recognized as a “Great College to Work For” for six consecutive years.
UW Dean of Medicine Information Technology is seeking a Database Engineer, Data Analyst.
This individual will be responsible for several aspects of data management to include: ETL, modeling and reporting on multiple business domains (Academic, Finance, Faculty, etc.). The Engineer / Analyst will be part of a newer team supporting existing data processes, integrating and migrating to modern technology. The position will advance our data culture by communicating effectively with business customers, learn and explain data opportunities, further develop, and enhance our data.
This position will serve a key role, working with Dean of Medicine or School of Medicine units, vendors, UW Information Technology (UW IT), UW Medicine Information Technology (UW Med ITS), internal business and technical staff to create strategies, design and maintain data architecture: internal & external stores, master data management, data acquisition & integration, data delivery platforms, data propagation & distribution, data access & providers, analytic environments, predictive modeling environments, database management systems and metadata repository & services.
The successful candidate will be responsible for supporting and enhancing these integrated systems and balance multiple competing priorities, clearly setting expectations while maintaining excellent customer relationships.
This position will administer information systems and deliver data upon which School of Medicine (SoM) business processes are dependent. They will interact or deliver work to the UW community including staff, faculty, students, and residents so they can read, use and act on data to interpret results, gain insight, understand opportunities, increase efficiencies, improve quality and align with our mission to improve public health, advance medical knowledge and prepare tomorrows health professionals.
Develop and maintain databases, data models, ETL, reports, data visualization, and business intelligence solutions.
Research, strategize, and write proposals to advance existing systems and manage new requirements.
Provide best practices and guidance on all aspects of reporting to include: future plans, products, security, privacy compliance, technology, training, design, implementation, support, vendor and customer relationships, future dashboards, analytics, ad-hoc, mobile, cloud options, ETL tools, and research trends.
Provide DBA support: auditing; application integration; backup and recovery; capacity planning; change management; database application development; data modeling and design; developing and maintaining best practices; high availability; installing, configuring, patching and upgrading SQL server software; load balancing; maintaining documentation; periodic database maintenance; managing dev and test environments; monitoring; performance tuning; data protection; replicating data; security; scripting; ETL; testing; training; troubleshooting; vendor relations; and working with teammates.
Foster and maintain excellent relationships with a wide variety of internal, external business and technical partners.
Attend unit-wide meetings; advance technical and professional skills through continuing education, mentoring programs or personal study; and research and maintain knowledge of new technologies for departmental use.
Bachelor’s degree in computer science, information management or related field or equivalent experience.
Five years' of business intelligence analytics experience to include deploying dashboards, paginated reports, and preparing visuals/analysis.
Five years SQL development experience using Transact SQL.
Knowledge of relational and multi-dimensional reporting database schema designs.
Experience in data modeling, Tabular, MDX, DAX or SQL row and column level security.
Experience with an ETL technology (ex. SSIS).
Experience working with reporting technologies such as Crystal, Business Objects, Tableau, Power BI, or Reporting Services.
Experience with data cleansing and/or ensuring data integrity.
Some experience with Java, C#, Python, R script or M query.
Strong problem solving skills, investigating and resolving issues.
Demonstrated ability to work with minimum supervision as an individual contributor to projects and daily work.
Strong sense of focus and attention to detail, flexibility, self-motivation, organizational skills, excellent written/oral communication skills, and ability to adapt to a range of technical and non-technical audiences.
Equivalent education/experience will substitute for all minimum qualifications except where there are legal requirements such as license/certification/registration.
Two or more years of experience working in higher education, research, or health services organizations.
Experience working in virtual servers, containers, or cloud computing (such as Azure, AWS, or serverless computing) environments.
An understanding of contemporary IT systems, network infrastructure and their interdependencies.
Experience working with HIPAA, FERPA and GDPR data.
CONDITIONS OF EMPLOYMENT
Occasional evening and weekend work to meet deadlines.
Periodic daytime travel (often possible via UW transportation means) to/from various UW and client location.
Application Process: The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select “Apply to this position”. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your “My Jobs” page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.
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.