Business Intelligence Analyst

We are looking for a highly motivated and detail-oriented individual, with strong analytical and organisational skills, to join our Business Intelligence Unit, which works closely with our business stakeholders to provide key organisational information through effective data initiatives and promotion of a data-aware organisational culture. This role is responsible for contributing to the evolving data requirements of the organisation by providing analysis, developing models, data mining and developing and maintaining reports to support fundraising requirements.

Key Responsibilities:
 Work with a range of internal and external stakeholders to satisfy their business intelligence requirements for analysis, report creation, data extracts, data mining and data modelling within a strong project management framework.
 Design and implement reporting & business intelligence solutions using a variety of tools including Tableau, Power BI, or a similar reporting suite.
 Deliver analytics on the business critical objective of understanding how to maximise the value from our financial supporters; inclusive of optimizing the opportunity of moving supporters up the donor pyramid and forecasting potential growth. This will be in the form of data mining, profile analysis, building analytical models and BI report authoring.
 Produce regular KPI reports e.g. Lead Indicators Report (LIR), National Growth Fund Report (NGF), Quarterly reforecast reports, etc.
 Build predictive models and segmentation models to answer key business questions and help with DM targeting
 Address data extract requirements for direct marketing campaigns with a high degree of service; develop and refine data selections, build and check extracts, manipulate data in preparation for bulk communications and update records with contact history.


The successful applicant will possess the following attributes:
Essential
 Experience building models in spreadsheets. Comfortable writing formulas and VBA in Excel
 Excellent stakeholder management skills. Excellent communication and customer service skills with the ability to convert a descriptive brief into a business intelligence/analytical solution
 Sound database knowledge (e.g. MS Access, SQL, SAS or SPSS)
 Intermediate to strong SQL skills
 Tertiary qualifications in IT, Science, Maths, Accounting or quantitative course
 Minimum 2 years’ experience in a similar role
 Experience working with a relational database, ideally Raiser’s Edge or similar platform is desirable.