Post Date: 12/13/2018
Close Date: 01/13/2019
The Information Analyst - Demographics is responsible for all data held within the Foundation’s CRM production and staging databases, data warehouse, document management solution, and related systems (hereafter known as the Foundation’s CRM systems).
The Information Analyst - Demographics administers the data entry process including demographic, gift, constituent engagement and other data. The incumbent is responsible for data integrity and designing efficient data entry processes that support the Foundation business model. The steward performs and/or supervises bulk data imports and integrations to/from other systems.
Working with the Senior Director of Information Technology and Data Management and other IT and Data Management staff, the Information Analyst - Demographics is a part of the core team responsible for data standards and practices, business analysis, design and programming of database objects, and database documentation.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
-Lead entry of demographic data into the Foundation’s CRM system per Foundation business practices and policies.
-Provide back up and assistance to the gift processing team in Finance and Accounting as needed ensuring gift processing functions/activity are handled per Foundation business practices and policies.
-Review work of data specialists and other staff entering data into the Foundation’s CRM systems for consistency, accuracy, and efficiency.
-Build and perform recurring data audits; suggest and implement business practices to enhance data integrity and data entry efficiency.
-Perform or supervise data cleanup projects.
-Using programming skills develop database objects and structures for data storage, retrieval and reporting
-Develop user interface improvements, back-end integrations etc.
-Design, perform and/or supervise recurring and ad hoc data imports such as student/graduate imports, faculty/staff imports, prospect lists etc.
-Develop occasional reports and provide backup for Foundation reporting functions
-Maintain strong relationships with other Foundation and University Departments and Units to ensure accurate and timely data is captured regarding Portland State Constituents.
-Other projects as assigned.
-Available to work extra hours as needed to stay current with workload.
-Develops and maintains comprehensive CRM reference and training manuals.
-Coordinates training classes and trains and advises staff on navigating and using the constituent database and best practices in data management.
Required Education and Qualifications:
-Excellent requirements gathering, documentation, mapping, and analytical skills.
-Excellent prioritization, time-management, and task tracking and completion skills.
-Four or more years of experience with SQL and relational databases.
-Ability to build and create a customer service-oriented environment.
-Must be reliable, organized, efficient and pay keen attention to detail.
-Ability to maintain confidentiality.
-Ability to work independently with minimal direction.
-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.
-Successful completion of background check.
This position will remain open until January 13, 2018, 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.