Job Description 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. 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. 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. Consideration for data warehouse/platform performance, including indexing, partitioning, and query tuning. • 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. • Collaborate with stakeholders to understand business requirements and translate them into technical specifications for data engineering solutions. • Continuously improve processes and codebases. • Design and deliver data warehousing solutions and key data engineering workstreams for any required solution. • Stay up to date with the latest trends, technologies, and best practices in data engineering.