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.

Key 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 behaviour.

Location: Must be UK-based to support the required high-touch stakeholder engagement and "onshore" collaboration model.

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.

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.