We launched recruiters.rip, let your AI apply for you. First month free with code onemonthfree

Senior Analytics Engineer

1 day agoSeniorSalary: 150000 - 190000 USD / yearNew York, USAOnsiteData ScienceJobs by Public

Public is a multi-asset investing platform that lets users trade stocks, bonds, ETFs, options, crypto, and treasuries from a single account with AI-powered tools.

228 Park Avenue South, Suite 97716, New York, NY 10003, United States
About Public

Public provides brokerage, investment advisory, and retirement account services in one platform for individual investors seeking consolidated access to multiple asset classes. Users can automate trading strategies using AI-powered agents, build custom index portfolios through Generated Assets, and earn rebates on options contracts. The platform does not participate in payment for order flow on equity trades, and all brokerage services operate under FINRA and SIPC oversight.

View jobs by Public

Skills

Candidate Availability

About the Role

You will own the development and optimization of the semantic layer and the data models behind it, using SQL and dbt to build reliable pipelines and define core company metrics once so people and AI agents can use them. You will partner with product, finance, marketing, CX and brokerage ops, build Omni dashboards, model eventstream data, run analyses, and maintain the data infrastructure. The role is based in New York City.

Requirements

  • 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 ability to write efficient queries on a cloud warehouse (Snowflake preferred)
  • 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 data work
  • Strong analytical and problem-solving skills
  • Clear communicator in writing and in person
  • Quick learner of business fundamentals and key metric drivers
  • Investigative mindset

Responsibilities

  • Build and maintain centralized company metrics and data models in dbt and the Omni semantic layer
  • Partner with product, finance, marketing, CX, and brokerage ops to turn business questions into well-modeled, self-serve data
  • Define data contracts and event tracking with frontend and backend engineers and model eventstream data from app, backend, and Braze sources
  • Design and build Omni dashboards and reports for key metrics and KPIs
  • Make data AI-ready by curating models, descriptions, and topics for Claude and other AI agents
  • Run analyses to improve product and business metrics using visualization, experimentation, backtesting, and data science methods
  • Participate in code reviews and give feedback
  • Feed data-driven recommendations to lifecycle marketing and backend systems through reverse ETL pipelines (Hightouch, Segment)
  • Maintain, optimize, and improve data infrastructure across dbt, Omni, Snowflake, Fivetran, Airflow, and Hightouch

Benefits

  • Comprehensive health, dental, and vision plans
  • Generous PTO and parental leave policy
  • 401(k) plan with company match
  • Equity