Research Support - Laboratory/Non-Laboratory, Staff/Administrative
Data Programmer Analyst
Employee Type: AP-Administrative Professional
Position Number: 125632
Work Location: Pullman
Summary of Duties: The Programmer Data 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.
Automation, Programming and Integration- 65% Exercise extensive knowledge of the methods and tools used in electronic data processing, to analyze, design and build SSIS packages.
Document, process, and provide data for ad-hoc reporting requirements.
Design, develop and support ETL processes and tools for building Data Warehouses.
Utilize native SQL and third party tools to produce effective database development. Perform unit tests on processes and prepare required programs and scripts.
Conduct root cause analysis and resolves performance, production problems and data issues.
Provide weekly status reports to direct supervisor.
Perform tests, validate data flows, and prepare ETL processes according to business requirements and incorporate business requirements into all design specifications.
Data Management- 30% Coordinate work with other IT and Data team in the analysis and design of ETL package and scheduling testing.
Train student programmers and analysts for specific tasks or assignments related to data management projects.
Establish and enforce data warehousing standards to meet requirements and business needs.
Effectively use data life cycle management (DLM) for completing small to medium sized projects.
Provide legacy application support to maintain the current functionality. Support legacy reporting and older data integration ETL packages.
Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL processes, programs and scripts.
Gather data and enter it accurately and efficiently into a database.
Analyze data cleansing procedures and data integrity functions. Provide reports of findings to team lead/manager for review.
Maintain accurate records of these findings. Document technical and system specification documents and ETL processes. Conduct routine data cleansing and quality control processes.
Capture business requirements, propose data models and validate proof-of-concepts designs.
Prepare documents and data flow diagrams that support proof-of-concepts and production models.
Develop and schedule ETL processes.
Develop and maintain audit and validation processes to detect data integrity problems.
Develop and perform tests on all ETL code for system data integration
Other-5% Other Duties as Required
Required Qualifications: Positions require a Bachelors 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.
Founded in 1890 in Pullman, Washington State University (WSU) is Washington’s land-grant university with an overarching mission of improving the quality of life for all citizens – locally, nationally, and globally. WSU is committed to innovation and excellence in research and scholarship. WSU has a current enrollment of over 30,000 undergraduate, graduate, and professional students and approximately 6,000 faculty and staff at its five campuses (Pullman, Spokane, Tri-Cities, Vancouver, and Everett), as well as its numerous other locations across the State of Washington and online through its Global Campus.
U.S. News & World Report's 2016 "America's Best Colleges" rankings place WSU in the top 75 public national universities. WSU was one of only three Northwest universities to be placed in the top two tiers, along with the University of Washington and the University of Oregon. WSU is ranked as a "highest research activity" institution by the Carnegie Foundation and is in the top 12 percent of research universities as reported by the National Science Foundation. Also, WSU was recognized by the Carnegie Foundation for the Advancement of Teaching for its engagement activities with i...ts Community Engagement Classification.
WSU employs approximately 6,000 faculty and professional staff and the University deeply values diversity among its faculty, students, and staff. WSU students represent diverse social, economic, and ethnic backgrounds: approximately 10 percent of WSU students hail from outside the state of Washington, and approximately 6.8 percent are international students. WSU annually awards more than $280 million in scholarships and financial aid to approximately 17,000 undergraduate students.