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