Data Engineer

Kennedys is looking for a Data Engineer, with skills in General Data analysis and data architecture to join our Data Services team and support the Reporting & Analytics programme. You will be responsible for designing and maintaining our enterprise data platform, assisting in data analysis and general data architecture activities for our existing and new enterprise data platform, and ensuring data flows seamlessly from source systems into our Snowflake environments. Your focus will be on building the right enterprise data platform, ensuring current system design and implementations are valid, ensuring robust data pipelines, managing transformations in Snowflake in order to deliver high-performance data models that directly support our Power BI reporting layer.

Kennedys' strategic ambition is to achieve significant revenue growth through continued expansion and enhanced global reach. In support of this, a range of change initiatives forming part of an Investment Portfolio will deliver more forward looking, scalable, and value-driven business services to the firm and its clients.

The Reporting & Analytics programme aims to deliver a firm-wide reporting and analytics ecosystem underpinned by robust data governance and a unified data strategy.

Team

Kennedys IT team is responsible for delivery of a responsive, effective and timely service to the firm's partners and employees.

They devise and implement operational processes and procedures in order to provide reliable and available IT systems to the firm and ensure the firm has proper applications from which to service its clients.

Our IT Development Team is responsible for the creation and maintenance of bespoke applications that enable the firm to perform more productively or to deliver competitive advantages

Key responsibilities

Analyze the current datasets to prioritize and design and implement the enterprise data platform, design and implement a dimensional model within Snowflake to serve as the foundation for enterprise reporting & analytics

Build and maintain production-grade data transformation workflows, ensuring code is version-controlled, tested, and documented

Optimize Snowflake warehouses to ensure cost-efficiency and query performance

Develop and manage data pipelines using Azure Data Factory (ADF) to ingest data from various data sources

Automate and monitor data loads to ensure timely availability of data for the business

Manage Role-Based Access Control (RBAC) and data masking policies within Snowflake to protect sensitive legal and client data

Contribute to the definition of engineering standards, naming conventions, and CI/CD practices for the data platform

Required experience

Strong hands-on experience with general data analysis, data architecture, data dictionaries, data taxonomy and enterprise data models

Strong hands-on experience with Snowflake architecture, administration, and performance optimization

Experience with Azure Data Factory (ADF) for orchestration and ingestion

Deep understanding of dimensional modelling and data warehousing concepts

Ability to translate technical data concepts for non-technical legal and business stakeholders

Experience in Professional services or Legal Industry, desirable.

Please let us know if you require any additional support or adjustments to be made in order to submit your application to Kennedys.

where a level of experience is indicated, this is a guideline only and represents the amount of time we would usually expect a candidate to accumulate the requisite level of experience. This does not preclude applications from candidates with more or less experience.