2,357,998open jobs
147,660companies
285,962added this week
Browse all
Salary
$150k – $190k per year
Location
In office (New York)
Seniority
Senior · 3+ years exp

Confirmed on the employer's own hiring board on Nov 18, 2026. First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match
Public operates an investing platform covering stocks, bonds, options and treasuries. It layers social features and artificial intelligence research assistants over trading. The company generates revenue without selling retail order flow.

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
  • Participate in code reviews and give feedback to keep our codebase high-quality and maintainable
  • Feed data-driven recommendations back to lifecycle marketing and backend systems through automated reverse ETL pipelines (Hightouch, Segment)
  • Maintain, optimize, and improve Public's data infrastructure across dbt, Omni, Snowflake, Fivetran, Airflow, and Hightouch

Experience

  • 3-5 years of experience in analytics engineering, business intelligence, or data analytics, preferably in finance, brokerage, or fintech
  • Hands-on experience building production data models in dbt
  • Familiarity with data modeling techniques such as Kimball dimensional modeling and star schemas
  • Strong SQL and the ability to write efficient queries on a cloud warehouse (Snowflake preferred; Redshift or BigQuery also relevant)
  • Experience with Omni or other modern BI tools with a semantic layer (e.g. LookML)
  • Hands-on experience using AI coding tools such as Claude Code or Cursor in your data work, such as writing and refactoring dbt models, debugging pipelines, and speeding up analysis
  • Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions
  • Clear communicator who can present data-driven narratives in writing and in person
  • Quick learner who can grasp the fundamentals of the business and the key drivers behind company metrics
  • Investigative mindset; willing to think outside the box and contribute ideas across business functions

Bonus Points

  • Interest in personal finance and investing
  • Experience in a fast-paced startup, especially in fintech or consumer brands
  • Experience with modern ingestion and orchestration tools (Fivetran, Airflow) and reverse ETL (Hightouch, Segment)
  • Experience modeling product event data (Segment, Braze, or similar) and defining tracking plans or data contracts
  • Experience building AI agents or tools on top of data (e.g. MCP servers, text-to-SQL)
  • Demonstrated interest or experience applying machine learning to business problems, including on Snowflake ML
  • Proficiency in Python
  • Expertise in marketing attribution and performance measurement

Compensation

The base salary range for this role is $150,000 to $190,000 plus equity, depending on skills and experience.

  • Comprehensive health, dental, and vision plans
  • Generous PTO and parental leave policy
  • 401(k) plan with company match
  • Opportunities for career growth and professional development

Public is an equal employment opportunity employer to all employees and applicants for employment and prohibits discrimination and harassment of any type. We celebrate people of all race, color, religion, age, sex, national origin, disability status, genetics, veteran status, sexual orientation, gender identity, or expression. 

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,357,998 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Remote, many countries
Similar stack
Same company
New York
$118k – $184k per year · In office · TS/SCI · Full-Time · 10+ years exp · Associate's Degree · Annapolis Junction
Apply
In office · 3+ years exp · Tampa · Plano
Python
SQL
Databases
Snowflake
Analytics
Tableau
Alteryx
Microsoft Excel
Management
Power Automate
SharePoint
Apply
$149k – $201k per year · Equity · In office · Full-Time · 5+ years exp · Bachelor's Degree · Florence
Python
SQL
DevOps
AWS
Chips/EDA
Statistical Process Control
Analytics
Tableau
Power BI
Management
Asana
Smartsheet
Apply
$83k – $130k per year · Equity · In office · Full-Time · 3+ years exp · Bachelor's Degree · Bellevue
SQL
Analytics
Tableau
Apply
In office · Full-Time · 8+ years exp · Bachelor's Degree · Arlington
DevOps
IAM
Windows
DNS
Cybersecurity
MITRE ATT&CK
Zero Trust
Defense in Depth
SIEM
IoT
OPC UA
Energy
DNP3
Apply
$23k – $26k per year · Remote (EAEU) · Saint Petersburg
SQL
Management
Confluence
Jira
Agile
Scrum
Kanban
UML
BPMN
Apply
Remote (EAEU) · Moscow
AI/ML
LLM
Cybersecurity
Keycloak
Management
Confluence
Draw.io
BPMN
Service Desk
Apply
Remote (likely EAEU) · Full-Time · 2+ years exp
1C
Analytics
Power BI
Microsoft Excel
Apply
Remote (EAEU) · 2+ years exp · Moscow
Python
SQL
DevOps
Windows
Management
Confluence
Jira
UML
BPMN
Apply
Remote (EAEU) · Bachelor's Degree · Saint Petersburg
SQL
Databases
PostgreSQL
Redis
Cassandra
ElasticSearch
DevOps
Rest API
Kibana
Logstash
Git
GitLab
IAM
SOAP
Cybersecurity
Keycloak
Management
Confluence
Scrum
UML
QA
Swagger
Apply
$174k – $261k per year · Equity · In office · Full-Time · 8+ years exp · Pleasanton · Denver · Frisco · Boston · Atlanta
DevOps
GCP
AWS
Apply
In office · Bachelor's Degree · New York
Apply
Remote (United States) · Full-Time · 3+ years exp · Bachelor's Degree · New York
DevOps
GCP
Azure
AWS
Linux
Windows
Apply
In office · Full-Time · 3+ years exp · New York
Apply
Hybrid · Full-Time · New York
Apply
See all jobs
This is one of many
2,357,998 more open roles from verified company boards, updated every day.