Job Description: Principal Looker Architect : This role will include end to end Looker ML project solution design including leading dashboard rationalization, semantic layer redesign, performance optimization, stakeholder alignment, and ensure scalable, governed analytics architecture aligned with modern data platforms (BigQuery / Snowflake / Databricks). The ideal candidate combines strong BI engineering skills, data modeling expertise, and consulting capabilities
Responsibilities: 1. Migration Strategy & Planning
- Assess existing BI estate (dashboards, reports, data models, usage metrics)
- Define migration roadmap and prioritization strategy
- Conduct dashboard rationalization and redundancy analysis
- Estimate migration effort and complexity
2. LookML & Semantic Modeling
- Design and implement scalable LookML models
- Build reusable explores, views, and derived tables
- Implement governed semantic layers
- Optimize query performance and caching strategies
3. Dashboard & Report Migration
- Rebuild complex dashboards in Looker
- Ensure metric parity and validation against legacy reports
- Recreate advanced visualizations and drill paths
- Conduct UAT and stakeholder walkthroughs
4. Data Platform Integration
- Integrate Looker with modern cloud warehouses (BigQuery, Snowflake, Redshift, Databricks)
- Optimize SQL performance
- Implement row-level security and access governance
- Support CI/CD pipelines for LookML deployment
5. Stakeholder & Consulting Engagement
- Work closely with business stakeholders to redefine KPIs
- Translate business requirements into scalable models
- Provide change management support
- Conduct training sessions and adoption workshops
Qualifications: Required Skills & Qualifications
Technical Skills
- 6+ years hands-on experience in Looker / LookML
- Strong SQL expertise (advanced joins, window functions, performance tuning)
- Experience migrating from at least one legacy BI platform (QlikView, Tableau, Power BI, Cognos, BO)
- Experience with cloud data warehouses (BigQuery preferred)
- Understanding of dimensional modeling (star schema, fact/dimension design)
- Familiarity with CI/CD and DevOps pipelines
