Reporting to the Director of Analytics & Information Systems, the Assistant Director of Analytics is responsible for leading the Foundation’s marketing analytics functions and ad hoc delivery by overseeing the queue of analytics requests, developing tools to streamline data access, and training customers on using data to inform business decisions.
The successful candidate will be required to show proof of being fully vaccinated against COVID-19 prior to the first day of employment.
The work location for this position is the Foundation’s Corvallis, OR office.
The Foundation offers a program called Core Work Days, a hybrid approach combining remote and in-office work days. Unless traveling for work, Foundation employees are in office on Tuesday, Wednesday and Thursday, and work remotely, if preferred, on Monday and Friday.
Customer Service and Analytics Delivery
Serve as the point of contact for internal customers and University staff to determine their information needs; deliver requests within the expected timeline.
Review analytics requests daily and consult with requesters regarding specifications, needs, and questions. Provide requesters with updates on the status and results of requests.
Generate ad hoc and/or custom reports summarizing business data for review by decision makers and end users.
Develop and document standard processes for delivering requests quickly and accurately.
Troubleshoot and resolve problems with standard reports and analytic requests as needed.
Ensure analysis complies with standard definitions of organizational data. Document and refine these definitions as needed.
Maintain access, security, and practical use of delivered reports.
Gather relevant data and conduct insight analysis to strategically increase data driven action and solutions.
Develop and modify applications/software as needed or as directed by the Director of Analytics & Information Systems.
Maintain and enhance analytics applications to best serve and produce standard reports.
Support systems, applications and databases accessed by OSU Foundation.
Identify analytics system issues or issues with the database infrastructure.
Coordinate with Data Operations to ensure accuracy and accessibility of data loads.
Recommend enhancements to improve efficiency of existing programs and analytics infrastructure.
Utilize version control to maintain integrity of source code and provide backup when needed.
Train colleagues in the use of data and standard reports to inform decisions. Continually evaluate and improve our training program.
Create and maintain a procedure manual, training material and other resource documents to assist end-user adoption and use of analytic tools.
Ensure delivered reports comply with our information security guidelines and customers understand their responsibilities with the data provided.
Perform other duties as assigned.
Comprehensive knowledge of:
Proven skill in:
Demonstrated ability to:
Bachelor’s degree and three years of analytics experience. Preference will be given for possessing experience or knowledge of the following technologies: DBT, Snowflake, SQL Server, Microsoft Dynamics, and Tableau, and to individuals with supervisory experience. Education and experience equivalencies will be considered.
We strive to be one of the best places to work in the country. We know that our success depends in large part on the people who carry out our mission. It’s what we do –and how we do it -- that makes the difference. Our core values reflect our approach to work and to each other, and we are committed to conduct consistent with these values.