Data Engineer

• Monitor the data engineering support board for incoming queries and move to resolution.
• Write and create SQL scripts, queries, views, indexes and optimisations.
• Document data flows and solutions and undertake analytical tasks making sure data is up to date.
• Model data sources using techniques such as Data Flow Diagrams, Entity Relationship Diagrams, Schema Mappings and DDL.
• Undertake data extractions, transformations, loading (ETL), testing, unit, integration and smoke.
• 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 no more than once a month on average., To achieve our vision of a world where woods and trees thrive for people and nature, we need to better reflect society and the communities we work in. All people, no matter their background, identity, ability, or circumstance, should benefit from trees. 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. Please contact us to discuss any additional support or adjustments you may need to complete your application.

Application 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 would encourage you to apply. Even if you don't meet every requirement of the role, we would encourage you to apply.

Acceptable Use - Artificial Intelligence (AI): We understand that candidates may choose to use AI tools to support their job applications-for example, to help structure or edit written responses. We welcome the use of AI in this way, particularly where it helps improve accessibility, such as for neurodivergent applicants. 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. If you require any adjustments or support during the recruitment process, please contact recruitment@woodlandtrust.org.uk

Do you have experience in Scripting?, * Experience working as a data engineer or a similar data focused role.

• Experience of cloud-based data platforms and tooling particularly in Azure.
• Knowledge of SQL query authoring using MS SQL and Azure SQL.
• Strong collaboration skills with the ability to work closely with a range of stakeholders.
• Experience of scripting language such as Python, R, BASH/Shell, JavaScript.
• Knowledge of Rest API's.
• Experience integrating with Dynamics 365 into data warehouse.
• Strong communication skills with the ability to communicate complex data terminology to a variety of stakeholders within the organisation.
• Experience using data modelling techniques such as OOD and DFD's.

Pulled from the full job description

• Annual leave
• Employee assistance programme
• Company pension, Joining our team means you'll be a big part of tackling environmental and climate issues. We take good care of our staff, offering support and training opportunities. We also offer:
• Enhanced Employer Pension
• Life Assurance
• Flexible & Hybrid Working Options
• Generous Annual Leave - 25 Days Plus Bank Holidays (pro rata'd for part-time)
• Buy and Sell Holiday Scheme
• Enhanced Parental Pay
• Employee Assistance Programme

The Woodland Trust is the UK's largest woodland conservation charity. We want to see a world where trees and woods thrive for people and nature. The Trust engages and inspires people to make their difference tackling the nature and climate crisis helping protect, restore and create our vital woods and trees. Our Commitment to Diversity and Inclusion