York
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.