Analytics Engineer

LA International Computer Consultants Ltd; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

LA International Computer Consultants Ltd seeks a data engineering professional to architect and maintain LookML models that form the central semantic layer for BI dashboards. You will optimize Looker performance and cloud costs using aggregates, smart caching, and PDT strategies, while writing efficient GoogleSQL for BigQuery.

Git-based workflows and CI/CD will govern deployments. This role demands strong collaboration with analytics teams to ensure scalable data models, efficient queries, and

Qualifications

• Experience building LookML models and dashboards.
• Optimizing Looker performance and cloud costs.
• Proficient with GoogleSQL/BigQuery features.
• Experience with Git-based workflows and CI/CD.

Responsibilities

• Architect, build, and maintain LookML models (views, explores, dashboards) as central semantic layer.
• Optimize Looker performance and cloud costs with aggregates, caching, PDT strategies.
• Write optimized GoogleSQL queries using BigQuery features like partitioning and clustering.
• Manage LookML deployment via Git, including PRs and CI/CD workflows.

Skills

LookML modeling

SQL optimization

Cloud cost optimization

Data modeling

Tools

Git

Looker

BigQuery

CI/CD

Datagroups

Job description

Key Responsibilities

• Architect, build, and maintain robust, scalable LookML models (views, explores, and dashboards) as our centralized semantic layer.
• Optimize Looker performance and Google Cloud costs by implementing Aggregate Awareness, smart caching policies (Datagroups), and PDT persistence strategies.
• Write complex, highly optimized GoogleSQL queries leveraging BigQuery-specific features like partitioning, clustering, and nested fields.
• Manage LookML code deployment via Git, including code reviews, pull requests, and setting up CI/CD workflows.

LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.

A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.

Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.