Data Developer (12 month contract)

A&O Shearman; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

A&O Shearman in London is seeking a Data Developer to join the Group Finance - Technical Analysts team on a 12-month contract basis.

The role focuses on designing, building, and supporting modern cloud-based data solutions using Microsoft Fabric, with emphasis on scalable pipelines, lakehouses, and reporting to empower data-driven decisions.

Qualifications

• Strong SQL development and ETL/ELT design experience.
• Experience with Lakehouse/Data Warehouse architectures.
• Proven track record building data pipelines and reporting solutions.
• Knowledge of data modelling, including star schemas.
• Experience with Power BI semantic models and reporting.
• Understanding of data governance, security and performance optimization.
• Experience with Git and CI/CD deployment practices.

Responsibilities

• Design and develop end-to-end data solutions within Microsoft Fabric.
• Build and maintain data ingestion pipelines from multiple sources.
• Develop Lakehouse, Warehouse and OneLake solutions.
• Implement Medallion Architecture (Bronze/Silver/Gold) for data quality.
• Create ETL/ELT processes using Data Factory, Pipelines, Notebooks and Spark.
• Develop SQL scripts, stored procedures, views and data models.
• Monitor and optimise Fabric performance and security.
• Support CI/CD deployment and source control best practices.
• Collaborate with analysts and stakeholders to translate requirements.
• Produce technical documentation and knowledge transfer materials.

Skills

SQL development

ETL/ELT design

Lakehouse/Data Warehouse

Data pipelines

Star schemas/Dim modelling

Power BI modelling

Data governance & security

Git & CI/CD

Problem solving

Tools

Microsoft Fabric

Azure Data Services

Elite 3E IDE

Elite 3E Templates/Design Gallery

DevOps tooling

Azure DevOps

Job description

We are recruiting for a Data Developer to join our Group Finance - Technical Analysts team in London, on a 12 month contract basis.

Technical Analysts team - London

Provide high quality advice and relevant, accurate information to the decision makers in A&O Shearman, ensuring compliance with laws and regulations and delivering our service efficiently.

What you will do

Microsoft Fabric Data Developer to design, build, and support modern cloud-based data solutions using the Microsoft Fabric platform. The successful candidate will develop scalable data pipelines, data warehouses, lakehouses, and reporting solutions that enable business stakeholders to make informed, data-driven decisions.

• Design and develop end-to-end data solutions within Microsoft Fabric.
• Build and maintain data ingestion pipelines from multiple source systems.
• Develop and optimise Lakehouse, Warehouse, and OneLake solutions.
• Implement Medallion Architecture (Bronze, Silver, Gold layers) to support data quality and governance.
• Create and maintain ETL/ELT processes using Data Factory, Data Pipelines, Notebooks, and Spark.
• Develop, maintain, and enhance SQL scripts, stored procedures, views, and data models.
• Monitor and troubleshoot performance issues within Fabric environments.
• Implement security, access controls, and governance standards.
• Support CI/CD deployment processes and source control best practices.
• Collaborate with business analysts, architects, and stakeholders to translate requirements into technical solutions.
• Produce technical documentation and knowledge transfer materials.

What you will have

Technical Skills

• Strong SQL development skills.
• Experience designing and implementing ETL/ELT solutions.
• Knowledge of Lakehouse and Data Warehouse architectures.
• Experience with Data Pipelines, Dataflows Gen2, and Notebooks.
• Understanding of data modelling techniques, including star schemas and dimensional modelling.
• Experience with Power BI semantic models and reporting.
• Knowledge of data governance, security, and performance optimisation.
• Experience using Git and CI/CD deployment practices.
• Strong problem-solving and analytical skills.

Desirable

• Experience with Microsoft Fabric.
• Experience with Azure Data Services.
• Working with multi-currency financial information.
• Knowledge of PySpark or Spark SQL.
• Understanding of Microsoft Entra ID and security frameworks.
• Experience with DevOps and automated deployment pipelines.
• Knowledge of financial, legal, or professional services data environments.
• Elite 3E IDE 2.7 or later development experience is required
• Elite 3E Templates / Design Gallery knowledge would be highly advantageous

Toolsets

• SQL Server - TSQL
• XSLT
• Azure DevOps knowledge
• Power Platform (Power BI, Power Apps, Logic Apps and Power Automate) experience is highly advantageous
• Microsoft SQL Reporting Services would be advantageous

Personal Skills

• Analytical and inquisitive mind with ability to diagnose and resolve user queries.
• Quality orientation evidenced by attention to detail and high work standards.
• Calm and positive attitude to a dynamic environment.
• Focus on communication within the team and sharing knowledge and experience
• Proactive and self-motivated approach to organising time and handling multiple tasks simultaneously.

About A&O Shearman

A&O Shearman is a new global industry-leading law firm, with nearly 50 offices in 29 countries worldwide. Our fluency in English law, US law, and the laws of the world’s most dynamic markets, enables us to provide unmatched insight and seamless delivery to clients. We work on challenging and important deals and disputes that have the potential to shape the future.

We offer exceptional opportunities for our people; opportunities to work for the world’s leading businesses; to transform the status quo, and to deliver your best work, helping you and your career to thrive, while delivering unparalleled outcomes for our clients.

Whether you're helping clients solve complex challenges, transforming the ways we manage our business, or ensuring the smooth-running of our operations, this is an environment where you can belong and excel. We provide first-rate training and development, we are committed to an inclusive environment, and we provide support and ways of working that help you optimise your wellbeing.

What truly defines a career with us? We recruit the best and ask for the best of you. And together, we will redefine success.

Should you require additional support at any stage of the recruitment process due to a disability or a health condition, please do not hesitate to contact a member of our recruitment team who will work with you to provide any adjustments as required.

We are an equal opportunities recruiter and do not discriminate on the basis of race, colour, sex, religion, sexual orientation, national origin, disability, or any other protected characteristic.

We recognise that our people are our most valuable asset, which is reflected in the wide range of benefits that are available to our employees. Some of these benefits include: our occupational pension scheme, group income protection cover, private medical insurance, mental health resources and free apps, health and wellbeing services encompassing an onsite gym, wellbeing centre and GP service, emergency back-up care support, parental and special leave, holiday entitlement increasing with length of service, holiday trading, season ticket loans and online discounts and lifestyle management services.

Our approach to hybrid working seeks to combine and maximise the benefits of effective remote working with the benefits of being in the office. Our current hybrid working arrangements require office based working for a minimum of 60% of your time (i.e three days per week for a full time role) in accordance with our hybrid working policy.