BI Developer

About the job
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.