Description
Required Qualifications (as evidenced by an attached resume):

Bachelor's degree (foreign equivalent or higher).  Three (3) years of full-time programming experience.  Solid understanding and experience in the use of relational databases.  Prior experience in Structured Query Language (SQL). Working with complex data sets.

Preferred Qualifications:  

Bachelor's degree in Computer Science or related field (foreign equivalent or higher). Experience using Raiser’s Edge.  Experience with HTML, Java or Content Management System. Experience with visualization/analysis software.  Experience working in higher education and/or academic health sciences center. Experience working with financial data.

Brief Description of Duties:

The Data Analyst is a professional and technical position that is passionate about data, keen to learn new methods to better report, access and manipulate data, and who thinks creatively about ways to expand current data management practices.  The ideal data analyst will have experience working with large databases; designing developing, and enhancing technology solutions aimed at improving business processes and data management.

 

The selected candidate should have the ability to think creatively and independently to solve problems and work with advancement staff in organizing data, creating/managing reports, and data analysis.  They will use data to aid business decisions supporting fundraising goals and resource deployment. The incumbent will be responsible for creating custom reports and data visualizations based on Advancement and SBF Business office needs and facilitate detailed data reviews and analysis. A successful candidate will have prior experience in a large, complex organization and fast paced environment, managing multiple projects, and deadlines.

Data Analysis:

Provide program expertise to management to use in the evaluation of the Raiser's Edge (RE) data functionality and capability.  Become fluent in all aspects of data coding, storage, reporting, extraction, sharing, and importing within RE. Look for ways to improve the use and overall integrity of the University constituent database including the evaluation of third party tools/utilities.  Provide data analysis to a wide range of data sets to enable Advancement and the University better understand the constituent data and improve donor/alumni outreach.

- Analyzes data and summarizes performance using summary statistical procedures.

- Develops and analyzes business performance reports and provides notations of performance deviations and anomalies.

- Create standard reports and data visualizations for the user community.  

- Create and maintain complicated query selections and segmentations in support of user requests and management needs.

- Create custom reports using Tableau and other programs/utilities when needing more complex reports that are unavailable in RE.

- Develop methodologies for using data analytics tools; manage reporting, visualizations, dashboards and statistical graphs to illustrate findings.

- Test and debug utilities and reports to assure performance to specifications.

- Create and maintain data and system documentation as needed.

- Participate and provide technical assistance in special projects within Advancement and the Stony Brook Foundation.

- Engage and learn business user needs in order to best support the fundraising, alumni relations and annual giving programs

Data Management and Integrity:

Ability to integrate multiple systems, data sets, query databases and perform statistical analysis; linking multiple/distinctive data set to provide new insights.  Initiate and develop programs to coordinate the electronic selection and verification of data managed within the central data management system, Raiser's Edge; currently estimated at over 310,000 records.  

- Regularly execute data cleansing routines and analyze results to fix problems on an immediate and go-forward basis.

- Develop reports and data validation process around key data metrics and business processes.

- Proactively identify opportunities for process and reporting efficiencies.

- Respond to ad-hoc requests from internal and external customers.

- Create and modify reports using Microsoft Excel, Microsoft SQL and other data aggregating tools.

- Collaborate with others to understand data opportunities, needs and drive data quality improvement.

Operations Support:

Work with Advancement staff to analyze and gather requirements to meet business needs and objectives, sharing the results appropriately.  Report data needs to be analyzed to predict if the best tools are being used. Use Lumniate, Google Analytics, and any other data analysis tools to enhance the data understanding and needs.

- Automate processes to streamline work and minimize errors.

- Monitor data flow and seek out bad or misaligned data throughout RE and its associated systems.

- Monitor the use of the data through our Advancement partners (Annual Fund, Alumni Relations, etc…) and make recommendations for improvements and enhancements.

Other duties or projects as assigned as appropriate to rank and departmental mission.

Special Notes:

This is a full-time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption. Night and Weekend work may be required.

Stony Brook University is 100% tobacco-free as of January 1, 2016. See our policy and learn more at stonybrook.edu/tobaccofree.

Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation.  If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.   

About Stony Brook:

Stony Brook University, home to many highly ranked graduate research programs, is located 60 miles from New York City on Long Island's scenic North  Shore. Our 1,100-acre campus is home to 24,000 undergraduate, graduate, and doctoral students and more than 13,500 faculty and staff. SBU is a comprehensive research-intensive university and a member of the prestigious Association of American Universities (AAU), which includes 34 public universities among its 62 members. SBU consists of 12 schools and colleges and a teaching hospital that provides state-of-the-art healthcare in the Long Island region. SBU also manages and performs joint research with Brookhaven National Laboratory, the only Department of Energy Laboratory in the Northeast, and shares doctoral programs with Cold Spring Harbor Laboratory, a world-renowned molecular biology institute. Home to the Emerson String Quartet, the Jackson Pollock House in East Hampton, New York, the Humanities Institute, and the Southampton Arts Program, and with endeavors that extend to the Turkana Basin Institute in Kenya and the Ranomafana National Park in Madagascar, SBU sustains an international reputation that cuts across the arts, humanities, social sciences, and natural sciences.

 

Stony Brook University is an Affirmative Action/Equal Opportunity employer. We encourage protected veterans, individuals with disabilities, women and minorities to apply.

If you need a disability related accommodation, please call the University Human Resource Services Department at (631) 632- 6161 or the University Hospital Human Resources Department at (631) 444-4700.  In accordance with the Title II Crime Awareness and Security Act, a copy of our crime statistics is available upon request by calling (631) 632- 6350. It can also be viewed on line at the University Police website at http://www.stonybrook.edu/police.

Job Field: Information Technology
Primary Location: US-NY-Stony Brook
Schedule: Full-time
Shift: Day Shift
Posting Start Date: Feb 20, 2019
Posting End Date: Mar 22, 2019, 10:59:00 PM