Senior Computer Specialist - School of Medicine Dean's Office, Departmental Computing

Hybrid (telework 3 days or more per week)

Seattle, WA

Full time

REQ-0000137781

Job Description

The School of Medicine Dean’s Office has an outstanding opportunity for a Senior Computer Specialist, to join their team.

About this Opportunity

Reporting to the Assistant Director for Departmental Computing (Assistant Director) the Senior Computer Specialist (Specialist) serves as a flexible resource that works independently to support and develop VBA applications in Access and Excel linked to SQL Server, develop reports and supporting data sources, examine and analyze administrative systems, fiscal and/or administrative records, and institutional practices.

The Specialist develops data solutions and reports, providing impact assessments, training recommendations and ways to improve operations and information systems. This position has a wide range of responsibilities including application support, report development, functional requirement gathering for projects, financial reporting and analysis, operational assessments, and documenting projects, systems, and processes. As a subject matter expert, this position acts in an advisory capacity to senior management in the School providing research and analytical support on data and reporting issues.

Key Responsibilities

Development and Report Design – 70%

• Apply user-centered design practices and interview stakeholders and system users to determine functional requirements for new and existing reports, databases, and automated solutions. Create documentation to support business requirements and technical specifications.

• Design, develop, and maintain automation solutions and reports using SQL, VBA, MS Excel, MS Access, Power BI, and SSRS. Evaluate solutions based on programming complexity, long-term supportability, performance, and end-user workflow.

• Develop and enhance reports ranging from low to high complexity using SQL queries, stored procedures, VBA automation, and reporting platforms such as Power BI.

• Review and optimize existing SQL code, VBA applications, reports, and documentation to ensure accuracy, efficiency, and alignment with business requirements. Create project documentation to support agile development practices.

• Analyze relational databases, data models, and system interfaces. Validate data from multiple sources, ensure data integrity, and collaborate with developers and business users to test and verify reporting solutions.

• Provide technical support for the analysis, design, development, testing, and implementation of VBA applications, database and reporting solutions.

• Troubleshoot SQL queries, VBA applications, reporting processes, and data issues to ensure reliable, highly available reporting services.

Project Management / Business Analysis – 25%

• Serve as a technical lead or project coordinator for low- to moderately complex reporting and database development projects. Work independently or collaboratively to meet project deadlines.

• Demonstrate sound business analysis, technical problem-solving, and project management skills while balancing multiple priorities.

• Coordinate project activities, communicate progress with management, developers, customers, and end users, and identify appropriate resource requirements.

• Partner with clients to translate business requirements into SQL-based reporting, VBA automation, and database solutions while coordinating implementation with development teams.

Other Related Duties – 5%

Required Qualifications

To be considered for this opportunity, your application must demonstrate that you meet the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration.

Minimum Qualifications

• Bachelor’s degree in accounting, business administration, computer science or related field

• Four or more years of experience in Access and Excel development

Applicants who do not meet these qualifications WILL NOT be forwarded to the Hiring Manager.

Additional Qualifications

• Experience in relational database applications such as MS SQL and Access

• Experience in T-SQL and VBA: MS Access, Excel

• Experience in Power BI and/or other reporting tools

• Demonstrated ability to develop creative solutions for complex financial reporting situations

• Demonstrated experience working in large, highly structured environments

• Ability to work independently with a high degree of reliability, accuracy and productivity

• Ability to create accurate, cogent reports

• Proficiency with various computer programs and databases

• Effective communication skills, demonstrating diplomacy and tact

Preferred Qualifications

• Four or more years of experience in report design using Power BI, SSRS, etc.

• Experience in data and process modeling

• Proficient in SQL and VBA, MS Access, Excel, SQL Server Reporting Services and Power BI, or similar (C#, etc.)

Compensation, Benefits and Position Details

Pay Range Minimum:

$86,376.00 annual

Pay Range Maximum:

$140,364.00 annual

Other Compensation:

Benefits:

For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/

Shift:

First Shift (United States of America)

Temporary or Regular?

This is a regular position

FTE (Full-Time Equivalent):

100.00%

Union/Bargaining Unit:

Not Applicable

About the UW

Working at the University of Washington provides a unique opportunity to change lives – on our campuses, in our state and around the world.

UW employees bring their boundless energy, creative problem-solving skills and dedication to building stronger minds and a healthier world. In return, they enjoy outstanding benefits, opportunities for professional growth and the chance to work in an environment known for its diversity, intellectual excitement, artistic pursuits and natural beauty.

Our Commitment

The University of Washington is committed to fostering an inclusive, respectful and welcoming community for all. As an equal opportunity employer, the University considers applicants for employment without regard to race, color, creed, religion, national origin, citizenship, sex, pregnancy, age, marital status, sexual orientation, gender identity or expression, genetic information, disability, or veteran status consistent with UW Executive Order No. 81 (https://policy.uw.edu/directory/po/executive-orders/eo-81-prohibiting-discrimination-harassment-and-sexual-misconduct/) .

To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or [email protected] .

Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law (https://app.leg.wa.gov/RCW/default.aspx?cite=28B.112.080) .

Use the filters or enter keywords in the search box (such as “custodian,” “nursing” or “manager”) to explore available opportunities. To find temporary opportunities, enter “temporary” in the search box.

If you are a current UW employee:

You must log into Workday and apply internally through the UW Jobs Hub.

Looking for faculty, librarian or academic staff positions?

Please visit our Academic Jobs (https://ap.washington.edu/ahr/academic-jobs/) site.

Looking for student employment?

Learn more on our Student Employment (https://hr.uw.edu/studentemployment/finding-student-employment/) site.

There are many perks to working for the University of Washington. Learn more about the benefits (https://www.washington.edu/jobs/benefits-for-uw-staff/) that could be available to you as a UW employee.

Sign up for Job Alerts (https://wd5.myworkdaysite.com/en-US/recruiting/uw/UWHires/jobAlerts) to be notified about job opportunities at the UW that interest you; you’ll be one of the first to learn when openings become available. You will be asked to create an account if you do not already have one.

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.