Senior Data Architect - Data Modelling
Data Elephant•Calgary, AB
•Remote
About The Position
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.
Requirements
- 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
- 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
- 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
Responsibilities
- 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
- 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
- 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
- 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)
- Produce clear documentation for data models, definitions, and transformations
- Mentor team members and promote data modeling best practices
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
