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, * 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

• 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.