Description
Position Title
Job Title: BI Engineer
Position Overview
Our BI team builds and maintains the data models and semantic layer that power reporting and analytics across PulsePoint's advertising platform. We're looking for a Senior BI Developer who can take ownership of LookML development and help us push the quality and depth of our Looker implementation further. This is a heads-down technical role — you'll be working closely with data and backend engineers rather than fielding requests from business users. The right person is someone who genuinely enjoys the craft of data modeling and isn't intimidated by a complex, large-scale BigQuery environment.
Responsibilities
- Develop, maintain, and improve LookML models, views, and explores across the Looker semantic layer
- Write and manage Liquid (Jinja2, Shopify flavor) templating logic for dynamic and parameterized content within Looker
- Write advanced SQL queries in BigQuery to support data modeling, debugging, and performance optimization
- Collaborate with data engineers on dbt models, ensuring the semantic layer accurately reflects the underlying data
- Identify and resolve data quality and consistency issues across models and explores
- Review and refactor existing LookML for performance, maintainability, and accuracy
- Document data models and business logic to support long-term maintainability
Qualifications
- 3+ years of experience in a BI development or data modeling role
- Bachelor's degree in Computer Science, Engineering, a quantitative field, or equivalent practical experience
- Deep hands-on experience with LookML and Looker, including complex explores and derived tables
- Strong working knowledge of Liquid templating (Jinja2, Shopify flavor) within Looker
- Advanced SQL skills with production experience in BigQuery
- Solid understanding of data modeling concepts and dimensional design
Preferred skills here:
- Experience with the Looker Extension Framework for building custom embedded applications
- Experience with dbt or willingness to pick it up quickly
- Familiarity with GCP data ecosystem beyond BigQuery (Datastream, Cloud Run, etc.)
- Experience working in version-controlled BI environments (Git)
- Comfortable working across IST/EST time zones in a distributed team
- Experience with dbt or Looker
- Comfortable working across CET/EST hours in a distributed team
Hours & Location
- You can work remotely
- Hours: You can work from 11am-7pm IST
COMP STRUCTURE & BENEFITS:
- Comp structure: fixed (inclusive of PF, Gratuity, and a 25k INR medical premium) + a target annual bonus that is approximately 5% of the gross annual earnings. Note that we don't offer stock options.
- Time Off: 21 PTOs + 9 company-wide holidays + 1 flexible holiday
- Health Insurance Policy (Self & Family): Every employee and their immediate family are covered under Health Insurance Policy worth INR. 500,000
- Term Life Insurance & Personal Accidental Insurance: Every employee is covered under Term Life Insurance and Personal Accident Insurance Policy worth INR. 25,00,000/- each
Selection Process (Might be Subject to Change):
- WebMD SQL Screening Test via CodeSignal (45 minutes)
- PulsePoint SQL Screening Test via CodeSignal (25 minutes)
- Screening Call (30 minutes)
- Hiring Manager Interview (30 minutes)
- Team Interview (2 BI team members, 30 minutes each)
RED FLAGS FOR US:
Candidates won't succeed here if they haven't worked closely with data sets or have simply translated requirements created by others into SQL without a deeper understanding of how the data impacts our business and, in turn, our clients success metrics.
WebMD and its affiliates is an Equal Opportunity/Affirmative Action employer and does not discriminate on the basis of race, ancestry, color, religion, sex, gender, age, marital status, sexual orientation, gender identity, national origin, medical condition, disability, veterans status, or any other basis protected by law.
