Washington State University Hiring for Data Programmer Analyst at Pullman Full Time

Data Programmer Analyst Title: 1496-NN – Business Data Analyst Business Title: Data Programmer Analyst Additional Titles: Location: TOWN CENTRE LEASE Employee Type: Admin. Professional Job Family: Administrative Professional – Not OT Eligible Position Details: COVID-19 Vaccine Information: In accordance with Washington State Governor’s Proclamation 21.14.2, as a condition of employment, you must be fully vaccinated or have an approved medical/religious accommodation by time of hire. People are considered fully vaccinated two weeks after receiving their last shot in a vaccine series. Vaccine or an approved accommodation will be verified prior to your first day of work. Should you not be fully vaccinated or have an approved medical/religious accommodation you will not be able to start employment with WSU. Information regarding vaccine verification and/or requesting a medical/religious accommodation is available at https://hrs.wsu.edu/covid-19/vax-verification/. Please contact HRS at mailto:[email protected] or 509-335-4521 if you have questions. Summary of Duties: The Data Programmer Analyst (Business Data Analyst) is responsible for the development, implementation, operation, maintenance, documentation, and support of the WSU Foundation data management, database programming. This position is responsible for developing Extract, Transform and Load (ETL) processes that build Data Warehouses allowing reports, analytics and applications to function at scale. This person will be proficient at translating business requirements into data models that support production reports, analytics and applications. This person will have a strong understanding of data strategy and development, and handling administrator functions as well. This position is also responsible for working with leaders and teams to build new reports/dashboards while at the same time maintaining the current reports/dashboards Required Qualifications: • Positions require a Bachelor’s degree in a related field AND three (3) years of professional experience in business data analysis or related; OR a combination of education and experience totaling seven (7) years from which comparable knowledge and ability are acquired. • Ability to work in SQL Server environments using SQL Server Management Studio (SSMS) tools, especially T-SQL, query analyze to create, debug, and troubleshoot stored procedures. • Experience working with Microsoft SQL Server (2019 or higher) or any other relational database management system administration. • Experience with advanced stored procedures and SSIS package development. • Experience with Tableau, Power BI or SQL Server Reporting Services (SSRS). • Exceptional time management skills, including the ability to adapt quickly to shifting priorities and prioritize multiple competing tasks in a fast-paced environment. • Experience in data cleansing and quality control processes • Ability to collaborate with University partners, other developers to effectively document partner’s business processes and procedure requirements. • Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills. • Demonstrated ability to provide effective customer service to people at all levels of the organization. • Ability to work and sustain attent