Data Warehouse Design Engineer
Designs data warehouse schemas covering star/snowflake schemas, fact/dimension tables, slowly changing dimensions, and ETL patterns.
About this prompt
When to use this prompt
- check_circleDesign star schema for e-commerce data warehouse with sales fact and customer/product dimensions.
- check_circleImplement SCD Type 2 customer dimension tracking historical address and segment changes.
- check_circleBuild dbt incremental models for ETL pipeline loading data warehouse from production OLTP.
Latest Insights
Stay ahead with the latest in prompt engineering.
ArticleHow to Write System Prompts That Actually Work
System prompts set the rules of the game for every AI interaction. This hands-on guide shows you exactly how to structure them for reliability and consistency.
ArticleClaude vs GPT-4o: Which Model Fits Your Use Case?
Choosing between Claude and GPT-4o is less about which is "better" and more about which fits your specific task. Here is a practical breakdown.
ArticleHow Our Design Team Cut Brief-Writing Time by 70% with AI
A real-world case study on how a 12-person design team at a product agency standardised their creative brief process using prompt templates on PromptShip.
ArticleWhy AI Hallucinations Happen (and How to Reduce Them)
Hallucinations are not bugs — they are a fundamental property of how language models work. Understanding why they happen is the first step to minimising them.
ArticleThe State of AI Coding Assistants in 2026
From autocomplete to autonomous agents — AI coding tools have changed dramatically. Here is where things stand and what to expect next.
ArticleFrom Idea to Shipped Prompt: A Solo Founder's AI Workflow
One founder. No team. A dozen AI-powered tools and a tight prompt library. Here is the workflow that runs a bootstrapped SaaS doing $15k MRR.
Recommended Prompts
MCP Server Observability Engineer
Designs observability for MCP servers covering tool call tracing, latency metrics, error tracking, and usage analytics.
OLAP vs OLTP Architecture Advisor
Advises on OLAP/OLTP separation architecture covering read replica vs. data warehouse, CQRS, and analytical query routing.
Product Metrics Dashboard Definition Guide
Defines the right product metrics framework for your stage and type — covering acquisition, activation, retention, revenue, and referral — with dashboard specifications.
North Star Metric & KPI Tree Designer
Designs a North Star Metric with a full KPI tree and input metrics per team.
PHP Laravel Code Reviewer
Senior Laravel engineer review covering Eloquent ORM, service providers, middleware, queues, security, and Laravel best practices.
Rust Systems Code Reviewer
Expert Rust reviewer covering ownership, borrowing, lifetime correctness, unsafe code, performance, and idiomatic Rust patterns.
Token Counter
Real-time tokenizer for GPT & Claude.
Cost Tracking
Analytics for model expenditure.
API Endpoints
Deploy prompts as managed endpoints.
Auto-Eval
Quality scoring using similarity benchmarks.