Location: Seattle, Washington
Type: Full Time
|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.
The SQL Programmer is responsible for migrating and maintaining complex data structures (e.g. warehouses, cubes, data marts) in a Microsoft SQL Server environment with a strong emphasis on T-SQL development. These data structures drive reporting solutions and provide the necessary infrastructure to support data-driven strategic and tactical decisions for University Advancement. Reporting to the Director for Reporting, the SQL Programmer works in collaboration with the Advancement Information Management team to migrate accurate and efficient data solutions that support University Advancement initiatives.
Information and reporting are critical to all aspects of supporting the fundraising efforts of the University. To support these efforts, UW Advancement maintains a database of over one million donor, prospect, alumni, volunteer, faculty, staff, parent, and student records, many with individually defined communication preferences. UW Advancement is currently migrating from our to current CRM (Advance) to a MSFT Dynamics-based CRM. The SQL Programmer will migrate and improve complex stored procedures and queries to extract and deliver output for both major giving and broad-based fundraising efforts, as well as a variety of marketing, communication, stewardship, and analysis activities. Due to the scope and complexity of constituent data, it is critical that the SQL Programmer assist in maintaining a robust and stable infrastructure for extracting consistent and accurate information. Inaccurate or imprecise output can lead to increased operational costs and negatively impact our relationships with donors, potential donors and high-level volunteers. The reporting of private support to the University is highly regulated, not only through federal and state law, but also through defined industry standards for reporting. It is important that the SQL Programmer has a clear understanding of all reporting requirements and regulations in order to continually evaluate against those standards and determine if information is being queried accurately. This position may also provide counsel to clients on standards and provides appropriate alternatives to achieve client needs.
This position plays a key role in providing information to UW Advancement, academic and administrative clients across campus and at all levels, from support staff to the Office of the President. The SQL Programmer is responsible for assessing the information needs of all, translating business language from varied school and college Advancement units into uniform database solutions, and applying business standards beyond what may be articulated in client specifications in order to ensure accuracy and consistency across platforms.
DUTIES AND RESPONSIBILITIES:
Migrate existing SQL database objects to a data warehouse environment.
•Migrate custom database objects in SQLServer
•Migrate custom Tableau Data Extract Files
•Test and optimize database solutions based on client-specifications.
Document database and extract schema, field definitions, and data mappings across systems. Contribute to comprehensive data asset inventory, including source and provenance metadata, security and access restrictions, and maintenance and retention requirements.
Relationship Management (5%)
Consult with stakeholders to help define and/or refine criteria.
Other duties (10%)
•Deliver accurate outputs for adhoc data requests from the UW Advancement staff and affiliates.
Bachelor's degree and 3 years of progressively responsible experience in a database reporting environment or related field. Equivalent combination of education and experience from which comparable knowledge and skills have been acquired may substitute for degree.
Strong general RDBMS experience, Advanced SQL Server skills should include: Designing, developing, testing, and supporting mid-to-large scale databases. Expertise in creating all key database objects: Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL. In-depth knowledge of development, testing, and optimization of T-SQL code with tools included in SQL Server, along with other third-party tools (e.g. Oracle, MS Access, Tableau, Power BI). Ability to troubleshoot and resolve complex database issues.
Familiarity with enterprise data warehouse concepts and standards preferred.
Familiarity with project management and source control software.
Proficiency using PC computers. Demonstrated strong computer skills, including proficiency with Microsoft Office.
Experience with data modeling and analytics
Experience with taxonomy/ontology structures
Knowledge of alumni relations/development/advancement principles
Conditions of Employment
Open workspace environment which may result in an increased level of noise and visual distractions.
Application Process: The application process 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.