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 & 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, validation, and quality assurance procedures to ensure data integrity.
*Monitor data integrity and, in collaboration with the wider IT team, design and deliver measures to correct any identified anomalies.
*Assist in establishing and maintaining data governance practices, including data quality standards, data documentation, and data security protocols.
*Stay up to date with industry trends and best practices regarding reporting and analysis.
*Maintain and improve processes and practices regarding reporting and data analysis.


Person Specification
Education/Qualifications/Training:
*An under-graduate degree in a numerical subject requiring an analytical skillset and aptitude such as Computer Science, Data Engineering or a related field, is essential


Knowledge & Experience:
Essential:
*Some knowledge of data extraction, transformation, and loading (ETL)
*Introductory experience working with Power BI
*Advanced Excel skillset


Desirable:
*Familiarity working with APIs, including to retrieve data from external sources, API configuration and data mapping
*Some experience working with data sets drawn from multiple platforms and sources, as well as using SQL, SSIS, SSRS (or Power BI Report Builder)
*Introductory understanding of Data Warehouse design, development and maintenance


Personal Attributes:
*Pro-active and enthusiastic
*Inquisitive, with an accomplished critical thinking and problem-solving skillset
*Deeply analytical and data driven
*Attention to detail with a focus on quality of work
*A ’can-do’, service-based attitude with a solutions-based approach and a confident manner
*Able to self-organise and work independently under your own initiative, as well as part of a collaborative team, within a changing and dynamic organisation
*Composed, and with the ability to retain focus and deliver, even when operating under constraints; for example, with limited time and/or imperfect information
*Goal orientated and action-focused with a value-add mindset
*Objective, with a logical and unbiased approach to decision making
*Strong communication skills, with the ability to simplify complex material whilst maintaining impact and influence
*Able to engage and work with a diverse array of stakeholders, both internal and external, spanning multiple different business units, personality styles and levels of seniority
*Keen to make a difference – preferably within the heritage sector
*Committed to self-learning and personal development


Candidates with interesting, if not perfectly matched, professional experience but well-aligned personal attributes who wish to continue their career in a role with scope to make a real impact working for an organisation with a meaningful purpose, are encouraged to apply – we would love to hear from you to explore whether your next career step could be joining the team working towards saving one of the country’s most significant heritage assets.