Vacancy expired!
INDIST# Job Description: Responsibilities / Core Job Functions: Build LookML data models on top of consumption layer (Snowflake) Design new LookML dimensions or measures within given requirements Define / build new reporting infrastructure / tables per business need (Derived Tables) Analyze data models and business requirements to create LookML objects, including determination of source objects and how to join views into Explores Build Explores for users to answer business questions within given requirements Support reporting infrastructure and deployment pipeline (Looker, GitHub, Validate Pull Request Process) Implement version control based on given requirements, including determination of appropriate setup for Git branches (Shared Branches, Pull from Remote Production) Modify existing project structure to account for new reporting needs Construct SQL statements to use with new dimensions and measures Troubleshoot / resolve errors in existing data models and explores Apply procedural concepts to: Implement data security / permissions for users (Access Filters, Field & Row Level) Optimize queries / reports for performance, including which solution to use based on performance implications (Explores, Merged Results, Derived Tables) Implement persistent derived tables / caching policies; appropriate caching settings based on update frequency (Hourly, Weekly, ETL completion) Maintain health of LookML projects, ensuring existing contents are working (Content Validator, Audit, Search for Errors, Unit Testing) Utilize LookML parameters to increase end user experience Train and mentor junior level programmers on Looker components Requirements / Skillsets: 2+ years of LookML and Looker specific experience Expertise in database technologies (Snowflake) and 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 Analyze data via SQL queries to assess structure, granularity, quality and fit for analytics 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 Knowledge of LookML best practices for coding
Vacancy expired!