Senior Data Modeller (London based)
Description
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.
United Kingdom
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
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
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
- 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
Any questions?
Apply for
Apply for
Senior Data Modeller (London based)
Apply by filling in the form beside or sending your CV to hh@itransition.com