Data & AI jobs

Sr Analytics Engineer

PublicNew York, NYOn-site3+ years experiencePosted 4 days ago

$150k–$190k/yr listed by the employer

Looks real and checked open today.

On Public’s own careers site (Greenhouse).

Trust score ready Nov 24

  • Checked: On the company's own careers siteGreenhouse board
  • Checked: Checked open todayGreenhouse board
  • Checked: Pay listedJob posting
  • Note: Too new for a trust scoreScored after a week of daily checks, from Nov 24
See all 4 checksShow fewer
How we check

What you’ll do

  • Build and maintain centralized company metrics, dbt models, and the Omni semantic layer.
  • Partner with business and engineering teams to model data, define data contracts and event tracking, and create dashboards and reports.
  • Prepare curated data models and documentation for use with Claude and other AI agents.
  • Analyze product and business metrics using visualization, experimentation, backtesting, and data science methods.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 3–5 years of experience in analytics engineering, business intelligence, or data analytics
  • Hands-on experience building production data models in dbt
  • Experience with Omni or another modern BI tool with a semantic layer
  • Hands-on experience using AI coding tools such as Claude Code or Cursor in data work
  • Experience in finance, brokerage, or fintech (preferred)
  • Experience in a fast-paced startup, especially in fintech or consumer brands (preferred)
  • Experience with Fivetran, Airflow, Hightouch, or Segment (preferred)
  • Experience modeling product event data and defining tracking plans or data contracts (preferred)
  • Experience building AI agents or tools on top of data, such as MCP servers or text-to-SQL (preferred)
  • Interest or experience applying machine learning to business problems, including on Snowflake ML (preferred)

Skills

  • Familiarity with Kimball dimensional modeling and star schemas
  • Strong SQL and ability to write efficient queries on a cloud warehouse
  • Proficiency in Python (preferred)
  • Expertise in marketing attribution and performance measurement (preferred)

Other requirements

  • Ability to present data-driven narratives in writing and in person
  • Ability to learn business fundamentals and key drivers behind company metrics
  • Investigative mindset and willingness to contribute ideas across business functions
  • Interest in personal finance and investing (preferred)

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Comprehensive health plan
Dental & vision
Comprehensive dental and vision plans
Retirement plan
401(k) plan with company match
Paid time off
Generous PTO
Parental leave
Parental leave policy
Learning & tuition
Opportunities for career growth and professional development

Also: equity

Full job description

From Public’s careers site

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

Show full descriptionShow less

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.

Something wrong with this job? Report it

Similar jobs

Analytics Engineer

FanDuel · New York City, NY

$98k–$122k/yrHybrid

StrongChecked open todayPosted 8 days ago

Sr. Data Engineer

NBCUniversal · New York, NY

$115k–$145k/yrFull-timeHybrid

StrongChecked open todayPosted 2 days ago

Data Engineer

Mindex · Remote · US only

$90k–$140k/yrFull-time

StrongChecked open todayPosted 7 days ago

See more like this