BI Engineer Consultant

Looker Semantic Modeling & Metrics Layer

Design and maintain LookML models (views, explores, derived tables).

Define consistent business metrics, dimensions, and calculations.

Implement reusable measures, joins, and aggregate awareness.

Optimize semantic models for performance and usability.

Align semantic definitions with data engineering and business stakeholders.

Governed LookML semantic models aligned to business domains.

Certified explores with standardized metrics and dimensions.

Metric definitions and business logic documentation.

Semantic layer performance optimization artifacts.

Design and develop interactive Looker dashboards and reports.

Translate business requirements into clear, actionable visualizations.

Apply visualization best practices for usability and storytelling.

Implement dashboard filters, drill‑downs, and user‑level access.

Maintain and enhance existing dashboards based on feedback.

Production‑ready Looker dashboards and reports.

Dashboard design standards and templates.

Enable business users with the tool to explore data using certified Looker explores.

Design user‑friendly semantic models to reduce ad‑hoc SQL dependency.

Provide training, demos, and best‑practice guidance to users.

Define data governance guardrails for self‑service analytics.

Self‑service‑ready Looker explores with certified fields.

User enablement materials (how‑to guides, training decks).

Reduced ad‑hoc reporting backlog.

Adoption metrics and usage insights.

Write and optimize complex SQL queries for analytics use cases.

Validate data accuracy, aggregations, and business logic.

Partner with Data Engineers to optimize tables, partitions, and models.

Troubleshoot data discrepancies and performance issues.

Optimized SQL logic supporting Looker models and dashboards.

Query validation and reconciliation results.

Monitor dashboard performance, usage, and failures.

Maintain Looker content lifecycle (dev → prod).

Implement access controls and content organization.

Continuously improve models and dashboards based on usage analytics.

Stable, performant Looker environment.

Usage and adoption reports.

• 5+ years of experience as a BI Engineer.
• Experience with Big Query or other cloud data warehouses.
• Strong SQL expertise (mandatory).
• Hands‑on experience with Looker and LookML.
• Experience building enterprise dashboards and semantic layers.
• Solid understanding of data warehousing concepts and analytics modeling.
• Ability to work closely with Data Engineers and business stakeholders.
• Optional:
  PowerBI and Other BI Tools.
• Bachelor’s degree in Computer Science, Information Technology, Information Systems, or a related field.