Donor Insights & Analytics Specialist

ATS Client; Cape Town; On-site; ZAR 350,000 - 650,000; Full time

Job summary

NSRI seeks a Data Analytics Specialist to join the Fundraising & Marketing team. You will build and maintain operational and management reporting, manage end-to-end execution of lists and donor selections, and deliver analysis that deepens understanding of donor base and campaign performance.

Your work will optimise fundraising performance, enhance donor engagement, and contribute to NSRI's mission through data insights and governance across cross-functional teams.

Qualifications

• Relevant diploma or degree in Statistics, Mathematics, Economics, Information Systems, Business Analytics or a related field.
• 2-4 years' experience in a data, business intelligence, reporting or analytics role.
• Strong SQL skills for data extraction, transformation and manipulation.
• Experience in developing and maintaining BI dashboards and reports.
• Advanced Microsoft Excel skills (Power Query, Power Pivot, etc, and data analysis functions).
• Experience in working with large volumes of transactional data.
• Confidentiality and working knowledge of POPIA and its implications for data handling and list management.
• Experience in fundraising, non-profit or call centre environments will be advantageous.

Responsibilities

• Develop and maintain SQL queries for reporting and analysis.
• Build and maintain Power BI dashboards and reports.
• Produce daily, weekly and monthly reports.
• Prepare call centre performance reports.
• Maintain reporting documentation and standard operating processes.
• Execute and maintain the agreed process for building and delivering calling lists, direct marketing selections and campaign audiences.
• Support day-to-day coordination with external list vendors, including tracking volumes, schedules, quality issues and escalations.
• Manage the end-to-end creation of calling list and campaign audiences.
• Build donor selections using agreed business rules.
• Support lead generation programmes and CRM data flows.
• Ensure compliance with POPIA and internal data governance requirements.
• Analyse donor behaviour and campaign performance.
• Identify trends, risk and growth opportunities.
• Produce insight reports and recommendations.
• Support campaign planning and performance review meetings.
• Monitor and maintain data integrity.
• Maintain the opt-out register.
• Identify data quality issues and work with Business, Product Owner and IT department to resolve.
• Work closely with Fundraising, Marketing, Finance and Call Centre teams.
• Translate business needs into reporting solutions.
• Manage multiple reporting and data requests and priorities.
• Support strategic decision-making through data analysis

Skills

SQL

Power BI

Excel

Data analysis

Data visualization

Education

Diploma or degree in Statistics or related field

Statistics / Economics / Information Systems / Business Analytics

Tools

Microsoft Power Platform

Microsoft Fabric

Job description

NSRI seeks a Data Analytics Specialist to join the Fundraising & Marketing team. You will build and maintain operational and management reporting, manage end-to-end execution of lists and donor selections, and deliver analysis that deepens understanding of donor base and campaign performance.

Your work will optimise fundraising performance, enhance donor engagement, and contribute to NSRI's mission through data insights and governance across cross-functional teams.