- 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
Required experience:- Bachelor’s degree in Electrical Engineering, Computer Science, Applied Mathematics or any other technology related field.
- Minimum 5 years in Data and Reporting.
- 2+ years of LookML and Looker specific experience, if not Looker then Tableau or Power BI
- financial services sector experience, FinTech is a plus
- start up experience is a plus
Required skills:- 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.
Compensation:
The pay rate range above is the base hourly pay range that Aditi Consulting reasonably expects to pay someone for this position (compensation may vary outside of this range depending on a number of factors, including but not limited to, a candidate’s qualifications, skills, competencies, experience, location and end client requirements).
Benefits and Ancillaries:Medical, dental, vision, PTO benefits and ancillaries may be available for eligible Aditi Consulting employees and vary based on the plan options selected by the employee. •
Last updated on May 24, 2023