New York City, United States
Sr Analytics Engineer
Public · New York City · United States
- Salary
- $150,000–$190,000 per year
- Occupation
- Data Engineer
Posted: 11/17/2026 · Last checked: 11/18/2026
Job description
Quoted in full from Public's job posting. Gavroche does not edit it.
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.
From Gavroche data
Figures computed from live adverts on Gavroche; the job text above is the employer's.
Similar roles in New York City
- Senior Data Engineer · First Street, New York City
- Staff Data Engineer · Fanatics Betting & Gaming, New York City
- Senior Analytics Engineer - People Data and Insights · The New York Times, New York City
- Data Engineer · David Protein, New York City
- Senior Staff Data Engineer · Biohub, New York City
- Senior Analytics Engineer · Good Inside, New York City
200 open roles like this one; at most three per employer shown.
What data engineer adverts in New York City state
Middle half: 170,000 – 208,875 USD a year; median 190,000 USD.
From 17 adverts by 16 employers that state a salary, annualised.
How data engineer roles in the United States are worked
8% fully remote · 0% hybrid · 92% do not say
Of 66 adverts. An advert that does not state a work mode is counted as not saying, not as on-site.
New openings in New York City, by week
- 8/24/2026 363
- 8/31/2026 404
- 9/7/2026 401
- 9/14/2026 497
- 9/21/2026 469
- 9/28/2026 639
- 10/5/2026 621
- 10/12/2026 1622
- 10/19/2026 843
- 10/26/2026 703
- 11/2/2026 696
- 11/9/2026 721
- 11/16/2026 379
8,358 openings over 12 weeks, by the week they were published.
Other roles at Public
- Accounting Manager · New York City
- Counsel · New York City
- Director - Business Development · New York City
3 open.