Data Architect

Response Informatics
Watford, United Kingdom
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Watford, United Kingdom

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Continuous Integration
Data Architecture
Data Warehousing
DevOps
Github
Performance Tuning
Power BI
SQL Databases
Cloud Platform System
Powerquery
Star Schema
Amazon Web Services (AWS)
Software Version Control
Data Pipelines
Redshift

Job description

Data & Semantic Modelling

  • Design and implement dimensional data models (star schema, fact/dimension design)

  • Build and manage enterprise-scale semantic models (Power BI datasets / tabular models)

  • Define modelling standards, reusable measures, hierarchies

  • Implementation of best practices rules of sematic modeling (Tabular Editor BPA)

Power BI Architecture (Premium)

  • Architect Power BI Premium solutions for large-scale analytics

  • Develop advanced DAX and optimise performance

  • Use Tabular Editor and DAX Studio for tuning and governance

  • Good to keep updated on the latest Microsoft Power BI Product releases and industry trends

GitHub & BI DevOps

  • Implement version control using GitHub for Power BI assets

  • Establish CI/CD pipelines for BI deployments

Cloud Data Platform (AWS)

  • Integrate Power BI with Amazon Redshift, Power BI Gateways

  • Ensure optimised data pipelines and BI consumption

Governance

  • Implement OLS, RLS, security, and compliance

  • Define semantic layer best practices

Requirements

We are looking for a highly skilled Data / BI Architect with strong expertise in data modelling, semantic modelling, and enterprise Power BI architecture. The role requires hands-on experience with Power BI Premium, Tabular Editor, DAX Studio, and GitHub-based BI DevOps, along with exposure to AWS data platforms (Redshift, S3, etc.)., Data Modelling (Dimensional, Performance tuning)

  • Power BI Premium, DAX, Power Query

  • Tabular Editor, DAX Studio

  • GitHub (version control, CI/CD)

  • AWS (Redshift, S3)

  • SQL & Data Warehousing

Preferred

  • 12+ years experience

  • Microsoft certifications

  • Large-scale enterprise BI implementations

Apply for this position