Data Warehouse Solution Engineer

Interpath Advisory; Birmingham; On-site; GBP 55,000 - 75,000; Full time

Job summary

A leading advisory firm in Birmingham is seeking a Data Warehouse Solution Engineer to enhance their Azure data warehouse. The ideal candidate has over 5 years of experience in data engineering, strong SQL skills, and experience with Azure data bricks. This role offers a dynamic environment where you'll collaborate with finance and IT teams to operationalize data solutions for better business insights.

Benefits

Competitive salary

Comprehensive benefits package

Qualifications

• 5+ years of experience in data engineering, ideally in a senior role.
• Strong experience with building and maintaining ETL processes.
• Experience managing CI/CD pipelines.

Responsibilities

• Collaborate with IT and finance to build a roadmap for business use cases.
• Own and evolve the Azure Data Warehouse.
• Ensure data integrity and compliance with regulatory requirements.

Skills

Data engineering best practices

SQL programming

Data modeling

Python for Azure data bricks

Analytical skills

Problem-solving skills

Tools

Azure Synapse Analytics

Power BI

DevOps (CI/CD)

Job description

Overview

We\'re looking for a Data Warehouse Solution Engineer to take ownership of evolving, maintaining, and supporting ourAzure 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.

• 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 (e.g., 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.
• 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 (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.

About Interpath

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.

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.

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