Herbert Smith Freehills Kramer is a world leading global law firm. This role is focused on designing, building, and maintaining the firm's data engineering solutions in Azure cloud environments.
Key Responsibilities
- Manage the capture, storage and dissemination of data in the cloud infrastructure used by the business.
- Build and optimize large, complex data sets that meet functional and non functional business requirements.
- Implement data processes that deliver easy access to data domains, enabling self service and advanced analytics.
- Design and develop data lake and delta lake technologies for cloud data ingestion, classification, storage, and dissemination.
- Build and manage ETL/ELT pipelines using SQL and Azure big data technologies.
- Design and implement data models to enable analysts and data consumers to quickly access needed data, both structured and unstructured.
- Develop analytics technologies to provide actionable insights into customer acquisition, operational efficiency and other key performance metrics.
- Administer Azure databases, ensuring performance tuning, backup, recovery, and routine maintenance.
- Monitor access, audit logs and enforce data masking and encryption at rest and in transit, adhering to strict security protocols.
- Validate data quality using established frameworks and testing methodologies to ensure reliable, trustworthy data.
- Collaborate with stakeholders (Executive, Product, Data, and Design teams) to address data related technical issues and support infrastructure needs.
- Maintain separation and security of data across global boundaries through multiple data centres and Azure regions.
- Work with data and analytics experts to improve functionality of data systems.
- Manage data domains with stewards to generate consumable data products.
- Utilise metadata and master data management tools for reference data.
- Lead the technical implementation of the enterprise data warehouse and PowerBI reporting.
- Back fill management of the business intelligence/data management team until a manager is appointed.
Qualifications, Skills and Experience
- 5+ years of experience in a Data Engineer role.
- Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
- Advanced SQL knowledge and experience with relational databases and query authoring.
- Experience building and optimizing big data pipelines, architectures and datasets.
- Strong analytical skills for working with unstructured data.
- Proficiency in building processes for data transformation, metadata, dependency and workload management.
- Experience with message queuing, stream processing and highly scalable big data stores.
- Project management and organisational skills; ability to work cross functionally in a dynamic environment.
- Detailed experience in data modelling in cloud environments, both structured and unstructured.
- On call support experience for Enterprise Data Warehouse, Global Data Warehouse and global ETL processes.
- Microsoft Azure certifications highly considered (e.g., Azure Data Engineer Associate, DP 203).
- Working knowledge of Hadoop, Spark, Kafka, Storm, Spark Streaming and other big data tools.
- Experience with relational and NoSQL databases, data pipeline and workflow management tools.
- Proficiency in Python, Java, C++, Scala or similar scripting languages.
- Experience with Azure Data Factory, Azure Synapse Analytics, Azure Stream Analytics, Azure Event Hubs, Azure Data Lake Storage, Azure Databricks and PowerBI or similar visualisation tools.
- Innovative mindset, curiosity about AI and emerging technologies.
Location & Contract
London - Full time - Permanent
Diversity & Inclusion
We are committed to attracting people from all backgrounds and creating a respectful and inclusive culture where everyone thrives. This is an essential part of our success and a key part of our values - Human, Bold, and Outstanding.