2 days ago Be among the first 25 applicantsCompany DescriptionEvelyn Partners is a UK leader in wealth management, providing personalised, expert investment management and financial planning advice to support clients in embracing what's next.Company DescriptionEvelyn Partners is a UK leader in wealth management, providing personalised, expert investment management and financial planning advice to support clients in embracing what's next.Our success hinges on our people and that's our secret for longevity. We are a team of passionate professionals and everything we do is guided by our purpose - placing the power of good advice into more hands, we go further to understand the needs of our clients and what matters most to them. We're here to help them make significant decisions with confidence, provide strong foundations for the future and guide them towards their goals.Job DescriptionEvelyn Partners Data Services TeamAt Evelyn Partners, we are expanding our Data Services team, investing in a large-scale modernisation programme to drive innovation and insights. We’re building a new team to enhance data modelling, reporting, AI initiatives, and cloud data platforms like Snowflake.As part of our transformation, we’re growing our analytics capability to help develop the understanding of commercial performance and take the business to the next level. This means exciting opportunities for learning, upskilling, and working with the latest technologies.These roles can be based in Liverpool or Glasgow, with the requirement to be in the office to collaborate with colleagues twice a week.Why Join Evelyn Partners Data Services Team?Investment in Data: We recognise the power of data and are fully committed to growing a best-in-class team.Cutting-Edge Tech: Work with Snowflake, Power BI, and AI-driven solutions to shape the future of data analytics.People-First Culture: A collaborative, flexible, and supportive work environment.Career Growth Opportunities: Continuous learning and upskilling in new and emerging technologies.Impactful Work: Be at the forefront of transforming our data strategy and driving business success.If you’re a data professional looking for an opportunity to lead change and innovative, we want to hear from you.What will you be doing?As a Data Engineer, you will be responsible for designing, developing, and maintaining our MS SQL Server Data Warehouses and associated data feeds into and out of the warehouses, and developing on our new modern cloud data platform, requiring Snowflake, dbt and Azure Data Factory experience. Our data platform's support regulatory requirements, business intelligence & reporting needs and numerous system integrations. This role requires strong technical proficiency and a deep understanding of data engineering and data warehousing principles and practices.You will be critical in the development and support of the new Evelyn Data Platform, which is being engineered on Snowflake, utilising Azure Data Factory pipelines for data integration, dbt for data modelling, Azure BLOB Storage for data storage, and GitHub for version control and collaboration.As a Data Engineer, your responsibilities will include:Design, develop, and implement data warehouse solutions using Snowflake, Azure, and MS SQL Server.Develop data models and database schemas that support reporting and analytics needs.Extensive use of and fully conversant in SQL.Experience working with programming languages like C#, Python, Java, Spark.Create and maintain ETL/ELT processes to extract, transform, and load data from various sources into the data platforms.Design, develop, and deploy SSIS packages and ADF pipelines.Manage and troubleshoot SSIS packages and ADF pipelines, ensuring data integrity and error handling is robust.Document data warehouse architecture, ETL processes, and database configurations.QualificationsTo be successful in this role, you should:Proven experience building data pipelines in Azure Data Factory and Snowflake.Proficiency in MS SQL Server, including T-SQL programming, stored procedures, and functions.Extensive experience with SQL Server Integration Services (SSIS) & Visual Studio and Azure Data Factory (ADF) and GitHub, for ETL development.Experience building and maintaining reports using SQL Server Reporting Services (SSRS).Solid understanding of data warehousing concepts, including star/snowflake schemas, dimensional modelling, and data vault 2.0, and of the principles of ETL technical designAbility to write efficient and optimized SQL queries for data retrieval and manipulation.Solid understanding of data warehousing concepts and principlesSnowflake/Cloud Engineering experience is required:Proven experience working as a Data Engineer, preferably with expertise in Snowflake, ADF, Azure Storage, dbt and GitHub.Non-TechnicalBusiness Analysis skills to derive requirements from business stakeholders.Understanding of the principles of information security and data protection.Ability to communicate with non-technical colleagues at all levels of the organisation with confidence and with clarity.Professional Qualifications And EducationSnowPro CoreSnowPro Advanced: Data EngineerAzure Data FundamentalsAzure Data Engineer AssociateAdditional InformationAs a colleague here at Evelyn Partners, you will have access to benefits that include:Competitive salaryPrivate medical insuranceLife assurancePension contributionHybrid working model (role dependent)Generous holiday packageOption to purchase additional holidayShared parental leaveFully funded training towards professional qualificationsCycle to work schemeSeason ticket loanEye care supportWe are proud to value the differences that a diverse workforce brings, representative of society and our clients. At Evelyn Partners we have a wide range of highly active employee resource groups and we're delivering multiple diversity, equity and inclusion initiatives across the organisation. It is our commitment to provide a workspace where all colleagues, regardless of identity, background, or circumstance, feel respected as individuals and feel that they can achieve their full potential and work in a safe, supportive, and inclusive environment.We are happy to make any reasonable adjustments to accommodate for your needs throughout the application process. Please let your Recruiter know.Seniority levelSeniority levelAssociateEmployment typeEmployment typeFull-timeJob functionJob functionInformation TechnologyReferrals increase your chances of interviewing at Evelyn Partners by 2xSign in to set job alerts for “Data Engineer” roles.Glasgow, Scotland, United Kingdom 3 weeks agoData/Artificial Intelligence Engineer (KTP Associate)Glasgow, Scotland, United Kingdom 2 days agoGlasgow, Scotland, United Kingdom 2 days agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 3 days agoGlasgow, Scotland, United Kingdom 4 days agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 3 days agoGlasgow, Scotland, United Kingdom 3 weeks agoGlasgow, Scotland, United Kingdom 2 days agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 1 week agoSoftware Engineer II- Python and DatabricksGlasgow, Scotland, United Kingdom 1 week agoPython and Kubernetes Software Engineer - Data, AI/ML & AnalyticsGlasgow, Scotland, United Kingdom 3 months agoGlasgow, Scotland, United Kingdom 2 weeks agoStirling, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 day agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 2 weeks agoGlasgow, Scotland, United Kingdom 3 days agoGlasgow, Scotland, United Kingdom 1 week agoPython and Kubernetes Software Engineer - Data, Workflows, AI/ML & AnalyticsGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 1 week agoGlasgow, Scotland, United Kingdom 2 days agoSoftware Engineer (Python/Linux/Packaging)Glasgow, Scotland, United Kingdom 6 months agoWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr