Foundation - Data Analyst

Title: Foundation - Data Analyst

Employee Classification: Professional F/T 52 Wks Unit

Department: Foundation

Salary Range: $67,569.00

Who we are:

We are not-for-profit: St. Louis Community college (STLCC) is a non-profit institution dedicated to empowering students, expanding minds, and changing lives. Employees are committed to strengthening the St. Louis community with inclusive and transformative education.

We are a respected employer: For 60 years, STLCC has served the St. Louis community, expanding to 4 main campuses, 2 education centers, 2 workforce training centers, and 5 centers of excellence. More than one-half of the households in St. Louis have at least one member who has taken classes at STLCC.

We make an impact in the community: Through credit courses, continuing education, and workforce development programs, STLCC annually serves nearly 69,000 students. More than 80% of career and technical graduates employed in their fields or continue their education at four-year institutions within six months of graduation. STLCC sends more transfer students to Missouri's four-year colleges/universities than anyone else.

We value Diversity, equity & inclusion: STLCC is committed to fostering an atmosphere of appreciation for all people, regardless of race, color, creed, religion, sex, sexual orientation, gender identity and expression, national origin, ancestry, age, disability, genetic information, veteran status, or class.

What you get:

Benefits package [for full-time employees]: STLCC offers one of the best benefit packages in the St. Louis area. As a STLCC employee you will have access to a 100% match on your contribution to retirement, two health insurance plans options that are no cost to the employee - including an HSA option, low-cost life insurance with a 3x salary benefit, and other low-cost benefits including dental, vision, AD&D, ST LT disability insurance.

Opportunity to grow: Over half of our employees have served the college for more than 12 years, exploring different career paths and advancing to higher level positions.

Education & training opportunities: STLCC offers tuition waivers for employees [full-time and part-time] + their dependents. Full-time employees can take advantage of tuition reimbursement for other institutions after just 6 months of service, and an annual professional development allotment.

Work/life balance: Full-time STLCC employees have access to a generous time off package, including holidays, vacation, personal days, medical leave, and other leave options. Our holiday schedule even includes a paid winter holiday at the end of the calendar year.

Commitment to wellness: STLCC HR boasts a dedicated health and wellness specialist who is enthusiastic about creating a culture of wellness throughout the College. With access to college wellness vendors, employees are educated, motivated, and rewarded for healthy behaviors. STLCC employees and anyone living in their household also have access to an employee assistance program (EAP) that can help them with virtually any life need.

The basics of this position:

****Seeking Non-Profit or Higher Education experienced Data Analyst**** this is an IN-PERSON, ONSITE position located in St. Louis, MO****
Performs duties necessary to manage the daily operation of the Advancement module (Banner Advancement), which tracks contributions, alumni, donor, and prospect information.
Ensures the accuracy and integrity of the Foundation's information systems, including data input and output, technology management, and end-user training and support. Provides support to Foundation staff by assisting with the creation of reports, ensuring that advancement staff are trained in the proper use of the data, developing and implementing policies to guide data entry, and making sure that the system effectively captures alumni and donor information and generates accurate financial and analytical reports. The data analyst will ensure that all gifts from donors are accurately processed, tracked, acknowledged and reconciled with the finance function. Serves as the first point of contact for Foundation staff with questions about or problems with the use of the system and serves as the liaison to vendors and the IT department in maintaining the system and troubleshooting problems.

What you'll do:

• * Serve as the software system manager, applying all Banner Advancement updates and responsible for cleanup of current system.
  * Maintain current knowledge of Banner programs. Utilize advanced computer analysis skills, including the use of software to create documents, spreadsheets, timelines, and reports.
  * Provide training and technical support for the Banner Advancement alumni/donor database. Including developing written training materials.
  * Interpret and apply IRS tax laws and regulations regarding gift administration.
  * Manage the generation of financial, analytical, and demographic reports, as well as mailing lists, invitation lists, recognition lists, and other data extractions as requested.
  * Builds and maintains positive working relationships with team members, internal customers, and external vendors.
  * Help recommend data collection best practices to all staff who come in contact with potential data for the organization.
  * Maintain online presence through website maintenance and management of online giving portal, CASHNet.
  * Design functional specs for custom queries for data extraction.
  * Establish and maintain a structure within the system to effectively identify specific segments of data for various analysis and targeted marketing efforts.
  * Develop and apply procedures to safeguard data security ensure compliance.
  * Assist with research and ongoing process improvement of organization's data management policies and practices.
  * Research data to identify prospective donors for the Foundation.
  * Analyzes trends in giving and college priorities in order to recommend appropriate donor relations activities for all constituencies. Oversees implementation and tracking of the Foundation's overall fund stewardship plan across all foundation departments and outreach platforms.

Education, experience, and other requirements:

* Bachelor's Degree and a minimum of three (3) years' work experience within the nonprofit organization or higher education environment.
* Experience managing development and/or alumni databases (preferably using Banner).
* Proficiency in prospect and constituent management, data imports and exports, developing reports (preferably using Cognos Reports).
* Experience with online donor giving tools.

Preferred Qualifications:

* Marketing, communications, and social media experience preferred