Business Intelligence Developer Jobs

Job Responsibilities:

• Apply procedural concepts to:
• Train and mentor junior level programmers on Looker components
• 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)
• Design new LookML dimensions or measures within given requirements
• Build LookML data models on top of consumption layer (Snowflake)
• 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
• Implement data security / permissions for users (Access Filters, Field & Row Level)
• Construct SQL statements to use with new dimensions and measures
• Define / build new reporting infrastructure / tables per business need (Derived Tables)
• Support reporting infrastructure and deployment pipeline (Looker, GitHub, Validate Pull Request Process)
• Troubleshoot / resolve errors in existing data models and explores
• Utilize LookML parameters to increase end user experience
• Build Explores for users to answer business questions within given requirements
• Analyze data models and business requirements to create LookML objects, including determination of source objects and how to join views into Explores
• Optimize queries / reports for performance, including which solution to use based on performance implications (Explores, Merged Results, Derived Tables)

Required experience:

• Financial services sector experience, FinTech is a plus
• Minimum 5 years in Data and Reporting.
• Bachelors degree in Electrical Engineering, Computer Science, Applied Mathematics or any other technology related field.
• Start up experience is a plus
• 2+ years of LookML and Looker specific experience, if not Looker then Tableau or Power BI

Required skills:

• Expertise in database technologies (Snowflake) and working with large sets of data
• Unit testing via SQL Runner for data validation of result set / expected results
• Knowledgeable on appropriate LookML to use (Dimensions, Measures, Derived Tables)
• Methodology selection based on query/report performance (A/B Testing, SQL Principles)
• Ability to brainstorm Looker solutions to recommend appropriate analytics / KPIs
• Resolution skills when inconsistencies are found (Different Results than Expected, Non-unique Primary Keys)
• Analyze data via SQL queries to assess structure, granularity, quality and fit for analytics
• Experience with PDTs, table filters, custom formatting, parameter select, derived tables
• Knowledge of LookML best practices for coding
• Ability to assess code quality and resolution of validation errors and warnings
• Able to improve data availability (Cache Queries, Persist Tables, Combination Solutions)
• Experienced at determining when to use persistent derived tables based on runtime / complexity of Explore queries

Compensation, Benefits and Ancillaries

Compensation

This is the base hourly pay range that Aditi Consulting reasonably expects to pay someone for this position $50/hr - $60/hr (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.