Data Architect

London: £66,038 to £90,802 per annum National: £60,076 to £82,605 per annum Location: Hybrid / Flexible base location Hours: 36 hours per week – flexible options considered Contract Type: Permanent Join our growing Data & Analytical team at one of LinkedIn’s Top Companies 2024 As a Data Architect at Clarion, you’ll design, develop, and manage the data architecture for BI & Data applications and collaborate with the wider Data & Analytics team to deliver high-quality data infrastructure and analytics solutions. Your expertise in database design, data integration, and data management will be critical in driving Clarion’s data-focused initiatives and ensuring the availability, performance, scalability, and reliability of Clarion’s data platform(s) by working with cross-functional teams to understand data requirements and deliver robust solutions such as data marts and evolving the Clarion Enterprise Data Warehouse. You’ll build rapport with Business Intelligence Analysts and stakeholders and be responsible for two Data Engineers in your immediate team. You’ll be confident in people management, providing constructive feedback where appropriate and putting forward ideas. This is a critical role that requires a deep understanding of data architecture principles and excellent critical thinking skills. About You You’ll have a deep understanding of data modelling, database design, and data management principles, encompassing both relational and non-relational databases, data warehousing, ETL processes, and cloud-based data storage solutions like AWS and Azure. Expertise in data modelling methodologies (Kimball, DataVault) is essential, as is hands-on experience with RDBMS (preferably Snowflake or SQL Server) and large-scale data processing through ETL pipelines. Familiarity with Git or MS Visual Studio TFS, data orchestration tools like ADF, AirByte, Airflow, or Luigi, and a high competency in SQL are required. The role demands confident programming skills (C#, Python, or JavaScript) with a focus on data manipulation and integration, alongside excellent problem-solving abilities and attention to detail in a fast-paced environment. If you have the skill set and experience we’re looking for, we would love to hear from you! With hybrid working, flexible base locations, and flexible working arrangements, this could be the opportunity you’ve been looking for! Please review the full role profile before applying – Data Architect Salaries are just the starting point. Here at Clarion, we’re dedicated to rewarding hard work and commitment, and providing benefits that support you and your lifestyle – dive in and find out more here. You must be eligible to work in the UK to apply for this vacancy; Clarion are not able to offer visa sponsorship. You are required to reside in England or Wales for the duration of your employment. This vacancy may close without notice. #J-18808-Ljbffr