Data Warehouse Solution Engineer

Interpath Advisory
London

Interpath is an international and fast-growing advisory business with deep expertise in a broad range of specialisms spanning Deals, Advisory and Restructuring capabilities.

We deliver tangible results for global businesses, their investors, and stakeholders when complex problems arise, and critical decisions need to be made. Interpath is agile, independent, and conflict-free, and our passion for doing what’s right, every time, sets us apart.

Our diverse teams provide specialist technical knowledge combined with deep sector experience across our service line specialisms. Since our foundation in 2021, Interpath has grown rapidly, and we now have a presence across the UK, Ireland, France, Germany, Austria, Spain, BVI, Cayman Islands, Bermuda, Barbados, and Hong Kong. By 2030 we aim to be one of the world’s leading advisory firms with a truly global footprint.

We’re looking for a Data Warehouse Solution Engineer to take ownership of evolving, maintaining, and supporting our newly established Azure data warehouse. In this hands-on role, you’ll collaborate with the Applications Team, Finance, the Data Governance & Quality Manager, and the wider IT function to ensure our data remains accurate, timely, and trusted.

This is a fantastic opportunity to help shape how data is used across the business. You’ll play a central role in extending our Azure data warehouse through new system integrations, enabling deeper insights that support smarter, faster decision-making at every level of the firm.

With a small but growing team, we’re looking for someone ready to wear multiple hats—from business/data analysis to solution design, implementation, and testing. The core foundation is in place—now we need someone to help operationalise and scale it, turning potential into business value.

Key Accountabilities:

  • Working closely with colleagues in IT and other internal teams, notably Finance, build a roadmap of business use cases to ingest into the data warehouse to fuel reporting & dashboards.
  • Own, monitor, and evolve the current Azure Data warehouse, developing and implementing data engineering best-practice (e.g., source-to-target mappings, coding standards, data quality, etc.), working closely with the external party who setup the environment .
  • Create and maintain ETL processes, data mappings & transformations to orchestrate data integrations.
  • Ensure data integrity, quality, privacy, and security across systems, in line with client and regulatory requirements.
  • Optimize data solutions for performance and scalability. Explore new data management and processing techniques, making recommendations where appropriate.
  • Adhere to Interpath’s software engineering best practices (eg, technical design, review, unit testing, monitoring & alerting, source code management and review, and documentation).
  • Become a subject matter expert and point of contact on available data within the business. Collaborate with stakeholders to understand their data needs and create data models accordingly.

Requirements

  • At least five years of experience in all aspects of the data engineering role, ideally as a senior or lead engineer.
  • Hands on experience of building and maintaining Python based Azure data bricks notebooks in Azure synapse analytics.
  • Strong SQL experience, including programming ie, SQL queries and stored procedures, and formal database design methodologies.
  • Experience in setting up monitoring and data quality exception handling.
  • Strong data modelling experience.
  • Experience managing and developing CI/CD pipelines.
  • Experience with Microsoft Azure products and services, and proficiency in ETL processes.
  • Experience of working with APIs to integrate data flows between disparate cloud systems.
  • Strong analytical and problem-solving skills, with the ability to work independently and collaboratively.
  • The aptitude to quickly understand information, business models and business requirements.
  • Strong written and verbal communication skills, with the ability to establish credibility and develop effective business relationships with colleagues.

Desirable Criteria:

  • C# coding knowledge.
  • Logic Apps and Azure Integration Services.
  • Experience in semi / fully unstructured datasets and NoSQL environments
  • Awareness of working in a regulated environment, with experience of data legislation and cyber security accreditations e.g., GDPR, ISO27001, Cyber Essentials.
  • Expertise in Business Intelligence, ideally via Power BI for data visualization and reporting
  • Use of DevOps (CI/CD) concepts to test, schedule, and deploy to a production environment.
  • Experience of working in a financial services firm.

Benefits

Benefits

At Interpath, our people lie at the heart of our business. That's why we provide employees with a competitive and comprehensive reward package including compelling salaries and a range of core and optional benefits. Read more about our benefits; Company Benefits - Interpath

Unsolicited Resumes from Third-Party Recruiters

Please note that Interpath do not accept unsolicited resumes from third-party recruiters. Any employment agency, person or entity that submits an unsolicited resume does so with the understanding that Interpath will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.

Posted 2025-07-04

Recommended Jobs

Research Analyst

Aquent
London

Role Title: Research Analyst Location: London, hybrid (3 days per week onsite)  About the Role: An exciting opportunity has arisen to join a global team dedicated to supporting govern…

View Details
Posted 2025-07-10

Escalator Engineer - F/M/X

WeMaintain
London

Join our team as we lead the way in escalator engineering innovation and maintenance excellence. We are passionate about enhancing mobility solutions through technology and expert craftsmanship. W…

View Details
Posted 2025-05-23

Quality Assurance Analyst

Harrison Holgate
London

Quality Assurance Analyst - London/ Hybrid A leading global insurance organisation is seeking a Quality Assurance Analyst to support its business change initiatives by ensuring accuracy, compliance, …

View Details
Posted 2025-06-05

Backend Engineer (Python)

LinuxRecruit
London

Opportunities to make a real impact are few and far between. We all like to think that we are making a positive impact but this company genuinely is. They are transforming people's lives through the …

View Details
Posted 2025-07-09

Employment Lawyer

Lipson Lloyd-Jones
London

THE FIRM A top West End award-winning boutique Firm THE ROLE For an employment solicitor ready to take the next step in their legal career. A talented 2-4PQE Employment Lawyer is sought…

View Details
Posted 2025-07-03

Scala / Java Developer Fintech / Blockchain Cryptocurrency

Quant Capital
London

Scala / Java Developer Fintech / Blockchain Cryptocurrency If you are an exceptional programmer in any language, please apply! £100,000 pa + benefits or up to £750pd Quant Capital is urgen…

View Details
Posted 2025-07-09

Calling all 2025 Graduates!

Katie Bard (Angela Mortimer Plc)
London

Are you seeking an office based role on both a temporary and permanent basis? This is the PERFECT opportunity for you! This is a great way to build your experience within the corporate environment,…

View Details
Posted 2025-07-02

Chef de Partie (Staff Canteen) - London Hilton on Park Lane

Hilton
London

Chef de Partie (Staff Canteen) - London Hilton on Park Lane WELCOME TO A WORLD OF OPPORTUNITIES AT THE UK\\\\\\\'s #1 GREAT PLACE TO WORK 2025, AS VOTED BY OUR TEAM MEMBERS! A new era begins at th…

View Details
Posted 2025-07-05

Commercial Gas Engineer

Skilled Careers
London

Commercial Gas Engineer needed in London Commercial Gas Installer needed for a company that specialises in plant room installations £55,000 per annum Van and Fuel Card Provided 5 days a week …

View Details
Posted 2025-07-01

Pricing Data Scientist in London

London

Job description PRICING DATA SCIENTIST LONDON- HYBRID UP TO £65,000 Join a fast-growing motor insurtech company, revolutionizing the insurance industry through data-driven insights, inno…

View Details
Posted 2025-07-06