Pay
In line with similar jobs
$150K–$190K against $122K–$190K, the middle half of what similar US postings state.
From 339 postings in the last year. Stated ranges, not salaries paid.
New York, New York
Actively hiring, first seen by us 1 day agoCompensation 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 plansRead the full posting
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.
This role is based in New York City and reports directly to the Director of Data.
Build and maintain company metrics and data models in dbt and the Omni semantic layer
Turn business questions from product, finance, marketing, CX and ops into self-serve data
Define data contracts and event tracking with engineers, and model eventstream data
Design and build Omni dashboards and reports for key metrics and KPIs
Curate models and descriptions so AI agents such as Claude give accurate answers
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.
Build and maintain centralized company metrics and data models in dbt and our Omni semantic layer
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
curate models, descriptions, and topics so teams can get accurate answers through Claude and other AI agents
3–5 years of experience in analytics engineering, business intelligence, or data analytics, preferably in finance, brokerage, or fintech
Experience in a fast-paced startup, especially in fintech or consumer brands
Expertise in marketing attribution and performance measurement
Hands-on experience building production data models in dbt
Experience with modern ingestion and orchestration tools (Fivetran, Airflow) and reverse ETL (Hightouch, Segment)
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)
Public is the world’s first agentic brokerage, combining a comprehensive multi-asset investing experience with all the advantages of AI Agents.
In the employer’s words · Read in context
Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
In line with similar jobs
$150K–$190K against $122K–$190K, the middle half of what similar US postings state.
From 339 postings in the last year. Stated ranges, not salaries paid.
Day 1
Early. Similar jobs usually come down between day 7 and day 51.
From 1,697 similar postings that came down. Coming down is not always a hire.
1 open job
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Demonstrated interest or experience applying machine learning to business problems, including on Snowflake ML - Proficiency in Python - Expertise in marketing attribution and performance measurement
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.
- 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)
- 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
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
- 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
- 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
- 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
- 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 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
Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.
Already applied? Track this application
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.
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.
The base salary range for this role is $150,000 to $190,000 plus equity, depending on skills and experience.
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.
New Analytics Engineer postings at the employers we follow are down 20% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analytics Engineer, by the work the posting describes.
Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.
Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.
A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.
The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
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
New York, New York
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.