BI Engineer, PulsePoint

• 2+ years in a Site Reliability, DevOps, or Cloud Infrastructure role in a production environment
• Bachelor's degree in Computer Science, Engineering, or related field, or equivalent hands-on experience
• Practical experience with GCP — Cloud Run, API Gateway, and BigQuery in particular
• Experience with monitoring and observability tooling (Cloud Monitoring, Datadog, or similar)
• Solid grasp of cloud security fundamentals — IAM, network controls, access management
• Proficiency with Git and version control in a team setting
• 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

Desirable

• Our BI team runs a set of GCP-based APIs and data services that a lot of internal products depend on
• As we've grown, keeping things running has increasingly been a side responsibility for engineers who are primarily building features — and that's not sustainable
• We're looking for an SRE to own that space: service health, incident response, infrastructure monitoring, and making sure we're not blindly burning cloud budget
• The BI Engineer, SRE will ensure the availability, performance, and security of the Business Intelligence team's GCP-hosted APIs and data infrastructure
• This role is responsible for proactive monitoring, incident response, and continuous improvement of platform reliability across a cloud-native stack
• The engineer will work closely with backend and data engineers to maintain service health and drive operational excellence
• This position also carries responsibility for GCP cost visibility, helping the team track and optimize cloud spend through structured monitoring and alerting
• 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
• Monitor and maintain uptime of GCP-hosted APIs and services, keeping performance within agreed targets
• Lead incident response for BI platform services — triage, resolve, and follow up with post-mortems that actually prevent recurrence
• Build and manage observability infrastructure: dashboards, alerts, and logging across GCP services
• Track GCP cloud spend and set up cost alerting to flag anomalies before they become problems
• Review and fix security gaps — IAP configs, service account permissions, API access controls
• Work with data and backend engineers to shore up reliability of data pipelines and BigQuery workflows
• Contribute to infrastructure-as-code and help keep deployments documented and reproducible

• 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)