Data Warehouse Solution Engineer

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

RoleWe\''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 and 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 and 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 and 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 and 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 i.e., 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

BenefitsAt 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 ResumesPlease 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.

Additional Details

Seniority level: Associate

Employment type: Full-time

Job function: Information Technology

Industries: IT Services and IT ..... full job details .....