BI Engineer Consultant

Total-TECH Co.; Jeddah; On-site; SAR 80,000 - 110,000; Full time

Job summary

Total-TECH Co. is seeking an experienced BI Engineer in Jeddah, Saudi Arabia. The ideal candidate will design and maintain LookML models, develop interactive dashboards, and enable self-service BI for business users. The role demands at least 5 years of relevant experience and strong SQL skills, with hands-on expertise in Looker.

You'll also collaborate with Data Engineers and business stakeholders to ensure accurate data models and effective analytics solutions. A Bachelor's degree in a relevant field is required. We offer a dynamic environment with opportunities for continuous improvement of BI practices.

Qualifications

• 5+ years of experience as a BI Engineer.
• Hands-on experience with Looker and LookML.
• Ability to work closely with Data Engineers and business stakeholders.

Responsibilities

• Design and maintain LookML models.
• Develop interactive Looker dashboards and reports.
• Enable users with certified Looker explores.

Skills

SQL expertise

Looker and LookML

BigQuery or cloud data warehouses

Data warehousing concepts

Collaboration with Data Engineers

PowerBI

Education

Bachelor’s degree in Computer Science, Information Technology, Information Systems or related

Job description

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.

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.

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.

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.

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