Senior Data Modeller (London based)

About the Position

We are seeking a talented Senior Data Modeller – Analytical Solutions to lead the design of enterprise-scale analytical data models for our new data platform built on Azure Data Stack (Azure Databricks & Microsoft Fabric).

While our current ecosystem is a Microsoft-centric environment, we are looking for a candidate whose expertise is rooted in foundational data modelling principles rather than a single vendor. You will define shared analytical models and standards that ensure consistency, reusability, and trust across the enterprise, while guiding the transition from a legacy SQL Server–based analytical platform (DWH, SSAS, Power BI) to a modern, cloud-native architecture.

Why This Role Is Unique:

Legacy Transformation: Lead the refactoring of a complex, legacy environment into a modern, streamlined, and future-ready data asset.
Technology Leadership: You will be the guardian and architect of the data structures that drive enterprise analytics.
Career Growth: By maintaining a platform-agnostic mindset, you will build a versatile profile, positioning yourself to lead data strategy across any modern cloud environment.

Location: United Kingdom

Responsibilities

Enterprise-level Analytical Data Modeling:
- Lead analytical modeling for a new enterprise data platform based on Databricks and Microsoft Fabric, handling both structured and semi-structured data, while following platform-agnostic best practices.
- Create and maintain data mapping artifacts to support analytics, integration, and migration initiatives.
- Establish modeling patterns suitable for lakehouse, medallion, and semantic-layer architectures.
- Ensure alignment between physical analytical models and enterprise semantic definitions.
Business–Technical Translation:
- Act as the primary interface between business stakeholders and the data engineering team, with a strong emphasis on data modeling rather than hands-on engineering.
- Translate complex business logic into high-quality documentation, lineage, and models that engineers can implement with precision.
- Conduct deep-dive sessions to audit and remediate complex or poorly structured data structures in the current environment.
Standards, Portability & Data Foundations:
- Establish enterprise data modeling standards that prioritize data integrity, portability, and long-term flexibility.
- Lead data profiling activities to ensure physical implementations align with defined data models.

Requirements

5+ years of dedicated experience in data modelling (not deep hands-on engineering)
Hands-on experience with modern cloud data platforms (Microsoft Fabric and/or Databricks). Experience with Power BI or other Azure Data Services is a significant advantage.
Strong experience with SQL. Familiarity with Python/PySpark is a plus.
Deep knowledge of modeling approaches such as Kimball, Inmon, and Data Vault 2.0, with the ability to select the most appropriate methodology to address specific business challenges.
Experience with enterprise-grade modelling tools (e.g., ER/Studio, Erwin, or Sparx EA).
Strong soft skills and non-confrontational behavior.
Location: Must be UK-based to support the required high-touch stakeholder engagement and "onshore" collaboration model.

We Offer

Projects for clients such as PayPal, Wargaming, Xerox, Philips, Adidas, and Toyota.
Competitive compensation that depends on your qualification and skills.
Career development system with clear skill qualifications.
Flexible working hours aligned to your schedule.
Options to work remotely.
Corporate medical insurance covering services of private and public medical centers.
Corporate parties and events for employees and their children.
Internal conferences, workshops, and meetups for learning and experience sharing.
Gym membership compensation.
5 days of paid sick leave per year with no obligation to submit a sick-leave certificate.

About the Company

[Company description if present]

Apply for

Apply by filling in the form beside or sending your CV to [email protected]

By clicking the button Agree & send I give my consent to Itransition Group to process my personal data in accordance with Recruitment Privacy Statement for the purpose of potential employment, internship, and future career opportunities.

Attach file

The total size of attachments should not exceed 10 MB.

Allowed types:

vcard

Agree & send

Itransition recruitment privacy statement