At a Glance
- Tasks: Join us as a Data Engineer to design and maintain our cutting-edge data platforms.
- Company: Evelyn Partners is a leading UK wealth management firm focused on personalised financial advice.
- Benefits: Enjoy competitive salary, private medical insurance, hybrid working, and generous holiday packages.
- Other info: We value diversity and inclusivity, ensuring everyone feels respected and supported.
- Why this job: Be part of a passionate team driving data innovation in a collaborative and agile environment.
- Qualifications: Experience with Snowflake, Azure Data Factory, and SQL is essential; certifications are a plus.
The predicted salary is between 36000 - 60000 £ per year.
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.
Job Purpose
Evelyn Partners is recruiting a skilled and experienced Data Engineer to join a growing team to deliver a large data modernisation programme. As a Data Services 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. 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. The role will be working in an agile and collaborative environment within a growing and skilled team. An understanding of the wealth management industry, including products & services and the associated data, is a plus.
Key Responsibilities
- 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.
- Creation and maintenance of complex SQL stored procedures.
- Integrate data from various sources, including flat files, REST/SOAP APIs, and third-party databases, into the data warehouse/platform.
- Develop and maintain complex stored procedures, views, and functions in SQL to support data integration and reporting needs.
- Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions.
- Support the development of reports and dashboards using tools like SSRS, Power BI, or similar.
- Provide ad-hoc queries and data extracts to support business needs.
- Work closely with other engineers, DBAs, and Tech staff to ensure seamless data integration and system compatibility.
- Document data warehouse architecture, ETL processes, and database configurations.
- Maintain effective relationships with stakeholders and ensure communication is effective and timely.
- Provide time estimates for work so stakeholder expectations and resources can be managed.
- Continuously improve processes and codebases.
- Stay up to date with the latest trends, technologies, and best practices in data engineering.
Qualifications
Key Skills and Experience
Technical
- 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.
- Experience with SQL Server Analysis Services (SSAS) is a plus.
- Familiarity with data visualization tools such as Power BI or Tableau is desirable.
- Experience with source control tools like Git, and familiarity with DevOps practices is an advantage.
- Ability to write efficient and optimized SQL queries for data retrieval and manipulation.
- Snowflake/Cloud Engineering experience is required.
- Proven experience working as a Data Engineer, preferably with expertise in Snowflake, ADF, Azure Storage, dbt and GitHub.
- Extensive experience in designing, building, deploying, and supporting cloud-based data products and pipelines.
- Experience with Azure Storage services such as Blob Storage, Data Lake Storage, or Azure Files.
- Hands-on experience designing and developing data pipelines using Azure Data Factory.
- Experience of data warehouse design and implementation using Snowflake and dbt modelling.
- SnowPro and Microsoft Cloud certifications would be highly desirable.
- Experience with Azure AI Services and/or Snowflake Cortex AI would be a plus.
Non-Technical
- Strong coaching and mentoring skills.
- Calm under pressure and keen to highlight others' successes.
- Business Analysis skills to derive requirements from business stakeholders.
- Strong ability to extract information by questioning, active listening, and interviewing.
- Ability to quickly assimilate and understand business processes and information flow.
- Highly numerate with strong analytical and problem-solving skills.
- Ability to work on own initiative within agreed boundaries.
- Ability to work under pressure and manage conflicting priorities.
- Be flexible and adaptable to meet business deliverables.
- Willingness to travel to different office locations as required by the role.
- 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 clarity.
Professional Qualifications and Education
- SnowPro Core
- SnowPro Advanced: Data Engineer
- Azure Data Fundamentals
- Azure Data Engineer Associate
Additional Information
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 dependant)
- Generous holiday package
- Option to purchase additional holiday
- Shared parental leave
We 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.
Data Engineer in Bracknell employer: Evelyn Partners
Evelyn Partners is an exceptional employer, offering a dynamic and inclusive work culture that prioritises employee growth and well-being. With a commitment to diversity and a range of benefits including competitive salaries, private medical insurance, and a hybrid working model, we empower our Data Engineers to thrive in a collaborative environment while contributing to meaningful projects in wealth management. Join us to be part of a passionate team dedicated to making a positive impact on clients' financial futures.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in Bracknell
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as Snowflake, Azure Data Factory, and MS SQL Server. Having hands-on experience or projects showcasing these tools can significantly boost your chances.
✨Tip Number 2
Network with current employees or professionals in the wealth management sector. Engaging with them on platforms like LinkedIn can provide insights into the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Stay updated on the latest trends in data engineering and cloud technologies. Being able to discuss recent advancements or best practices during your interview can demonstrate your passion and commitment to the field.
✨Tip Number 4
Prepare to discuss your problem-solving skills and how you've handled data-related challenges in the past. Providing concrete examples will help illustrate your capabilities and fit for the role.
We think you need these skills to ace Data Engineer in Bracknell
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights relevant experience and skills that align with the Data Engineer role at Evelyn Partners. Focus on your proficiency in MS SQL Server, Azure Data Factory, and Snowflake, as well as any programming languages you are familiar with.
Craft a Compelling Cover Letter:In your cover letter, express your enthusiasm for the position and the company. Mention specific projects or experiences that demonstrate your expertise in data engineering and how they relate to the responsibilities outlined in the job description.
Showcase Relevant Projects:If you have worked on any relevant projects, either professionally or personally, be sure to include them in your application. Highlight your role, the technologies used, and the outcomes achieved, especially those involving data pipelines and cloud platforms.
Highlight Soft Skills:Evelyn Partners values strong communication and collaboration skills. Make sure to mention any experiences where you've successfully worked in teams or mentored others, as these qualities are essential for the role.
How to prepare for a job interview at Evelyn Partners
✨Showcase Your Technical Skills
Be prepared to discuss your experience with MS SQL Server, Snowflake, and Azure Data Factory in detail. Highlight specific projects where you've designed and implemented data pipelines or ETL processes, as this will demonstrate your hands-on expertise.
✨Understand the Wealth Management Sector
Familiarise yourself with the wealth management industry and its data needs. Being able to discuss how your skills can support the business's goals will show that you understand the context of your role within the company.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical and problem-solving abilities. Be ready to walk through your thought process on how you would tackle common data engineering challenges, such as optimising SQL queries or troubleshooting data integrity issues.
✨Demonstrate Collaboration Skills
Since the role involves working closely with business analysts and data scientists, be prepared to discuss your experience in collaborative environments. Share examples of how you've effectively communicated technical concepts to non-technical stakeholders.
