Working Title Data Integrity Coordinator
SF State University San Francisco State is an Equal Opportunity Employer and does not discriminate against persons on the basis of race, religion, color, ancestry, age, disability, genetic information, gender, gender identity, gender expression, marital status, medical condition, National origin, sex, sexual orientation, covered veteran status, or any other protected status. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose by contacting the Senior Human Resources Manager.
Applicants may visit titleix.sfsu.edu for more information on SF State's policy prohibiting discrimination, and how to file an online report using the procedures under Executive Order 1096 Revised. Inquiries can be directed to the campus Title IX Coordinator and Discrimination, Harassment, and Retaliation Administrator by calling (415) 338-2032 or emailing vpsaem@sfsu.edu.
San Francisco State is a 100% Smoke/Vapor-Free Campus. Smoking or Vaping of any tobacco/plant-based substance is not permitted on any University properties.
The person holding this position may be considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.
This position may be a "designated position" in the California State University's Conflict of Interest Code. The successful candidate accepting this position may be required to file Conflict of Interest forms subject to the regulations of the Fair Political Practices Commission.
Department Advancement Services
Appointment Type This is a one-year probationary position.
Time Base Full-Time (1.0 FTE)
Work Schedule Monday - Friday 8:00am - 5:00pm
Anticipated Hiring Range $4,830.00 Per Month ($57,960.00 Annually)
Salary is commensurate with experience.
Position Summary The Data Integrity Coordinator is responsible for maintaining the integrity of the constituent database, along with the need to analyze, design, create, and disseminate accurate philanthropic productivity reports, extract data for analysis and/or communication purposes, ensure accurate data cleanup, data mapping, implementation, testing, and validating. He/she serves as the project coordinator for data cleanup projects and other efforts related to researching and updating incomplete or missing information on alumni and donors. Additionally, he/she creates scripts and queries to extract data for data-cleansing, data optimization to identify and resolve data issues. In consultation with the Senior Director of Advancement Services, he/she will be responsible for driving adoption of Generative Artificial Intelligence (AI) tools, which will provide advanced analytic techniques and real-time data insights for predictive modeling for funding potential. This position reports directly to the Senior Director of Advancement Services.
Under general supervision, the Data Integrity Coordinator performs a range of data cleanup and integrity projects. The incumbent must maintain high work standards, produce error-free output, and exercise discretion and tact in dealing with highly confidential information. He/she is responsible for reviewing/auditing work to ensure integrity and must possess the ability to resolve data issues and make recommendations as to courses of action. The position will handle data formatting, data entry and in-depth review and analysis of annual philanthropic reports. The coordinator is expected to work cooperatively and effectively with administrators, other staff, donors, outside vendors, consultants and students. This position requires extreme attention to detail, follow through, and the ability to handle multiple tasks with minimal supervision. The incumbent may assist with assigning tasks to student assistants, as required.
Position Information Data Cleansing and Entry
- Oversees data integrity of all alumni, donor, and constituent records.
- Plans and organizes data cleanup projects.
- Updates donor and alumni records.
- Assists IT Manager with testing new applications to ensure existing data is correctly transferred and displayed within the new application.
- Works with the IT Manager on facilitating the bi-annual new alumni uploads, including appending missing Minor degrees and certificates and creating new codes.
- Assists users with questions and requests for changes to reports, dashboards, exports, etc.
- Maintains and updates related policies and procedures documentation.
- Evaluate and update the contents of the CRM donor database system, and maintain the accuracy and integrity of donor, alumni, and other contact data;
- Identify, analyze, and perform data cleanup by creating scripts and programs to extract data for data cleansing and enhancement;
- Access data in the Microsoft SQL Data Warehouse for integration with Power BI or Tableau reporting and analytics.
Data Maintenance
- Conducts cyclical data audits to ensure compliance with established data standards.
- Performs security scans and installs security software patches.
- Develops and maintains efficient systems for data cleansing.
- Ensures and maintains the highest standards of data integrity for alumni, donor and constituent records.
- Executes data appends as Project Administrator for the quarterly Faculty/Staff list from HR, including updates to records i.e. status, department, title, retired, emeriti, etc.
- Serves as the lead advisor for staff responsible for maintaining and enhancing alumni and donor data.
- The Data Integrity Coordinator will monitor the CRM vendor platform product updates and periodically report to the team any product releases, functionality changes or data optimization enhancements.
Other Duties as assigned
- Develops processes and policies to support data quality and integrity.
- Responds to special requests; coordinates with vendors; and assists with other Advancement Services functions.
- Stays abreast of current emerging technologies in philanthropy, fundraising, higher education, data and prospect analysis, predictive modeling, engagement scoring, and business intelligence.}
Minimum Qualifications - Working knowledge of and ability to apply standard theories, principles, practices, and techniques applicable to the program and/or administrative specialty to develop conclusions and make recommendations.
- Thorough knowledge of policies, procedures, and outside regulations pertaining to the applicable program and/or administrative specialty.
- Working knowledge of operational and fiscal analysis and techniques.
- Ability to take initiative and independently plan, organize, coordinate, and perform work in various situations where numerous and diverse demands are involved.
- Skill in the research, development and evaluation of policies and programs, including skill in the collection, evaluation, and interpretation of data to develop sound conclusions and make appropriate recommendations.
- Expertise in investigating and analyzing problems with a broad administrative impact and implications. Ability to anticipate problems and address them proactively.
- Demonstrated ability to effectively interpret, organize, and present information and ideas in written or presentation form.
- Ability to train others on new skills and procedures and provide lead work direction.
- Working knowledge of and ability to apply standard theories, principles, practices, and techniques applicable to the program and/or administrative specialty to develop conclusions and make recommendations.
- Thorough knowledge of policies, procedures, and outside regulations pertaining to the applicable program and/or administrative specialty.
- Working knowledge of operational and fiscal analysis and techniques.
- Ability to take initiative and independently plan, organize, coordinate, and perform work in various situations where numerous and diverse demands are involved.
- Skill in the research, development and evaluation of policies and programs, including skill in the collection, evaluation, and interpretation of data to develop sound conclusions and make appropriate recommendations.
- Expertise in investigating and analyzing problems with a broad administrative impact and implications. Ability to anticipate problems and address them proactively.
- Demonstrated ability to effectively interpret, organize, and present information and ideas in written or presentation form.
- Ability to train others on new skills and procedures and provide lead work direction.}
Preferred Qualifications BA/BS degree or equivalent work experience in accounting, business administration, information technology, or related field. Computer skills including database and/or CRM knowledge/experience imperative. Advanced experience with MS Excel (creating pivot tables/VLOOKUPs). Must be detail-oriented and possess superior analytical skills and the ability to troubleshoot and problem solve. Candidates should possess excellent written and oral English language communication skills, be able to follow written instructions, and exercise independent judgment in problem-solving. Experience with Tableau or Microsoft Power -BI is preferred.
- Experienced and comfortable using automated data sources (e.g., NCOA, Accurint /, Campus Solutions) and sources requiring individual record look-up.
- Experienced self-starter capable of working relatively autonomously.
- 4+ years technical/administrative work involving collecting, recording and analyzing data.
- SQL or programming/scriptwriting experience.
- Able to perform full range of work related to maintenance and deployment of departmental and CSU database policy and procedures, research, analysis, development, evaluation, and/or operational and fiscal analysis related to a data integrity specialty.
- Applies theoretical knowledge to develop recommendations to senior management on operational or fiscal impact of data projects and appropriate actions to mitigate risk.
- Proactively assesses and provides metric-based reports to gauge personal progress on assigned responsibilities.
- Advanced computer skills with database knowledge/experience.
- Superior analytical skills.
- Ability to collect/record/analyze data, make accurate projections, and use basic statistical techniques.
- Ability to organize/plan work and projects; compile/compose/present reports; troubleshoot and problem solve.
- Excellent written and oral English language communication and interpersonal skills.
- Detail-oriented; able to follow written and verbal instructions; exercise independent judgment and creativity in problem-solving.
- Experience in educational or non-profit institution preferred.
- Maintain effective working relationships at all levels.}
Pre-Employment Requirements This position requires the successful completion of a background check.
Eligibility to Work Applicants must be able to provide proof of US Citizenship or authorization to work in the United States, within three business days from their date of hire.
Benefits Threaded through our Total Compensation package is a commitment to Bridging Life's Transitions. SF State is committed to providing our employees with a comprehensive program that rewards efforts that are appreciated by your colleagues, students and the customers we serve.
We offer a competitive compensation package that includes Medical, Dental, Vision, Pension, 401k, Healthcare Savings Account, Life Insurance, Disability Insurance, Vacation and Sick Leave as well as State Holidays and a dynamic Fee Waiver program, all geared towards the University's commitment to attract, motivate and retain our employee.
CSUEU Position (For CSUEU Positions Only) Eligible and qualified on-campus applicants, currently in bargaining units 2, 5, 7, and 9 are given hiring preference.
Additional Information SF STATE IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (i.e. H1-B VISAS). Thank you for your interest in employment with California State University (CSU). CSU is a state entity whose business operations reside within the State of California. Because of this, CSU prohibits hiring employees to perform CSU-related work outside of California with very limited exception. While this position may be eligible for occasional telework, all work is expected to be performed in the state of California, and this position is assigned to on-campus operations.
CSU strongly encourages faculty, staff, and students who are accessing campus facilities to be immunized against COVID-19 or declare a medical or religious exemption from doing so. Any candidates advanced in a currently open search process are encouraged to comply with this requirement. The systemwide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to hrwww@sfsu.edu.
The Human Resources office is open Mondays through Fridays from 8 a.m. to 5 p.m., and can be reached at (415) 338-1872.
Please note that this position, position requirements, application deadline and/or any other component of this position is subject to change or cancellation at any time.
Advertised: Jun 12 2024 Pacific Daylight Time
Applications close:Closing Date/Time:
