Business Intelligence (BI) Analyst
Role SummaryWe are seeking an experienced and business-minded Business Intelligence Analyst to bridge the gap between complex data architecture and executive decision-making. In this role, you will design, build, and optimize scalable ETL/ELT pipelines, maintain data warehouses, and create intuitive dashboards that transform raw data into clear, actionable business strategies.
You should be a master of SQL and BigQuery, possess deep expertise in event-tracking instrumentation, and excel at data storytelling—explaining the "why" behind the numbers to technical and non-technical stakeholders alike.
Key ResponsibilitiesData Architecture & ETL Engineering Pipeline Design: Build, orchestrate, and optimize reliable ETL/ELT workflows to consolidate data from product events, transactional databases, and third-party SaaS tools.
* Database Management: Structure, optimize, and maintain data schemas across relational databases (PostgreSQL) and enterprise cloud data warehouses (Google BigQuery).
* Data Quality & Governance:* Establish data hygiene best practices, rigorous testing, and automated monitoring to ensure high data integrity, accurate aggregations, and fast query performance.
Event Tracking & Behavioral Analytics Tracking Strategy: Define and manage tracking specs (event schemas, user properties, triggers) for web and mobile platforms using tools like Google Analytics 4, Mixpanel, or Amplitude.
* User Behavior Analysis:* Track customer journeys, user funnels, feature adoption, cohort retention, and conversion metrics to uncover friction points and growth opportunities.
Dashboards, Reporting & Business Intelligence Visualization: Design, deploy, and maintain executive dashboards and operational reports using Looker Studio (Data Studio), or Power BI.
* Self-Service Enablement:* Empower cross-functional teams (Product, Marketing, Finance, Operations) with self-service reporting frameworks and documentation.
Qualifications Experience: Minimum 4+ yearsof hands-on experience in a Business Intelligence, Data Analytics, or Data Engineering role.
* SQL Mastery: Advanced skills in SQL and database querying across relational systems (PostgreSQL) and enterprise data warehouses (Google BigQuery).
* ETL & Data Pipelines: Hands-on experience designing workflows and aggregation models using tools such as dbt, Airflow, or native database scheduling.
* Event Tracking: Deep expertise in event instrumentation, server-side/client-side tracking, and storing unstructured/semi-structured event payloads (JSON/nested data in BigQuery).
* Data Visualization: Proven track record of building automated dashboards and reporting layers tailored to business stakeholder needs using Looker Studio or similar BI tools.
* Data Storytelling & Business Acumen: Ability to analyze complex data sets, draw meaningful commercial insights, and communicate them effectively to executive stakeholders.
* Domain Experience: Background in Marketplace platforms (e.g., supply/demand side dynamics, liquidity, GMV, take rates) or SaaS businesses(e.g., ARR/MRR, CAC, LTV, churn, retention cohorts).
* Advanced Analytics & Scripting: Proficiency in Python or R for advanced data manipulation, automated reporting, or statistical analysis.
* Data Governance & Security:* Understanding of GDPR/HIPAA compliance, user privacy, and data access controls within cloud warehouses.