Business Intelligence Analyst

The Woodland Trust is looking for a Business Intelligence Analyst to support organisational insight and reporting activity. This is a key role in building a solid analytics platform across the business, including the design, creation, and implementation of insightful reporting.

The Role:

• Engage and build relationships with stakeholders in all parts of the business to define and produce insightful, accurate and automated BI for internal and external use, ensuring insight is meaningful and used effectively
• Work with multiple data sources using SQL, NoSQL, and cloud-based technologies (e.g. Azure Data Lakes, Azure SQL Servers, TSQL, JSON)
• Backward engineer existing reporting to facilitate change, investigate data issues, and optimise performance
• Work with Data Engineering teams to specify requirements for analytical reporting layers
• Provide accurate, real-time data intelligence to drive business decision-making
• Support the wider Data Team by contributing ideas and observations on Data Strategy and tactical activities.
• Learn new BI technologies, keeping up to date with the reporting and data analytical technology landscape to drive insight innovation across the business.
• Agree deadlines and communicate progress effectively with end-users, stakeholders, and your line manager.
• This is a hybrid position with a mix of home working and from our head office in Grantham, Lincolnshire. Head office attendance would be required once a month on average. Occasional travel to other offices and remote locations may also be required.
• This is a full-time, permanent contract.

The Candidate:

• Experience with T-SQL query writing and a good understanding of data architecture and query performance best practices.
• Experience with Power BI, connecting to data models built with Azure SQL Databases, and Power BI integration from Dynamics 365 CRM.
• Experience listening to, understanding and implementing requirements from end-users and communicating technical concepts to a varied audience.
• Advanced Excel skills including advanced Pivot tables and functions, and knowledge of data analysis methods and techniques.
• Understanding of release management, change control, quality assurance, and source control.
• Understanding of data governance, master-data-management, and how this aligns to GDPR and other regulatory requirements.
• Exposure to Power Automate or other workflow tools (desirable).
• Experience working with NoSQL databases and unstructured data outputs, and experience with cloud data platforms (e.g. Azure Data Lakes, Azure SQL Server) (desirable).

Benefits and Wellbeing:

Joining our team means you’ll be part of our fight for a greener, healthier planet for people and wildlife. We take good care of our staff, offering support and training opportunities. We also offer:

• Enhanced Employer Pension
• Life Assurance
• Flexible and hybrid working options (7am - 7pm)
• Generous annual leave - 25 Days plus Bank Holidays (pro rata for part-time)
• Buy and sell holiday scheme
• Enhanced parental pay
• Employee assistance programme

To support inclusivity and remove barriers for candidates, we publish all salaries upfront and proudly follow the We Show the Salary pledge. The salary listed is the set salary for this role, and we don’t ask applicants to state their current pay or expectations. If you choose to apply, we’ll take that as confirmation that the advertised salary meets your expectations.

About Us:

The Woodland Trust is the UK’s largest woodland conservation charity. We want to see a world where woods and trees thrive for people and nature. The Trust engages and inspires people to make a difference by protecting, restoring and creating woodland and getting more trees in the ground.

Our commitment to Diversity and Inclusion:

To achieve our mission, we need to better reflect society and the communities we work in. People of colour and disabled people are currently under-represented across the environment and conservation sector. If you identify as a person of colour and/or disabled, we particularly encourage you to apply.

Application information and advice:

For fairness we keep our candidates’ personal details hidden from the hiring managers, and we do not ask for your CV at application.

Make sure that you answer the application questions to show your relevant skills and passion for the role. Even if you don't meet every requirement of the role, we encourage you to apply.

Completed applications will be reviewed by a hiring manager and/or a member of the recruitment team, and you will receive an update on the outcome of your application via email.

Acceptable Use - Artificial Intelligence (AI):

We understand that candidates may choose to use AI tools to support their job applications. However, we ask that any information submitted reflects your own experience, skills and understanding. During interviews, candidates are expected to respond independently without the use of AI tools.

Apply now:

If you're ready to make a difference and grow with us, apply today. We might close advertising early if we get a lot of applications, so it's a good idea to apply soon. If we do close the advert early, and you have an application in progress, we will email you prior to closing to give you time to complete.

Interviews are expected to take place via Teams w/c 14th December.

For queries about this role, reasonable adjustments, or support with your application, please contact: recruitment@woodlandtrust.org.uk