Data Developer (12 month contract)

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

Benefits offered by this job

Occupational pension

Income protection

Private medical insurance

Mental health resources

Health and wellbeing services

Emergency back-up care support

Parental leave

Holiday entitlement increasing with/at

Holiday trading

Season ticket loans

Discounts and lifestyle services

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. You will design, build and support modern cloud-based data solutions using the Microsoft Fabric platform and help business stakeholders make data-driven decisions.

You will work on end-to-end data pipelines, lakehouses, warehouses, and reporting with strong SQL, ETL/ELT, and governance. The role emphasizes collaboration, documentation, and CI/CD practices.

Qualifications

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

Responsibilities

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

Skills

SQL development

ETL/ELT design

Lakehouse/Data Warehouse

Data Pipelines/Notebooks

Data modelling (star schemas)

Power BI models & reporting

Data governance & security

Git & CI/CD

Analytical problem solving

Cloud data platforms

Tools

SQL Server - TSQL

XSLT

Azure DevOps

Power Platform

SSRS

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.