Senior Data Analyst / Analytics Engineer

About Us:

Public is the long-term investing platform. Investors use AI and a vast variety of asset classes, from stocks and bonds to crypto and options, to build portfolios for the long haul. Launched in 2019, Public has been trusted with billions in assets of affluent investors. Headquartered in New York City, it’s raised over $400M from investors like Accel and Tiger Global.

The Role

We’re looking for a Senior Data Analyst / Analytics Engineer to join our data team and help build a strong foundation for decision-making across the company. In this role, you'll work across a wide range of product and business domains—from understanding user behavior and product performance to improving data pipelines and enabling self-serve analytics. You’ll work closely with cross-functional stakeholders in Product, Engineering, Finance, and Brokerage to turn data into actionable insights and improve how we operate at scale.

We’re seeking someone who is curious, business-minded, and deeply technical—comfortable writing production-grade SQL, building robust data models, and performing advanced analysis to support high-impact decisions. Experience in consumer fintech or high-growth tech environments is a plus.

This role is based out of our New York City office and is onsite Mon-Thurs.

What You’ll Do

• Build trusted, scalable data models that serve as the foundation for analytics and reporting across the company
• Partner with stakeholders across product, design, engineering, brokerage, and finance to uncover insights and support strategic initiatives
• Develop clear reporting and dashboards to drive performance visibility and accountability across teams
• Conduct in-depth analyses to evaluate feature usage, business performance, and customer behavior
• Design, analyze, and interpret A/B tests and other experiments to support data-driven product decisions
• Own key data pipelines and contribute to the overall health and architecture of our data analytics stack, including peer code reviews
• Explore and implement use cases for AI and large language models (LLMs) to improve how teams access and generate insights from data

Who You Are

• 5–7 years of experience in data roles such as Data Analyst, Analytics Engineer, or Data Scientist
• Experience at a high-growth consumer fintech / investing platform
• Expert SQL techniques for data transformation, querying, and optimization
• Familiarity with Python or another scripting language for data analysis and automation
• Strong understanding of modern data architecture (data lake/warehouse) and experience working with modern data stack tools such as dbt, Snowflake, Airflow, Fivetran, Looker, Hightouch, or similar
• Strong business acumen and the ability to translate complex data into clear recommendations
• A focus on impact - you don’t stop with just recommendations but ensure to see work through to changing the business and driving enterprise value
• Strong communicator who can collaborate effectively with technical and non-technical stakeholders
• Organized, detail-oriented, and able to manage multiple priorities in a fast-paced environment
• Bonus: Experience using AI/LLM tools to enable faster, smarter analytics workflows

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. The compensation range for this role is $135k-$175k based on skills and experience.