ShyftLabs - Analytics Engineer - LookML

<p><p><b>We are seeking a highly skilled Analytics Engineer with expertise in Looker and Google BigQuery to join our data team.</b><br/><br/> This role will focus on building scalable data models, optimizing SQL queries, and creating insightful dashboards and reporting solutions that empower business stakeholders to make data-driven decisions.<br/><br/> <b>Key Responsibilities :</b><br/><br/> - Design, develop, and maintain LookML models in Looker to enable robust self-service analytics.<br/><br/> - Build reusable, scalable data pipelines and transformations in BigQuery.<br/><br/> - Partner with business stakeholders to translate reporting requirements into efficient data models and visualizations.<br/><br/> - Ensure data accuracy, consistency, and performance optimization across dashboards and queries.<br/><br/> - Implement centralized metrics and definitions for consistent business reporting.<br/><br/> - Work with cross-functional teams (data engineering, product, business) to align data models with business needs.<br/><br/> - Monitor and troubleshoot Looker dashboards, BigQuery performance issues, and data pipeline failures.<br/><br/> - Stay current with industry best practices in modern BI, analytics engineering, and cloud data platforms.<br/><br/> <b>Required Skills & Qualifications :</b><br/><br/> - Proven experience as an Analytics Engineer, BI Developer, or Data Analyst with strong technical ownership.<br/><br/> - Advanced proficiency in SQL (preferably Google BigQuery).<br/><br/> - Hands-on experience with Looker (LookML, Explores, Views, PDTs, user permissions).<br/><br/> - Strong understanding of data modeling principles (star schema, snowflake schema, slowly changing dimensions).<br/><br/> - Experience with data warehousing concepts and modern cloud data platforms (preferably GCP).<br/><br/> - Ability to optimize SQL queries and Looker Explores for performance and scalability.<br/><br/> - Strong problem-solving skills and ability to work with large, complex datasets.<br/><br/> - Excellent communication skills to collaborate with technical and non-technical stakeholders.<br/><br/> <b>Preferred Qualifications :</b><br/><br/> - Experience with version control (Git) and collaborative LookML development.<br/><br/> - Familiarity with dbt (data build tool) for transformation modeling.<br/><br/> - Knowledge of other BI/visualization tools (Tableau, Power BI) is a plus.<br/><br/> - Understanding of ETL/ELT pipelines and orchestration tools (Airflow, Cloud Composer).</p><br/></p> (ref:hirist.tech)