Position: Looker Developer
Location: Cupertino, CA or Sunnyvale,CA
Client: HCL/ Apple
Must have: Looker, LookML, SQL, Reports, Dashboards
Requirements / Skillsets:
- 2+ years of LookML and Looker specific experience
- Expertise in database technologies working with large sets of data
- Ability to brainstorm Looker solutions to recommend appropriate analytics / KPIs
- Knowledgeable on appropriate LookML to use (Dimensions, Measures, Derived Tables)
- Experienced at determining when to use persistent derived tables based on runtime / complexity of Explore queries
- Experience with PDTs, table filters, custom formatting, parameter select, derived tables
-
- Unit testing via SQL Runner for data validation of result set / expected results
- Resolution skills when inconsistencies are found (Different Results than Expected, Non-unique Primary Keys)
- Methodology selection based on query/report performance (A/B Testing, SQL Principles)
- Able to improve data availability (Cache Queries, Persist Tables, Combination Solutions)
- Ability to assess code quality and resolution of validation errors and warnings