Public · posted · checked
Sr Analytics Engineer
AirflowdbtSnowflakeSQL$150k – $190kOn-site · New YorkSenior
Who can apply
On-site · New York
Location: New York, New York
About Us
Public is the world’s first agentic brokerage, combining a comprehensive multi-asset investing experience with all the advantages of AI Agents.
Members can invest in stocks, options, bonds, crypto, and event contracts, and manage a variety of accounts including their personal brokerage, margin, retirement accounts, and business accounts—all in the same place.
Since 2019, Public has raised $400 million. Investors include Accel, Tiger Global, Will Smith's Dreamers VC, The Chainsmokers' Mantis VC, as well as renowned figures in business and culture, like Maria Sharapova, Tony Hawk, and NYU Stern professor Scott Galloway.
About the Role
As a key member of Public's data team, you will own the development and optimization of our semantic layer and the data models behind it. Working with stakeholders across product, marketing, finance, CX, and brokerage ops, you'll use SQL and dbt to build reliable pipelines, define the company's core metrics once, and make them usable by people and AI agents alike. Your work will directly shape how Public makes decisions, from daily business reporting to product experiments.
This role is based in New York City and reports directly to the Director of Data.
What You’ll Do
Build and maintain centralized company metrics and data models in dbt and our Omni semantic layer, so every team works from the same definitions
Partner with product, finance, marketing, CX, and brokerage ops to turn business questions into well-modeled, self-serve data
Work with frontend and backend engineers to define data contracts and event tracking, and model eventstream data from app, backend, and Braze sources
Design and build Omni dashboards and reports for key metrics and KPIs
Make our data AI-ready: curate models, descriptions, and topics so teams can get accurate answers through Claude and other AI agents
Run analyses that improve product and business metrics, using visualization, experimentation, backtesting, and data science methods