How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location