University of Washington SQL DEVELOPER in Seattle, Washington
Req #: 182032
Department: UW INFORMATION TECHNOLOGY
Appointing Department Web Address: http://www.washington.edu/uwit/employment/
Posting Date: 06/18/2021
Closing Info: Open Until Filled
Salary: Salary is commensurate with experience and education.
Shift: First Shift
Notes: As a UW employee, you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position, click here. (http://hr.uw.edu/benefits/wp-content/uploads/sites/3/2018/02/benefits-academic-professional-librarians-staff-20191231.pdf)
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 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. REQUIREMENTS: 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. DESIRED:
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 Proactive communicator 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.
University of Washington is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, religion, color, national origin, sexual orientation, gender identity, sex, age, protected veteran or disabled status, or genetic information.
University of Washington
- University of Washington Jobs