Consultant BI Engineer "LookML"

Role Purpose

Tasks

• 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.

Results

• 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.

Tasks

• 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.

Results

• Production‑ready Looker dashboards and reports.
• Dashboard design standards and templates.

Tasks

• 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.

Results

• 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.

Tasks

• 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.

Results

• Optimized SQL logic supporting Looker models and dashboards.
• Query validation and reconciliation results.

Tasks

• 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.

Results

• Stable, performant Looker environment.
• Usage and adoption reports.
• Main contacts:
• Coordination with Business and Technical Vendors

Experience

• 5+ years of experience as a BI Engineer.
• Skills required technical/managerial:
• Experience with BigQuery 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
• Other requirements:
• Bachelor’s degree in Computer Science, Information Technology, Information Systems, or a related