Kennedys is looking for a Snowflake Data Engineer for a 12 month FTC to join our Data Services team. You will be responsible for maintaining our enterprise data platform, ensuring data flows seamlessly from source systems into our Snowflake environments. Your focus will be on building robust data pipelines, managing transformations in Snowflake in order to deliver high-performance data models that directly support our Power BI reporting layer.
Team
Kennedys IT team is responsible for delivery of a responsive, effective and timely IT support service to the firm's employees and clients. They devise and implement operational processes and procedures in order to provide reliable and available IT systems to the firm.
Key responsibilities
1. Design and implement a dimensional model within Snowflake, to serve as the foundation for enterprise reporting & analytics.
2. Build and maintain production-grade data transformation workflows, ensuring code is version-controlled, tested, and documented.
3. Optimize Snowflake warehouses to ensure cost-efficiency and query performance.
4. Develop and manage data pipelines using Azure Data Factory (ADF) to ingest data from various data sources.
5. Automate and monitor data loads to ensure timely availability of data for the business.
6. Manage Role-Based Access Control (RBAC) and data masking policies within Snowflake to protect sensitive legal and client data.
7. Contribute to the definition of engineering standards, naming conventions, and CI/CD practices for the data platform.
Required experience
8. Strong hands-on experience with Snowflake architecture, administration, and performance optimization.
9. Experience with Azure Data Factory (ADF) for orchestration and ingestion.
10. Deep understanding of dimensional modelling and data warehousing concepts.
11. Ability to translate technical data concepts for non-technical legal and business stakeholders.
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.
About Kennedys
Kennedys is a global law firm with expertise in dispute resolution and advisory services. With over 3,000 people in 45 offices across 18 countries around the world we have some of the most respected legal minds in their field.
Our lawyers handle both contentious and non-contentious matters, and provide a range of specialist legal services, for many industry sectors but we have particular expertise in litigation and dispute resolution, especially in defending insurance and liability claims.
We're a fresh-thinking firm, and we're not afraid to bring challenging new perspectives to the table way beyond the traditional realm of legal services. We empower our clients with a diverse range of ideas, tools and technology to make their lives easier, as well as delivering exceptional results, every time.
What do we have to offer?
We welcome high-performing lawyers, business services professionals, secretaries, graduates and apprentices to join our rapidly expanding global firm. Whatever your role at Kennedys, you'll be involved in exciting and stimulating work, where your input will make a difference.
Our culture and values form a big part of who we are and we take them seriously. We make a difference by being approachable, straightforward, supportive, distinctive and ambitious. Our are at the core of who we are and what make us a great firm to work with and for.
The Firm recognises the value of investing in our people's development and believes our culture and values contribute to the quality of our work and of our client relationships. With a culture of on-the-job and experiential learning, peer to peer learning, mentoring, resources and tools that enable you to drive your career, we can support your development in your current and future roles. A variety of other opportunities are available including secondments to clients and our global offices.
We strive to celebrate empower our people and ensure everyone can bring their authentic selves to work. We've created a culture based on client service, professional excellence, hard work and trust, where diversity, equity and inclusion (DE&I) is a key priority. We recognise that many of our people want to work for an employer that is aligned to their values, which is why we are building an inclusive culture, decarbonising our operations and supporting our people to thrive at work. Our people are the key to driving this change and helping us to make a difference to our clients, our people and the communities in which we live and work.
Kennedys is an equal opportunities employer and is committed to ensuring our recruitment processes are as inclusive as possible. We expect all employees to be aware of and comply with all relevant policies and procedures within their jurisdiction, including those relating to Information Security, Data Protection and Quality Management, refer any breach promptly to Risk & Compliance and to complete all mandatory training when requested.
Documents