Data Warehouse Engineer: On-Prem to Azure + Power BI

Matchtech; England; On-site; GBP 60,000 - 90,000; Full time

Job summary

Matchtech seeks an experienced Data Warehouse Developer to develop, support, and evolve a critical on-premises Common Data Environment (CDE) within an integrated business solution.

You will design, build, test, and optimise data warehouse solutions, enabling publication of paginated reports and Power BI dashboards through Azure-integrated services, supporting BI/MI needs across the organisation.

Qualifications

• Hold/eligible to obtain CTC Security Clearance.
• Full, clean driving licence.
• Undergraduate degree in Computer Science, Management Information Systems, Business Administration, Engineering, or a related discipline.

Responsibilities

• Define and maintain high-level and low-level data models.
• Create ETL designs, specifications, and implementation plans.
• Design, build, test, and optimise data warehouse solutions.
• Develop and maintain data pipelines that integrate multiple source systems.
• Ensure data quality, integrity, security, and performance across the data platform.
• Support the ongoing evolution of the Common Data Environment (CDE).

Skills

Data Warehousing Expertise

SQL Development

ETL Design and Development

Analytical Thinking

Technical Leadership

Stakeholder Management

Problem Solving

Communication Skills

Documentation and Governance

Agile Delivery

Service Management

Continuous Improvement

Education

Undergraduate degree in Computer Science, MIS, Business Administration, Engineering, or related discipline

Tools

Microsoft SQL Server

SSIS

SSRS

SSAS

Power BI

Power BI Paginated Reports

Microsoft Fabric

Azure Data Services

Azure Gateway Services

SharePoint

ETL Frameworks

Data Warehousing

Data Lakehouse Architecture

CI/CD Tooling

Microsoft Teams

Job description

Matchtech seeks an experienced Data Warehouse Developer to develop, support, and evolve a critical on-premises Common Data Environment (CDE) within an integrated business solution.

You will design, build, test, and optimise data warehouse solutions, enabling publication of paginated reports and Power BI dashboards through Azure-integrated services, supporting BI/MI needs across the organisation.