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 four consecutive years.
UW Information Technology 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.
The Enterprise Information, Integration & Analytics unit (EIIA) within UW-IT provides consistent and reliable architectures, guidelines, standards, tools, and services for analysis, design, integration, management, and delivery of institutional data. In addition, the EIIA group manages, develops and maintains institutional data resources, including the UW Enterprise Data Warehouse (EDW) and UW Enterprise Web Services (EWS), to provide information for decision-making through central business intelligence (BI) products and tools.
Within EIIA, the Data Integration team provides useful, timely, and reliable information to the UW. The Data Integration team brings together major University business systems and those who consume from them. The Data Integration team includes the University’s Enterprise Data Warehouse (EDW) and the cornerstone of complex system integrations, the Enterprise Integration Platform (EIP). Enhancing and expanding the EDW and EIP provides the opportunity to push technical boundaries while delivering enormous value to the UW.
The EDW group 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.
Bachelor’s Degree in Computer Science, Information Management or related field.
Four years’ experience in one or more of the following:
-ETL processing design, planning, testing, and production implementations.
-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.
•Experience with managing databases in source control in a multi-developer environments.
•Familiarity with Continuous Integration (CI) and Delivery (CD).
•Comfortable with Powershell in a complex, enterprise environment. Bonus if familiar with Pester of 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.
Req #: 153210