At a Glance
- Tasks: Design and maintain data warehouses using cutting-edge tech like Snowflake and Azure.
- Company: Join Evelyn Partners, a UK leader in wealth management focused on personalised financial advice.
- Benefits: Enjoy competitive salary, private medical insurance, hybrid working, and generous holiday packages.
- Other info: Diversity and inclusion are core values; we support all colleagues in achieving their potential.
- Why this job: Be part of a people-first culture with opportunities for continuous learning and impactful work.
- Qualifications: Experience in data engineering, SQL, and cloud platforms like Snowflake and Azure is essential.
The predicted salary is between 36000 - 60000 £ per year.
2 days ago Be among the first 25 applicants
Company Description
Evelyn 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 Description
Evelyn 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 Description
Evelyn Partners Data Services Team
At 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.
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.
To 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 design
- Ability to write efficient and optimized SQL queries for data retrieval and manipulation.
- Solid understanding of data warehousing concepts and principles
- Snowflake/Cloud Engineering experience is required:
- Proven experience working as a Data Engineer, preferably with expertise in Snowflake, ADF, Azure Storage, dbt and GitHub.
- Business 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.
- SnowPro Core
- SnowPro Advanced: Data Engineer
- Azure Data Fundamentals
- Azure Data Engineer Associate
As a colleague here at Evelyn Partners, you will have access to benefits that include:
- Competitive salary
- Private medical insurance
- Life assurance
- Pension contribution
- Hybrid working model (role dependent)
- Generous holiday package
- Option to purchase additional holiday
- Shared parental leave
- Fully funded training towards professional qualifications
- Cycle to work scheme
- Season ticket loan
- Eye care support
We are happy to make any reasonable adjustments to accommodate for your needs throughout the application process. Please let your Recruiter know.
Seniority level
Seniority level
Associate
Employment type
Employment type
Full-time
Job function
Job function
Information Technology
Referrals increase your chances of interviewing at Evelyn Partners by 2x
Sign in to set job alerts for “Data Engineer” roles.
Glasgow, Scotland, United Kingdom 3 weeks ago
Data/Artificial Intelligence Engineer (KTP Associate)
Glasgow, Scotland, United Kingdom 2 days ago
Glasgow, Scotland, United Kingdom 2 days ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 3 days ago
Glasgow, Scotland, United Kingdom 4 days ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 3 days ago
Glasgow, Scotland, United Kingdom 3 weeks ago
Glasgow, Scotland, United Kingdom 2 days ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 1 week ago
Software Engineer II- Python and Databricks
Glasgow, Scotland, United Kingdom 1 week ago
Python and Kubernetes Software Engineer - Data, AI/ML & Analytics
Glasgow, Scotland, United Kingdom 3 months ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Stirling, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 day ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 2 weeks ago
Glasgow, Scotland, United Kingdom 3 days ago
Glasgow, Scotland, United Kingdom 1 week ago
Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 1 week ago
Glasgow, Scotland, United Kingdom 2 days ago
Software Engineer (Python/Linux/Packaging)
Glasgow, Scotland, United Kingdom 6 months ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-LjbffrData Engineer in Glasgow employer: Evelyn Partners
Evelyn Partners is an exceptional employer, offering a dynamic and supportive work culture that prioritises collaboration and innovation. With a strong commitment to employee growth through continuous learning opportunities and access to cutting-edge technologies, team members can thrive in their careers while making a meaningful impact on the company's data strategy. Located in vibrant cities like Liverpool and Glasgow, employees enjoy a flexible hybrid working model and a comprehensive benefits package that enhances their overall well-being.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in Glasgow
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Evelyn Partners!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Evelyn Partners.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Evelyn Partners.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Evelyn Partners, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer in Glasgow
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Evelyn Partners, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Evelyn Partners. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Evelyn Partners
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Evelyn Partners!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
