Senior Data Modeler / Data Architect

Job Title: Senior Data Modeler / Data Architect

Overview

We are seeking a highly experienced Data Modeler to design and implement enterprise-grade data solutions across modern cloud platforms. This role requires deep expertise in data modeling methodologies, data architecture frameworks, and large-scale analytical systems. The ideal candidate will play a key role in shaping the organization’s data ecosystem, ensuring scalability, performance, governance, and alignment with business objectives.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for structured and semi-structured datasets.

• Define entity relationships, normalization and denormalization strategies, and dimensional models to support analytics.

• Develop and optimize star and snowflake schemas for data warehouses and analytical workloads.

• Ensure data integrity, consistency, quality, and compliance with enterprise data governance standards.

< data-start="1206" data-end="1230">Data Architecture

• Architect end-to-end data solutions using modern data architecture frameworks and best practices.

• Implement Medallion Architecture (Bronze, Silver, Gold layers) to support scalable and reliable data pipelines.

• Optimize data storage, partitioning, and retrieval strategies for performance and cost efficiency.

• Collaborate closely with data engineering and platform teams on data ingestion, transformation, and integration workflows.

< data-start="1694" data-end="1723">Technology & Platforms

• Hands-on design and modeling experience with Google BigQuery for large-scale analytics.

• Strong working knowledge of Databricks for data engineering, analytics, and lakehouse implementations.

• Experience with cloud-native architectures, distributed data systems, and modern data lakehouse concepts.

Required Qualifications

• 10+ years of experience in data modeling and data architecture roles.

• Proven experience designing enterprise data warehouses and analytical platforms.

• Strong understanding of Medallion architecture and modern data lakehouse design patterns.

• Proficiency in SQL, data modeling tools (e.g., ERwin, PowerDesigner), and ETL/ELT frameworks.

• Hands-on experience with Google BigQuery and Databricks in production environments.

Preferred Skills

• Experience with data governance, metadata management, and master data management (MDM).

• Strong background in query optimization and performance tuning at scale.

• Knowledge of data security, privacy, and compliance standards in cloud environments.