Castle Howard, set in the stunning Yorkshire countryside near York, is a historic estate that has been open to the public since 1952. As a family home with over 300 years of history, it attracts over 300,000 visitors annually with its breathtaking house, gardens, seasonal events, and award-winning attractions.
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.
This is a full-time position, however, we will also consider part-time applications.
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
Knowledge & Experience:
* Some knowledge of data extraction, transformation, and loading (ETL)
* Introductory experience working with Power BI
* Advanced Excel skillset
* 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
#J-18808-Ljbffr