We are looking for an experienced Senior Data Engineer to join one of Adroit's clients, a global independent price reporting agency covering metals, mining, agriculture, forest products and energy transition markets.

The organisation is investing significantly in its data and analytics capabilities, moving from traditional formats such as PDFs, spreadsheets and standalone datasets towards scalable digital analytical products.

This role will help build the data foundations behind that transformation, while providing day-to-day technical leadership and oversight across the wider data engineering team.

The role is split across two principal accountabilities:

~50% Hands-on Data Engineering — Designing and building scalable data pipelines, models and data products within the Snowflake-based data platform.

~50% Team & Technical Oversight — Supporting the Data Platform & AI Manager with technical leadership, engineering standards, mentoring, delivery oversight and the development of the wider team.

You will:

• Design, build and maintain scalable data pipelines using Snowflake, Python, SQL and dbt.
• Help develop the layered data architecture, taking data from ingestion through cleansing, transformation and versioning into governed data marts.
• Build reusable, well-modelled data products that support multiple analytical and digital use cases.
• Develop robust ELT processes across structured and semi-structured data sources.
• Apply strong data modelling principles, including dimensional modelling and appropriate Data Vault patterns.
• Build automated testing, observability and data-quality controls into engineering workflows.
• Optimise workloads for performance, reliability, maintainability and cost.
• Work closely with analytics, BI and product teams to translate requirements into scalable, production-quality data models and datasets.
• Identify data quality, connectivity and architectural risks early and help resolve them before they impact delivery.

Alongside your hands-on engineering responsibilities, you will:

• Provide day-to-day technical guidance and support to Data Engineers within the team.
• Review code, designs and engineering approaches, helping maintain consistent standards and quality.
• Mentor engineers and support their technical development.
• Help onboard new team members and accelerate their understanding of the platform, architecture and engineering practices.
• Support the Data Platform & AI Manager with technical planning, prioritisation and delivery oversight.
• Help establish and embed reusable engineering standards, patterns and DataOps practices.
• Encourage effective knowledge sharing, documentation and collaboration across the team.
• Act as a senior technical point of contact, helping unblock complex engineering challenges and escalate risks where appropriate.

• Strong commercial experience as a Data Engineer or Senior Data Engineer.
• Excellent SQL and Python skills.
• Strong hands-on experience with Snowflake.
• Experience with dbt for transformation, testing and analytics engineering.
• Experience with orchestration tools such as Dagster, Airflow or Prefect.
• Strong understanding of dimensional modelling, data marts and analytical data structures.
• Experience designing scalable ELT pipelines across multiple data sources.
• Experience with Git, CI/CD and modern DataOps practices.
• Strong understanding of data quality, testing, lineage, monitoring and observability.
• Experience mentoring or technically supporting other engineers.
• Confidence reviewing technical work and helping establish engineering best practice.
• Strong communication skills and the ability to work effectively across engineering, analytics, BI and product teams.

• Data Vault or layered enterprise data architectures.
• Azure, although strong AWS or GCP experience is transferable.
• Kubernetes.
• Building data foundations for BI, analytics or customer-facing digital products.
• Working in fast-moving environments where data engineering and product development happen concurrently.

You'll be a strong hands-on engineer who enjoys remaining close to the technology while also helping others perform at their best.

You'll combine good engineering judgement with a pragmatic approach to delivery, balancing robust architecture and standards with the need to move quickly and deliver value.

This is a senior role for someone who wants to build, lead and influence, without moving away from hands-on engineering.