At Clarion, our people are at the absolute heart of what we do. We’re proud that our core values of PASSION, CARE, IMAGINATION, and TRUST define the way we carry out our work across all of our exhibitions and conferences.

If you share our values and want to be a part of a successful, dynamic, and creative global business then we want to hear from you.

The Opportunity:

We have an exciting opportunity for a Data Warehouse Architect to join a rapidly growing data team in Clarion. The role will report into the Senior Architect, with responsibility to analyse product offerings against business requirements. Working with the Analytics team, developers, and testers you will be evaluating and identifying solutions to meet business needs. You will have the autonomy to be creative with design techniques, seeking to overcome complex challenges, and grow your design through developing skills with the new initiatives we are looking to explore.

Key Responsibilities:

• Analyse existing data design and suggest improvements that promote performance, stability, and interoperability.
• Work with product management and business subject matter experts to translate business requirements into good database design.
• Work with internal and external resources to develop robust Extract/Transform/Load (ETL) processes for disparate data sources.
• Strong knowledge of setting up and maintaining synapse pipelines within Azure.
• Good knowledge of acquiring data from various Rest, Soap, SFTP, Landing Zones and obtaining data for processing within Azure.
• Strong knowledge of setting up and maintaining deployment pipelines within Azure devops.
• Participate in the development of database architecture and roadmaps in support of business strategies.
• Provide technical expertise, estimates, and recommendations to the Senior Architect and Head of Data and Insight.
• Participate in the evaluation of emerging technology and tools.
• Provide technical expertise, estimates, recommendations, risks, and issues to Senior Architect and/or Project Management.
• Cloud security and compliance: Ensure that all data solutions comply with industry standards and company policies regarding security, data privacy, and compliance.
• Cost management and optimisation: Monitor and optimise cloud spending to ensure efficient use of Azure resources. Implement cost-saving measures such as automated scaling, choosing the right service tiers, and identifying underutilised resources.
• Develop and maintain disaster recovery and business continuity plans for Azure-based data solutions, ensuring minimal downtime and data loss in the event of a disruption.
• Regularly analyse system performance against key metrics, identify bottlenecks, and implement optimisations to improve efficiency and reduce latency.
• Design and manage dimensional data models and data warehousing strategies to support BI and analytics workloads. Ensure scalability and flexibility to accommodate future data growth.

Requirements

Knowledge, Skills & Behaviours:

• Proven experience as a data architect delivering solutions utilising:
• Azure Data Analytics platform including Azure Synaps
• Azure Logic Apps, Azure Functions, Azure Storage
• Azure SQL Data Warehouse, Azure Data Lake, Azure Databricks
• Azure Cosmos DB, Azure Data Factory, Azure Search, Azure Stream Analytics
• Delta Lake and Data Lakes
• Apache Spark Pools, SQL Pools (dpools and spools)
• Experience in Python, C# coding, Spark, PySpark, Unix shell/Perl scripting experience.
• Experience in API data sourcing using REST, Soap, and other API methodologies.
• Experience working with structured and unstructured data.
• Project management/agile delivery methodology in a leading role as part of a wider team.
• Power BI development experience using Azure technology and providing data.
• Experience designing and implementing machine learning solutions as part of high-volume data ingestion and transformation pipelines.
• Data Governance, Data Quality, MDM, Lineage, Data Catalog etc.
• Development experience using Presto/Hive, Digdag, YAML.

About Clarion Events

Clarion Events is one of the world’s leading event organisers, producing and delivering innovative and market-leading events since 1947. ((url removed))

Clarion Events embrace diversity and equal opportunities in all that we do. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Clarion is private equity backed and owned by Blackstone. Blackstone is one of the world’s leading global investment funds, investing capital for the long term in order to build successful, resilient businesses. ((url removed))

Our purpose is to deliver exceptional customer outcomes and experiences, by making every connection count.

Our vision is we want every one of our products to be a market leader in customer satisfaction and delight.

Benefits

• 25 days’ holiday plus bank holidays
• End of year wellbeing shutdown (closed for the last week of the year)
• Celebration day off (e.g. birthday, Diwali, Eid, etc)
• Summer Hours in August (3pm finish on Fridays)
• Helping Our World (HOW) Days – one paid day per quarter to carry out charity work
• Pension Scheme
• Private Medical Insurance
• Health Cash Plan
• Wellbeing Library (MYNDUP)
• Mentoring Programme
• Subsidised Café
• Season Ticket Loan
• Cycle to Work Schemes
• Free on-site gym and shower facilities
• Free eyesight tests
• Free flu vaccination – offered on site once a year for all employees