Description

You will design and maintain logical, conceptual, and physical data models for curated data layers, owning the end-to-end lifecycle from business requirements to technical structures optimized for analytics and AI/ML.

This role is on-site.

Responsibilities

• Design fact and dimension tables using dimensional modeling (Kimball) and data vault techniques.
• Optimize data models for performance, scalability, and query efficiency on cloud platforms.
• Define data definitions, relationships, and business rules to ensure integrity and governance.
• Collaborate with data engineers to implement models via ETL/ELT pipelines and cloud infrastructure.
• Align models with enterprise metadata standards and support BI teams in data consumption.

Required Skills

• 10+ years of experience in data modeling and data architecture.
• Expertise in dimensional modeling, data vault, and normalization techniques.
• Strong SQL skills with proven experience in query optimization and performance tuning.
• Hands-on experience with cloud data platforms, specifically BigQuery.
• Understanding of retail data models including sales, inventory, pricing, and customer analytics.
• Familiarity with data governance, metadata management, and data cataloging.
• Ability to translate business requirements into technical data structures.

Preferred Skills

• Experience in retail or e-commerce environments.
• Familiarity with modern architectures such as data lakehouse or event-driven systems.
• Experience with cloud ecosystem tools including Dataflow, Pub/Sub, and Cloud Storage.

Key Skills

Education

Bachelor's degree