Job Family: Administrative Professional - Not OT Eligible
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.
Essential Job Functions:
65% Automation, Programming, and Integration
30% Data Management
5% Other Duties
Monthly Salary: This position is based on WSU Zone 1 and Salary Grade 6, which has a minimum salary of $4,942 and maximum salary of $7,567. The Hiring Department's expected hiring range is $5,833 - $6,667. In accordance with RCW 49.58.110, this salary reflects the full salary range for this position. Individual placement within the range is based on the candidate's current experience, education, skills, and abilities related to the position. Successful candidates typically begin up to mid-point of the salary range. For additional information, please review WSU's Administrative Professional Compensation.
This is a Permanent position.
To support WSU's ability to attract talent in a competitive job market, this recruitment has been approved for a hiring incentive payment of up to $10,000. For more information about this, please review the WSU Hiring Incentive Payment Program.
This position may be eligible for a remote/hybrid working arrangement.
Benefits: WSU offers a comprehensive benefits package which includes paid sick and vacation leave; paid holidays; medical, dental, life and disability insurance package for employees and dependents; retirement; deferred compensation and optional supplemental retirement accounts. For additional information, please review the detailed Summary of Benefits offered by WSU for AP Staff and Total Compensation.
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 attention with distractions and/or interruptions.
Experience in a higher education environment.
Experience in managing data loads to ensure data sources are loaded into the data warehouse efficiently and effectively.
Experience with SharePoint (2019 or higher).
Experience with using industry's business intelligence tools.
Experience using collaboration and personal productivity tools.
Area/College: University Advancement Department Name: Advancement Innovation and Business Intelligence City, State, Zip: Pullman, WA 99163 Department Link: foundation.wsu.edu Screening Begin Date: Applications received by February 24, 2023 will receive first consideration. Screening will remain ongoing until the vacancy has been filled. Background Check: This position has been designated by the department to require a background check because it requires access to children or vulnerable adults as defined by RCW 74.34, engages in law enforcement, requires security clearance, interacts with WSU students in a counseling or advising capacity, has access to personal identifying and/or financial information, unsupervised access to university buildings/property, or other business-related need. A background check will not be completed until an initial determination of qualification for employment has been made. Application Instructions: Applicants must upload the following documents to their online application. External candidates, please upload all documents in the 'Resume/CV' section of your application. Internal candidates, please upload all documents in the 'Resume/Cover Letter' section of your application.
Applicants must attach the following required documents to their online application:
2) cover letter
Applicants are required to include contact information for professional references within the application. Application materials should clearly communicate how the applicant meets all required qualifications and additional requirements.
Time Type: Full time
Position Term: 12 Month
WASHINGTON STATE UNIVERSITY IS AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EDUCATOR AND EMPLOYER. Members of ethnic minorities, women, special disabled veterans, veterans of the Vietnam-era, recently separated veterans, and other protected veteran, persons of disability and/or persons age 40 and over are encouraged to apply.
WSU employs only U.S. citizens and lawfully authorized non-U.S. citizens. All new employees must show employment eligibility verification as required by the U.S. Citizenship and Immigration Services.
WSU is committed to providing access and reasonable accommodation in its services, programs, activities, education and employment for individuals with disabilities. To request disability accommodation in the application process, contact Human Resource Services: 509-335-4521 (v), Washington State TDD Relay Service: Voice Callers: 1-800-833-6384; TDD Callers: 1-800-833-6388, 509-335-1259(f), or firstname.lastname@example.org.
Washington State University is a public research university committed to its land-grant heritage and tradition of service to society. Washington State College was established in 1890 as a land-grant institution. It has become a distinguished public research university, but its mission remains rooted in accessibility and public service.
For more than 130 years, we have strived to unlock possibilities by empowering students, faculty, and others to create a world where all people can thrive.
In that spirit, our community welcomes scholars from around the globe and prioritizes equitable opportunities for all.