BI Engineer Consultant

Total-TECH Co

The Job Description

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

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.

2-Dashboard & Report Development : 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.

3- Self Service BI Enablement : 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.

4- In DB Sematic Layer and SQL Development : 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.

5- Operations, Monitoring & Continuous Improvement : 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.

Requirements:

• 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.
• Bachelor s degree in Computer Science, Information Technology, Information Systems, or a related.

Tagged as: looker , lookml , powerbi , SQL