Senior Data Analyst

Stony Brook University•Stony Brook, NY

1d•Onsite

About The Position

The Senior Data Analyst will support the Stony Brook University Office of Advancement and the Stony Brook Foundation by transforming data into meaningful insights that inform fundraising and engagement strategies. The Senior Data Analyst will be responsible for reporting, analysis, and data quality initiatives, applying deeper technical expertise and analytical judgment to ensure accuracy and efficiency across Advancement systems. The Senior Data Analyst will collaborate closely with colleagues across departments to strengthen data-driven decision-making and support Advancement and institutional goals.

Requirements

Bachelor's degree (foreign equivalent or higher).
Three (3) years of full-time experience in data analytics, reporting, data management, database applications and/or related experience.
Proficiency with SQL.
Experience with data visualization and analysis software (Tableau, Power BI).
Proficiency in Python.

Nice To Haves

An additional year (1+) of full-time experience in data analytics, reporting, data management, database applications and/or related experience.
Experience working in a university, nonprofit and/or hospital setting.
Experience working with fundraising systems such as Raiser’s Edge, Salesforce Ascend or similar CRM platforms.
Experience with Monday.com.

Responsibilities

Design, build and maintain reports, dashboards, and visualizations using Tableau, SQL, and Excel.
Conduct complex, in-depth analyses to identify patterns, measure campaign effectiveness, and support decision-making across Advancement.
Translate complex data into clear insights that can be easily understood by leadership and staff.
Design and automate workflows and streamline reporting processes to increase efficiency.
Test, debug, and enhance reporting tools to ensure accuracy and user-friendliness.
Evaluate, recommend new tools and technologies that support Advancement's data capabilities.
Develop and maintain quality assurance procedures for reporting tools to ensure accuracy, scalability, and user-friendliness; support testing and continuous improvement cycles.
Apply and maintain data security controls, including role-based or row-level access, to protect sensitive Advancement data in accordance with established security protocols.
Partner with Advancement teams to understand data needs, provide guidance on data interpretation, and ensure reporting aligns with division goals.
Provide guidance to colleagues on data interpretation and usage to strengthen data-driven decision-making.
Coordinate various cross-departmental projects, ensuring data insights are aligned with Advancement’s strategic priorities.
Present findings and recommendations to leadership, translating data into compelling narratives that support strategic planning.
Maintain and apply data integrity standards within various Stony Brook Foundation and Advancement systems.
Lead regular data cleansing routines, troubleshoot discrepancies, and implement solutions for long-term accuracy.
Develop and maintain standards, processes, and validation procedures to ensure consistency and reliability across datasets.
Develop and maintain clear documentation of processes, procedures, protocols, and related guidelines.
Stay current with evolving data analytics tools, best practices, and industry trends. Share knowledge with colleagues to foster a culture of learning and continuous improvement.
Other duties as assigned.