Senior Data Architect - Data Modelling

Data Elephant is seeking a Senior Data Architect with strong Data Modeling experience to support a client in designing and delivering scalable, high-quality data models within a modern cloud data platform. This role is critical in enabling trusted, performant, and business-aligned data for analytics, reporting, and advanced use cases.

You will work within an environment leveraging Azure, Databricks, and Power BI, collaborating with data engineers, analytics teams, and business stakeholders to define and implement best-in-class data modeling practices.

Key Responsibilities

Data Modeling & Architecture

Design and implement conceptual, logical, and physical data models aligned to business requirements

Develop dimensional models (star/snowflake schemas) for analytics and reporting use cases

Define and manage data structures within Databricks (Delta Lake)

Ensure models support scalability, performance, and reusability

Collaboration & Stakeholder Engagement

Partner with business stakeholders to translate requirements into robust data models

Work closely with data engineers to align modeling with ingestion and transformation pipelines

Support Power BI developers in optimizing semantic models and reporting performance

Governance & Standards

Establish and enforce data modeling standards, naming conventions, and best practices

Contribute to data governance frameworks, including lineage, metadata, and documentation

Ensure data models align with enterprise data architecture and security policies

Performance Optimization

Optimize data models for query performance and cost efficiency within Azure and Databricks

Support tuning of Power BI semantic models (e.g., aggregations, relationships, measures)

Documentation & Knowledge Sharing

Produce clear documentation for data models, definitions, and transformations

Mentor team members and promote data modeling best practices

Required Experience & Skills

Core Expertise

7+ years of experience in data modeling and data architecture

Strong expertise in tools like Erwin, Hackolade, Data Vault

Dimensional modeling experience

Proven experience working in modern cloud data platforms like Azure, Databricks

Technology Stack

Azure Data Platform (e.g., ADLS, Azure Data Factory, Synapse – familiarity expected)

Databricks (Delta Lake, medallion architecture, Spark concepts)

Power BI (semantic modeling, DAX, dataset design)

Strong SQL skills and understanding of distributed data processing

Additional Capabilities

Experience designing models for large-scale, complex datasets

Strong understanding of data governance, lineage, and metadata management

Ability to balance business usability with technical optimization