Data Analyst in York

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.