Data Analyst

Position SummaryThe 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. Required Duties 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 the 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.Secondary FunctionsAssists with system upgrades and patching including review and assessment of upgrade and patch release notes, test script planning and development, testing, and coordination of user testing.  Lead on the implementation of new modules.Provide secondary support on other IT issues and requests as needed.Required Qualifications, Education, and ExperienceBachelor’s degree.Four or more years of experience with SQL.Demonstrated experience writing SQL queries and stored procedures.Experience working with Constituent Relationship Management (preferably BBCRM) and Financial software (preferably Blackbaud FE) or similar large relational databases.Excellent requirements gathering, documentation, mapping, and analytical skills.Excellent prioritization, time-management, and task tracking and completion skills.Knowledge of and experience with the functions, capabilities, and applications of data warehousing and business intelligence.Ability to build and create a customer service-oriented environment.Must be reliable, organized, efficient, and pay keen attention to detail.Proficient in Microsoft Office suite of products, particularly Word, Excel, and Visio.Excellent computer skills, and ability to learn and adapt quickly to new software.Reliable, regular, and predictable attendance. Successful completion of a background check is required.Preferred Qualifications, Education, and ExperienceDemonstrable knowledge and experience with Microsoft SSMS, SSIS, and SSRS.Demonstrable knowledge and experience working with ETL packaging, APIs, SDKs, Visual Studio and .NET 4.0 (or higher) framework.Experience in higher education or non-profit environment.Knowledge of tax laws pertaining to charitable giving.Experience working with Microsoft Azure and/or other cloud-based infrastructures.Additional InformationThis position will remain open until August 14, 2019, or until filled.

To apply, read the full job description, review our employee benefits, and to learn more about the Portland State University Foundation visit: