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 ...
Data Elephant
3 jobs near Columbus, OH
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 ...
You will act as a key bridge between business intelligence and data engineering, ensuring reporting requirements are translated into scalable, well-modeled data solutions. This is a highly ...
You will act as a key bridge between business intelligence and data engineering, ensuring reporting requirements are translated into scalable, well-modeled data solutions. This is a highly ...
This role is ideal for someone who enjoys building end-to-end solutions - from data pipelines and backend systems to AI-powered applications - and wants to work on real-world industrial use cases.
This role is ideal for someone who enjoys building end-to-end solutions - from data pipelines and backend systems to AI-powered applications - and wants to work on real-world industrial use cases.
Full-time
Posted 11 days ago
Job description
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