Data Analyst

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.