Data Warehouse Solution Engineer

Interpath Advisory; Reading; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading advisory firm in Reading is seeking a Data Warehouse Solution Engineer to own and maintain their Azure data warehouse. This hands-on role requires extensive experience in SQL and data engineering practices. You will collaborate with internal teams to develop data solutions that enhance analytics and reporting capabilities. The ideal candidate has a robust understanding of Python and Azure services and is ready to contribute to decision-making with data-driven insights.

Benefits

Competitive salary

Comprehensive benefits package

Opportunities for growth

Qualifications

• At least five years of experience in data engineering.
• Hands-on experience with Python-based Azure data bricks notebooks.
• Experience with Microsoft Azure products and services.

Responsibilities

• Collaborate with teams to build a roadmap of business use cases.
• Own and maintain the Azure data warehouse.
• Create and maintain ETL processes for data integration.

Skills

Python

SQL

Data modeling

ETL processes

Data quality

Analytical skills

Problem-solving

Communication skills

Education

Bachelor's degree in a relevant field

Tools

Azure Synapse Analytics

Power BI

CI/CD pipeline tools

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