About the Role
LiftIQ is looking for a Senior Analytics Engineer / BI Product Engineer to build the reporting and analytics products our teams use to run the business. This is not a traditional BI role where stakeholders provide specifications and you simply build dashboards. We need someone who can understand the underlying business problem, determine what users actually need, and turn ambiguous requests into accurate, actionable analytics.
Often, the best solution will be different from what was originally requested. You should be comfortable challenging requirements, identifying insights users did not know to ask for, and designing reports that help people make decisions—not simply giving them more data. This is also a highly technical full-stack analytics role that blends analytics engineering with BI product engineering. You will work across BigQuery, dbt, TypeScript, Next.js, and React, using Claude Code extensively to accelerate development.
Data correctness is critical. Wrong numbers are worse than crashes. You will own the accuracy, reliability, and usability of LiftIQ’s reporting products end‑to‑end—from data modeling and metric definitions to dashboard experience and permissions.
What You’ll Do • Work directly with stakeholders to understand business questions and translate them into useful analytics products. • Design metrics, reports, dashboards, and visualizations that surface actionable insights. • Write sophisticated BigQuery SQL and build/extend dbt models,data marts and dimensional models (facts, dimensions, semantic layers) • Reconcile reporting against source systems and investigate data discrepancies. • Build dashboards end-to-end across the data layer, semantic layer, application layer, permissions, and automated tests. • Use Claude Code heavily while maintaining ownership of the underlying architecture, logic, and data correctness. • Protect sensitive financial and compensation data through rigorous server-side access controls. • Write automated tests for metrics, business rules, and permissions. • Document business logic, metric definitions, and data models to ensure clarity and consistency across teams What We’re Looking For
Essential Exceptional SQL skills
Deep experience with analytical SQL, including complex joins, window functions,
attribution, aggregation, data grain, reconciliation, and performance. BigQuery experience
is strongly preferred.
Strong analytical and business judgment
You can understand what decision a stakeholder is trying to make, determine which
metrics matter, and design something more useful than simply fulfilling the original
request.
Strong requirements-gathering skills
You are comfortable working directly with business users, asking the right questions,
understanding unfamiliar processes, and turning ambiguity into a clear solution.
dbt experience
Experience using dbt in a high-scale production data environment. Experience with
dimensional modeling, semantic layers, and metric governance.
Data skepticism
You instinctively validate, reconcile, spot-check, and investigate. You should be
uncomfortable shipping a number you cannot explain.
Testing discipline
Experience building testable analytics logic and automated tests for metrics and business
rules. Experience with version control, PR hygiene, and modular analytics engineering
practices.
English: strong working proficiency (B2+), with the ability to communicate directly with business stakeholders and gather requirements.
Nice to Have • Performance or affiliate marketing experience, including CPL, CPA, EPC, ROAS, and media-buying economics • Experience with platforms such as Everflow, Ringba, RedTrack, Voluum, LeadProsper, or HubSpot • GCP / Cloud Run / Cloud Scheduler / Cloud Build • Python ETL and API integrations • Payroll or commission systems experience • Claude API or other LLM application development • Interactive data visualization • Playwright / E2E testing Tech Stack Data: BigQuery, dbt,
