Looker interview questions
Every question comes with an evaluation tip, by category and level.
- 25
- questions with evaluation tips
- 6
- categories
- 12
- senior-level questions
- 13
- mid-level questions
Architecture & System Design
4 questions
-
Question 1: Design a scalable Looker architecture using LookML Modeling that needs to handle 100x traffic growth over 18 months. How do you evolve from the initial design to the scaled version?
Senior level
Evaluation tip. Look for phased scaling approach — horizontal scaling, caching layers, database optimization, and Looker/LookML Modeling-specific patterns.
-
Question 2: How do you approach security in Looker applications that use LookML Modeling? What are the top 3 vulnerabilities specific to this stack?
Mid level
Evaluation tip. Should mention OWASP top 10 risks relevant to Looker and LookML Modeling, authentication, authorization, and input validation.
-
Question 3: Explain your database strategy for a Looker application with complex data relationships. How does your choice integrate with LookML Modeling?
Senior level
Evaluation tip. Tests data architecture skills — should consider query patterns, consistency requirements, and how LookML Modeling interacts with the data layer.
-
Question 4: How do you approach code review in Looker projects? What LookML Modeling-specific patterns and anti-patterns do you look for?
Mid level
Evaluation tip. Look for Looker/LookML Modeling-specific code review criteria beyond generic best practices — framework conventions, performance gotchas, and security patterns.
Behavioral & Culture Fit
4 questions
-
Question 5: Tell me about a time a Looker data pipeline broke due to a schema change or platform update. How did you learn the fix quickly and restore reporting?
Mid level
Evaluation tip. Tests learning agility — look for structured learning approach, resource utilization, and ability to deliver while learning.
-
Question 6: Describe a Looker project involving LookML Data Modeling, Executive Dashboard Development where you disagreed with a technical decision. How did you handle it?
Mid level
Evaluation tip. Look for professional communication — evidence-based advocacy, willingness to compromise, and focus on outcomes over ego.
-
Question 7: How do you stay current with Looker updates, best practices, and industry trends? Do you pursue certifications like Google Cloud Certified: Looker Business Intelligence? Give recent examples.
Mid level
Evaluation tip. Assess continuous learning habits — official documentation, community involvement, conferences, certifications, and personal projects.
-
Question 8: Describe a situation where you mentored a junior Looker team member. What was your approach and what did you learn from the experience?
Senior level
Evaluation tip. Tests leadership potential — structured knowledge sharing, patience, and ability to adjust communication to skill level.
Data Modeling & Query Expertise
5 questions
-
Question 9: Design a data model in Looker using LookML Modeling for e-commerce analytics — handling products, orders, users, and events. What's your schema approach?
Mid level
Evaluation tip. Look for understanding of star/snowflake schemas, denormalization trade-offs, and Looker/LookML Modeling-specific best practices.
-
Question 10: A Looker query that ran fine for months is now 10x slower. Walk me through your diagnostic process.
Senior level
Evaluation tip. Should cover execution plans, index analysis, data volume changes, lock contention, and statistics updates.
-
Question 11: Explain your approach to Looker data partitioning when working with Dashboard Development. When would you partition, and what strategies would you use?
Senior level
Evaluation tip. Look for understanding of partition pruning, range vs hash vs list partitioning, and Dashboard Development-specific maintenance considerations.
-
Question 12: How do you ensure data quality and integrity in a Looker pipeline that ingests data from 15+ sources?
Mid level
Evaluation tip. Should mention validation rules, schema contracts, data quality checks, monitoring, and reconciliation processes.
-
Question 13: Describe your approach to Looker migration — moving from a legacy system to a modern stack. What are the biggest risks?
Senior level
Evaluation tip. Tests planning skills: data mapping, validation, rollback plans, parallel running, and zero-downtime migration strategies.
LookML Modeling & Dashboard Development Expertise
5 questions
-
Question 14: Compare LookML Modeling and Dashboard Development in Looker. When would you recommend one over the other?
Senior level
Evaluation tip. Tests understanding of both LookML Modeling and Dashboard Development — look for nuanced comparison based on use cases, not just features.
-
Question 15: Describe a complex project where you used LookML Modeling extensively. What challenges did you face?
Mid level
Evaluation tip. Assess real-world LookML Modeling experience — depth of knowledge, problem-solving, and results achieved.
-
Question 16: How would you set up Dashboard Development for an organization with 500+ users? What are the critical configuration decisions?
Senior level
Evaluation tip. Look for scalability thinking — performance considerations, user management, and Dashboard Development-specific best practices.
-
Question 17: Walk me through implementing Embedded Analytics in Looker. What are the prerequisites and common pitfalls?
Mid level
Evaluation tip. Tests practical Embedded Analytics knowledge — implementation steps, dependencies, and troubleshooting experience.
-
Question 18: If you had to choose only one of Looker's modules to master deeply, which would it be and why?
Mid level
Evaluation tip. Reveals the candidate's specialization, passion, and ability to articulate the strategic value of their expertise.
Scenario-Based Problem Solving
3 questions
-
Question 19: Your Looker data warehouse has grown to 50TB and queries that used to take seconds now take minutes. What's your optimization strategy?
Senior level
Evaluation tip. Tests understanding of large-scale optimization — partitioning, materialized views, query refactoring, and Looker-specific tuning.
-
Question 20: Two teams are reporting different revenue numbers from the same Looker data source. How do you investigate and resolve this?
Mid level
Evaluation tip. Look for systematic approach: metric definition alignment, query comparison, data lineage tracing, and governance recommendations.
-
Question 21: You need to build a real-time dashboard from Looker data that updates every 5 seconds for 100 concurrent viewers. How do you architect this?
Senior level
Evaluation tip. Should consider streaming vs polling, caching layers, connection pooling, and read replica strategies.
Tools, Integrations & Ecosystem
4 questions
-
Question 22: How proficient are you with BigQuery? Describe a scenario where it significantly improved your Looker workflow.
Mid level
Evaluation tip. Assess practical BigQuery proficiency — look for specific use cases, not just surface-level familiarity.
-
Question 23: How do you integrate Looker with external systems? Describe your approach to API design or third-party integrations.
Senior level
Evaluation tip. Look for integration patterns, error handling, data validation, and experience with REST/GraphQL APIs.
-
Question 24: What's your development/workflow environment look like for Looker projects? Walk me through your Snowflake and tooling setup.
Mid level
Evaluation tip. Reveals professionalism and efficiency — look for version control, code review, automation, and collaboration tools.
-
Question 25: You need to choose between BigQuery and Redshift for a new Looker project. How do you evaluate and make that decision?
Senior level
Evaluation tip. Tests analytical decision-making — should consider team familiarity, project requirements, long-term maintenance, and community support.
Related interview questions
More Looker resources
Hire, price and brief Looker talent.
Hire Looker Developers
Browse pre-vetted profiles
Looker salary guide
Compare rates by country
Looker Development Services
Custom · Migration · API
Looker job description template
Ready-to-use JD template
Hire pre-vetted Looker developers
They've already passed these questions. Profiles in 24 to 48 hours.