Administrative/Support, Information Technology, Project/Program Management/Planning, Staff/Administrative
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 is Committed to attracting and retaining a diverse staff, your experiences, perspectives and unique identities will be honored at the University of Washington. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable, and welcoming.
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 SQL Developer in support of the implementation of Business Intelligence solutions and advanced data analytics capabilities in Azure. As a SQL Developer 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 Azure 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; setup and configure Azure DevOps for continus integration and deployment of artifacts. 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.
Bachelor’s Degree Computer Science, Engineering, Mathematics or equivalent experience
4+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and, scripting
Experience with Azure SQL
Experience writing complex SQL queries (to clean and transform data)
Demonstrated excellent written/oral communication skills, technical documentation skills, user liaison skills, and personal interaction abilities
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
Experience with Azure DevOps and Data Factory
Familiar with on-premise and cloud hybrid solutions
Demonstrated ability to document, measure, and improve business processes
Ability to think analytically and possesses a familiarity with quantitative measurement
Excellent time management and organization skills
Comfortable with rapidly changing priorities
CONDITIONS OF EMPLOYMENT:
Open office environment This position is temporarily funded for up to 24 months; continued employment is contingent on ongoing funding and performance.
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.