Business Intelligence Analyst

The Woodland Trust; Grantham; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Enhanced Employer Pension

Life Assurance

Flexible and hybrid working (7am-7pm)

Generous annual leave (25 days + BH)

Job summary

The Woodland Trust is seeking a Business Intelligence Analyst to support organisational insight and reporting. This role builds a solid analytics platform across the business, designing, creating and implementing insightful reporting.

You will engage stakeholders, work with diverse data sources (SQL, NoSQL, Azure), optimise performance and deliver accurate data to inform decisions. The role is hybrid from Grantham with occasional travel and a full-time permanent contract.

Qualifications

• Experience writing T-SQL and understanding data architectures.
• Proficient in Power BI and Azure data sources.
• Strong Excel skills and data analysis techniques.
• Knowledge of GDPR, data governance and release/change control.

Responsibilities

• Build and automate BI for internal and external use with stakeholders.
• Integrate data from SQL, NoSQL and cloud sources; ensure performance.
• Backwards engineer existing reports and optimise dashboards.
• Collaborate with Data Engineering to define analytic layers.
• Provide real‑time data intelligence to drive decisions.
• Contribute to Data Strategy and initiative planning.

Skills

T-SQL

Power BI

Stakeholder communication

Excel advanced

Data governance

GDPR understanding

Release management

Change control

Cross-functional collaboration

Tools

Azure Data Lakes

Azure SQL Server

Dynamics 365 CRM integration

NoSQL databases

Power Automate

Job description

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.

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.

For queries about this role, reasonable adjustments, or support with your application, please contact: [e-mail]