Post Date: 05/07/2019
Close Date: 05/30/2019
The Data Analyst is responsible for gathering, manipulating, analyzing, presenting and maintaining the integrity of the Foundation’s databases and data warehouses. The incumbent in this position must have a solid combination of technical, analytical, communication, customer service, and task and project management skills to effectively and efficiently handle the duties of this position.
This position reports to the Senior Director of Information Technology (IT) and Data Management and works closely with other members of the IT and Data Management team, and all levels of Foundation and University staff and faculty.
Reasonable accommodations may be made to enable individuals with disabilities to perform the required duties.
-Creates imports and exports to load data into and out of the CRM and Financial systems.
-Creates ETL (extraction, transform and load) processes to load, extract, and update data in the systems using Microsoft SQL Server Integration Services (SSIS).
-Develops and supports data warehouses and creates/test interfaces that integrate with them and provide end-users the ability to query, filter, and extract information.
-Works with key users to identify list and report requirements and perform analysis and design in support of new or changing data structures.
-Develops training curriculums and materials to lead end-user trainings.
-Trains new staff members on using the database for both frontline and operational purposes.
-Creates lists, queries, reports and dashboards based on user requests using tools built into the CRM and Financial solutions, Microsoft SQL Server Reporting Services (SSRS), and other application, query, and reporting tools.
-Creates processes to audit and clean-up data.
-Develops and documents data standards, guidelines and best practices that ensure the accuracy of the data within the systems and ensure confidentially and security of data.
-Conducts systems analysis and recommend actions to improve system utilization and performance.
-Participates in the ongoing definition and execution of the Foundation’s technology roadmap in accordance with the strategic plans of the Foundation and University.
-Assists with development, implementation, testing, and update of disaster recovery and business continuity procedures.
-Creates and maintains business, functional, and best-practice content on Intranet, Team and other PSUF websites and organization/department drives as needed.
-Support research and prospecting activities by identifying, retrieving, querying, and appending data from internal and external data sources.
-Other duties and projects as assigned.
This position will remain open until May 30, or until filled.
To apply, read the full job description, and to learn more about the Portland State University Foundation visit: http://psuf.org/careers.