What are the responsibilities and job description for the Data and Reporting Solutions Specialist position at NDSU Foundation?
The North Dakota State University Foundation seeks mission-driven individuals interested in joining a growing team dedicated to connecting people, developing partnerships, teamwork, accountability, transparency, stewardship, communication, and service. The Foundation invites candidates for a Data & Reporting Solutions Specialist, full-time non-exempt position.
The North Dakota State University Foundation is a separate 501(c)(3) organization which exists to maximize advocacy and philanthropy to support NDSU. We connect people who are passionate about NDSU and improving the lives and outcomes of North Dakotans and the world. We are an organization of sixty team members and growing. If you enjoy non-profit work, are inspired by our mission, love to collaborate with your colleagues, and are ambitious to develop as a professional, we welcome you to apply.
Our team members enjoy a highly competitive total compensation package including company paid health insurance, a defined contribution account funded at 9.5%, generous paid time off, abundant professional development opportunities, plus elective dental and vision plans.
This position may be eligible for hybrid work following a period of onboarding.
This position will remain open until filled. To be considered, applicants must apply online through the NDSU Foundation employment site (https://www.ndsufoundation.com/employment) and include a cover letter and resume.
Position Summary:
Develop and maintain high-quality reports and dashboards to support data-driven decision-making across the organization. This role involves collaborating with stakeholders to understand reporting and visualization needs, ensuring the accuracy and accessibility of data, and creating reports and dashboards to meet organizational requirements.
Essential Duties and Responsibilities:
- Report/Dashboard Development
- Collaborate with internal teams to gather and understand reporting and dashboard requirements.
- Design, build, and maintain reports, dashboards, and visualizations using tools like Salesforce, Apsona, PowerBI, Tableau, or similar platforms.
- Ensure data accuracy and consistency across all reports and dashboards.
- Develop and document processes for report creation and maintenance.
- Automate recurring reports where possible to improve efficiency and reduce manual processes.
- Provide support to end-users on reporting applications: answer questions, troubleshoot issues and research solutions.
- Data Analysis
- Create segmentation models for donors based on giving history, engagement levels, and demographic data to support annual giving campaigns.
- Build dashboards to track key performance indicators (KPIs) such as donor growth, average gift size, and volunteer engagement, etc.
- Examine donor trends and generate insights into potential engagement opportunities.
- Assist teams in understanding report outputs and using them to inform decisions.
- Conduct additional analysis projects on an ad hoc basis.
- Quality Assurance and Stakeholder Support
- Work with the data team to ensure the integrity and consistency of organizational data.
- Conduct regular quality checks on data sources to maintain accurate reporting.
- Troubleshoot data-related issues and provide solutions in collaboration with relevant teams and Associate Director of Data Services.
- Provide training and technical support to staff on how to use reporting tools, reports, and dashboards effectively.
- Respond to ad hoc report requests and data inquiries in a timely manner.
- Customer Service and Support
- Deliver high quality customer service to end-users and provide training as needed.
- Consult with end-users to identify opportunities for business process improvements.
- Offer insights and present findings related to prepared data.
- Respond to report requests and deliver end-product in a timely fashion.
- Maintain confidentiality of donors and other sensitive information.
Essential Functions:
- Set priorities, develop a work schedule, monitor progress towards goals, and track details/data/information/activities.
- Efficiently operate a personal computer and associated software (Outlook, Word, Excel, etc.)
- Maintain files accurately, in paper and in software programs
- Maintain records and prepare reports
- Handle multiple tasks simultaneously
- Plan, prioritize and meet deadlines
- Establish and maintain positive working relationships with others both internally and externally to achieve the goals of the organization.
- Interact in an effective, positive, helpful, and appropriate manner with diverse populations, internal staff, University community and the public
- Work cooperatively and effectively with others to resolve problems and make decisions that enhance organizational effectiveness.
- Maintain confidentiality of records and information
- Display excellent judgment and decision making
- Follow through on projects with little supervision
- Spot and appropriately address problems
- Promote data literacy and foster a data-driven culture
- Speak, listen, and write in a clear, thorough, and timely manner using appropriate and effective communication tools and techniques.
Minimum Qualifications:
- Bachelor’s degree in management information systems, computer science, data analytics or related field; or equivalent combination of education and experience
- Two years of experience working with relational databases and creating reports
- One year of experience using data visualization tools, Power BI, Tableau, or other closely related software.
- Effective communications skills when presenting to various stakeholders, including internal staff, Foundation Trustees, and NDSU campus partners
- Strong problem-solving skills and a deep understanding of data interpretation.
- Knowledge of data privacy and security best practices to protect sensitive information
- Ability to apply technical/functional expertise, manage and improve processes, practice self-development, champion change and innovation
Preferred Qualifications:
- Experience using Salesforce
- Experience with Power BI, Tableau
- Experience with DAX and Power Query
- Experience with various programming languages (JAVA, VB, SQL)
- Experience in a non-profit organization
Physical Demands:
Must be able to remain in a stationary position for extended periods of time. The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, etc. Constantly operates a computer and other office productivity machinery, such as computer, printer, copy machines. Occasionally positions self to maintain computers and equipment, including under the desks and in the server closet. Frequently moves computer equipment weighing up to 25 pounds across the organization.
The position description is not intended to be an all-inclusive list of job responsibilities, duties, and requirements: but to describe the standard level of work being performed. Employees may be required to perform other duties as assigned or as required by the needs of the business. The NDSU Foundation reserves the right to add or change the duties of the position at any time.
The NDSU Foundation does not discriminate on the basis of age, color, gender expression/identity, genetic information, marital status, national origin, physical or mental disability, pregnancy, public assistance status, race, religion, sex, sexual orientation, status as a U.S. veteran, or participation in lawful activity off the employer's premises, as applicable.
