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. The Enterprise Reporting and Analytics (ERA) team within UW-IT enables the University of Washington data user community to access and use institutional information in support of data-driven decision-making. The data analytics team within ERA is tasked with conducting advanced analytics to enable the University to make informed decisions by using data.ERA is currently seeking a Data Engineer in support of the implementation of advanced data analytics capabilities. As a Data Engineer you will focus on the design, implementation, and operation of data management systems to meet the UW's business needs. This includes designing how the data will be stored, consumed, integrated, and managed by different data entities and digital systems using Azure architecture. This position will work together with data consumers to determine, create, and populate optimal data architectures, structures, and systems. Additional responsibilities include developing prototypes and proof of concepts for the selected solutions, and implementing complex data projects with a focus on collecting, parsing, managing, analyzing and visualizing large sets of data using multiple platforms.Additionally, this role will play a key role in implementing backend database technologies, their configuration and utilization, and the optimization of the full data pipeline infrastructure to support the actual content, volume, and periodicity of data to support the intended kinds of queries and analysis to match expected responsiveness.This role will ensure that data pipelines are scalable, repeatable, and secure, and can serve multiple users within the organization; help facilitate getting data from a variety of different sources, getting it in the right formats, assuring that it adhere to data quality standards. In addition, this role is responsible for the infrastructure that provides insight from raw data and handles diverse sources of data seamlessly. Additional responsibilities include developing prototypes and proof of concepts for the selected solutions, and implementing complex data projects with a focus on collecting, parsing, managing, analyzing and visualizing large sets of data using multiple platforms; understand how to apply technologies to solve big data problems and to develop innovative big data solutions.REQUIREMENTS:Bachelor's Degree Computer Science, Engineering, Mathematics or an equivalent experienceMinimum of 4 years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and, scriptingExperience building data solutions using C# and/or PythonExperience writing scripts using MS PowershellExperience writing complex SQL queries (clean and transform data)Experience using advanced software and system design skills in an environment using Microsoft Azure (Azure SQL Managed Instance, Azure Data Warehouse) and graph database, cluster data processing technologies such as DatabricksExperienced in designing Reporting Data models for seamless cross-functional and cross-systems data reporting and analysisExperienced in visualizing data using software such as: Excel/Tableau/D3Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilitiesEquivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration. DESIRED:Agile development process experience or Scrum Master experienceExperience with Snowflake (elastic datawarehouse)Working knowledge or experience with graph databasesExperience in machine learningComfortable and effective in presenting to large audiencesDemonstrated ability to document, measure, and improve business processesUnderstanding of business process mapping and re-engineeringAbility to think analytically and possesses a familiarity with quantitative measurementExcellent time management and organization skillsComfortable with rapidly changing prioritiesProactive communicator CONDITIONS OF EMPLOYMENT:Open office environmentApplication 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.