Data Analyst / Business Intelligence and Insights Analyst

Job Description

Data Analyst / Business Intelligence and Insights Analyst who has a passion for working with data, and providing business intelligence that leads to action, a pro-active self-starter, who is patient and methodical in their work, and ableto focus bothon the technical aspects of data analysis and reporting, and also understand the strategic thinking that their work will contribute to is required for an international development organisation based in Rugby, Warwickshire, West Midlands.SALARY: Competitive + Excellent BenefitsLOCATION: Rugby, Warwickshire, West MidlandsJOB TYPE: Full-Time, PermanentWORKING HOURS: Flexible working/hours - full time roles are contracted at 35 hours per week, as well as remote working (between 2-3 days per week depending on the role)JOB OVERVIEWWe have a fantastic new job opportunity for a Data Analyst / Business Intelligence and Insights Analyst who has a passion for working with data, and providing business intelligence that leads to action, a pro-active self-starter, who is patient and methodicalin their work, and able to focus both on the technical aspects of data analysis and reporting, and also understand the strategic thinking that their work will contribute to.Working as a Data Analyst / Business Intelligence and Insights Analyst your main focus will be to provide reporting and research for the companys fundraising and marketing initiatives, helping to create a clear view of the marketing directorate performance.You will work closely with colleagues and key stakeholders to understand business intelligence requirements, scope out projects and deliver reporting to agreed specifications. Working closely with colleagues to ensure that reporting is used and a data-drivenculture established. The outputs from your work will lead to insight that supports strategy development, and future investment decisions.As a Data Analyst / Business Intelligence and Insights Analyst you will have proven experience in analysing data and producing reporting, ideally using some advanced techniques for data extraction and manipulation (such as SQL) and a modern data visualisationtool (such as Power BI or Tableau). Full training will be provided, to enable the postholder to develop into a fully rounded data analyst, including training in the maintenance and development of the companys in-house data warehouse.REQUIREMENTS - Data Analyst / Business Intelligence and Insights AnalystEssential

• A self-starter, able to work on own initiative to meet goals / objectives

• A champion for change, and committed to continuous improvement

• Experience of working with, manipulating and interpreting data

• Experience of delivering reporting / analysis and presenting information in engaging and clear ways

• The ability to build relationships with stakeholders and present complex information to a non-technical audience

• Advanced use of MS Excel (pivot tables, IF and VLOOKUP)

• Working knowledge of GDPR and data protection and fundraising regulations and compliance

Desirable

• An understanding of data warehousing techniques

• Expert user of MS Excel (PowerPivot / data model, VBA, statistical techniques)

• Working knowledge of SQL (basic SELECT statements, JOINS and GROUPING data, Common Table Expressions (CTEs), Partitions, Aggregate Functions)

• Experienced using a statistical analysis package such as SPSS and a working knowledge of statistical techniques such as CHAID and logistic regression

• Knowledge of market research techniques and methodologies

• Experience of producing reporting within Power BI

• Experience of working with The Raisers Edge

WHY JOINThe opportunity to work for an organisation that is making a positive difference to the lives of people worldwide, a friendly and supportive culture, working with values driven and highly engaged colleagues, work life balance and flexible working - theseare just some of the reasons why the organisation is a great place to work.Their new open plan offices are located in the centre of Rugby near to the train station.In addition, the organisation offers the following benefits:

• Flexible working/hours - full time roles are contracted at 35 hours per week

• The normal practice to operate an agile working policy, where flexible working hours are enabled as well as remote working (2 days per week depending on the role)

• 26 days holiday in addition to public holidays

• A pension scheme that new employees can join from day one of employment (rules apply) - employer contributes 10.5% of salary and the employee contributes 5%

• Life assurance (3 x annual salary)

• Bike to Work scheme

ADDITIONAL INFORMATIONThe organisation treats all applications for employment on their merits and do not take into consideration any factors that are not relevant to the job such as disability, race, age, religion, gender, gender reassignment or sexual orientation.The organisation is committed to safeguarding and protecting children and vulnerable adults and as such candidates will be subject to pre-employment checks including criminal checks and terrorist financing.The successful applicant must have the pre-existing right to both live and work in the UK.AWD online operates as an employment agency