Job Purpose: This is a critically important position with the remit to design and deliver reporting, data analysis and action-orientated insight to enable and influence informed decision making across the organisation. Castle Howard is a world-renowned country house and estate of significant historical, cultural and ecological importance. As a Data Analyst you will partner with stakeholders from all areas of the business, including the Executive Chairperson and Chief Financial and Operating Officer. Your work will make a notable contribution towards delivering our purpose of preserving and nurturing Castle Howard for the benefit of current and future generations, the environment and local communities.Duties and Responsibilities:Collaborate with cross-functional teams to define and understand requirements for reporting and analysis from across the business.Collect, organise and integrate large datasets from multiple sources, including databases and spreadsheets, whilst maintaining data accuracy, consistency and completeness.Utilise Power BI to design, build and maintain insightful and user-friendly reports and dashboards.Provide ad-hoc reporting and analysis to serve specific requests and needs of the business.Where required, provide paper based paginated reports.Pro-actively identify and act on opportunities to deliver value-adding reporting, analysis, insight and data-driven recommendations to help the organisation fulfil its goals and purpose.Perform data cleansing, validat