DATABASE DEVELOPER

Notes: As a UW employee, you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position, click here.

If you would like to find out more about what it is like to work for UW-IT, as well as to get a feel for our culture and our people, visit us at our employment website.

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.

UW Information Technology (UW-IT) is the central IT organization for the University of Washington, providing critical technology support to all three campuses, UW medical centers and global research operations. UW-IT collaborates with University partners to advance teaching, learning, innovation and discovery at the UW. Information Management (IM) within UW-IT provides University-wide leadership in the development and management of UW’s major administrative business systems, including Finance, Human Resources/Payroll, Advancement and Facilities. This division is also responsible for the UW Enterprise Data Warehouse and business intelligence tools that provide information for decision making.

The Enterprise Data Integration unit (EDI) within IM provides consistent and reliable architectures, guidelines, standards, tools, and services for analysis, design, integration, management and delivery of institutional data. Within EDI, the Enterprise Data Platform (EDP) group manages, develops and maintains institutional data resources in order to provide useful, timely, and reliable information to the UW. The EDP brings together major University business systems and those who consume from them. The EDP includes the University’s Enterprise Data Warehouse (EDW) and Enterprise Web Services (EWS). Enhancing and expanding the EDW and EWS provides the opportunity to push technical boundaries while delivering enormous value to the UW.

The EDW seeks a Database Developer with strong SQL skills who innovates, designs, executes, and supports the unit's data projects.

The Database Developer is responsible for:

Delivering data for a variety of data integration projects

Producing and testing code for ETL frameworks

Performance tuning SQL queries and databases

Streamlining and automating operations

Ensuring data assets are well managed

Maintenance and production support activities

Based on candidate skills this position may also contribute to and support infrastructure projects, large-scale database migrations, cloud service design and implementation, data security projects, and web development.

This position offers the unique opportunity to join a professional, experienced, fun team creating central resources for the University as we continue to expand our content and services.

REQUIREMENTS:

Bachelor’s Degree in Computer Science, Information Management, Engineering or related field or experience.

Four years’ experience in two or more of the following:

ETL processing design, planning, testing, and production implementations.

Expert level capabilities in Transact-SQL, stored procedure development, query optimization, and tuning.

Automating SQL Server with PowerShell.

Data warehousing experience.

Experience developing and owning solutions in large scale, complex enterprise environments.

Demonstrated ability to develop and deliver creative solutions to meet business needs.

Enthusiasm for innovating.

Tenacity towards investigating and resolving issues.

Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilities.

Strong problem solving skills.

Ability to work independently.

Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.

DESIRED:

Experience with managing databases in source control in multi-developer environments.

Familiarity with Continuous Integration (CI) and Delivery (CD).

Working knowledge of NET, JQuery, Javascript, JSON, or XML

Comfortable with Powershell in a complex, enterprise environment. Bonus if familiar with Pester or other Powershell unit testing framework

Advanced practical experience with data warehouse industry standards and patterns.

Familiar with cloud technologies (AWS, Azure) and their client libraries (AWS Tools for PowerShell, Azure management cmdlets).

Experience with ETL toolsets such as SQL Server Integration Services (SSIS), WhereScape Red, Talend, or Penopto.

Familiarity with BI tools, such as Power BI, Analysis Services (SSAS), Reporting Services (SSRS) or Tableau Server.

Knowledge of agile software development lifecycle methods and processes.

Ability to train, mentor, and guide others to learn complex technical skills.

Experience in a major research university setting.
:

Hybrid open office environment (one to four days per week) and work from home.

Open office environment.

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.

Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law.

Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.

The University of Washington is a leader in environmental stewardship & sustainability, and committed to becoming climate neutral.

The University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, or genetic information.

To request disability accommodation in the application process, contact the Disability Services Office at +91-XXXXXXXXXX or dso@uw.edu.

COVID-19 VACCINATION REQUIREMENT

Governor Inslee's Proclamation 21-14.2 requires employees of higher education and healthcare institutions to be fully vaccinated against COVID-19 unless a medical or religious exemption is approved. Being fully vaccinated means that an individual is at least two weeks past their final dose of an authorized COVID-19 vaccine regimen. As a condition of employment, newly hired employees will be required to provide proof of their COVID-19 vaccination. View the Final candidate guide to COVID-19 vaccination requirement webpage for information about the medical or religious exemption process for final candidates.