Roles and responsibilities

• Build & maintain scalable ELT pipelines (Airbyte, Cloud Functions, BigQuery)
• Warehouse and Modelling. Design clean, test-driven Dataform models using Kimball & data-vault principles.
• Optimize BigQuery performance.
• Semantic Layer and Visualization.
• Develop LookML explores, views, and access grants that balance self-service with governance.
• Enforce PII controls, RBAC policies, and auditing of sensitive views.
• Contribute to model/catalog naming standards and documentation SOPs.
• Contribute to Git-based code reviews, automated testing, and deployment pipelines for Dataform and Looker.
• Guide BI Analysts and Interns on SQL best practices and dashboard performance tuning.
• Run enablement sessions for business users on data literacy and Looker usage.

Requirements

• 1‑3 years building and supporting BI/data‑warehouse solutions in cloud environments (GCP preferred).
• Expert SQL; solid grasp of data‑modelling techniques and slowly changing dimensions.
• Hands-on experience with dbt (or Dataform), Looker/LookML, and a scheduler (Airflow, Prefect, Dagster).
• Familiarity with version control (Git), CI/CD, and code‑review workflows.
• Comfortable navigating data privacy, PCI‑DSS or similar regulatory requirements.
• Clear communicator who can translate technical decisions into business impact.