Senior Data Modeller (London-based)

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.
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
What we offer
Projects for such clients 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
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