hirly

Public

Sr Analytics Engineer

New York, New York

hirly Pro

Get in front of the people hiring at Public

  • Reach the hiring manager at Public on LinkedIn, from your own account
  • hirly applies to this job for you, with unlimited applications
  • A resume and cover letter written for this job, unlimited
  • The hiring manager and recruiter at Public, with contact details
Get Pro for this job →

$49 a month · ₹1,999 for 30 days in India · cancel any time

See how you match this job — and similar ones. Free.

Upload your resume and hirly scores it against this role at Public first, then against similar open jobs, and shows where you fit and why.

PDF or DOCX, up to 12MB. No sign-up to see your matches.

Get past the screening software and onto a recruiter's desk

hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.

  • Keywords matched to this posting
  • Fit score before you apply
  • Cover letter included

Matched against 2.9M live jobs from 220,000+ employers in 200+ countries.

Tailor my resume for this job →

Apply from your AI assistant

Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.

Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.

hirly's read of this role

Role family
Data & ML
Seniority
Senior
Stated salary
$150,000 – $190,000 per year
Country
US
Work mode
On-site / unstated
First seen by hirly
17 Nov 2026

Derived automatically from the posting. Upload your resume above to see how the role scores against it.

the posting

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.

Original posting on Public's site ↗

Listed on hirly, a job board. hirly is not the employer: Public is hiring for this role.

Browse similar roles

Want this one?

Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.

Tailor my resume for this job