Senior Data Analyst, Public.com

$140-175k

+ Equity

SQL
Python
Looker
Airflow
Segment
Snowflake
dbt
Senior level
New York
Public.com

Stocks, ETFs & crypto investing app

Job no longer available

Public.com

Stocks, ETFs & crypto investing app

201-500 employees

B2CCryptocurrencyPersonal financeInvestingLearningCommunity

Job no longer available

$140-175k

+ Equity

SQL
Python
Looker
Airflow
Segment
Snowflake
dbt
Senior level
New York

201-500 employees

B2CCryptocurrencyPersonal financeInvestingLearningCommunity

Company mission

Public.com's mission is to make the public markets work for all people.

Role

Who you are

  • 5+ years of experience in a data-professional capacity such as Data Analyst, Data Scientist, and/or Analytics Engineer
  • Expert SQL knowledge and experience developing data models using DBT
  • Fundamental understanding of D2C businesses and unit economics
  • Ability to collect required data from internal and external systems, design data storage structures, and build automated data pipelines that are reliable and scalable in a fast-growing data ecosystem. Preferred experience with Fivetran, Airflow, and/or Airbyte
  • A strong understanding of data modeling principles and modern data platforms to build data model architecture, data ETL processes, reporting, and analytics solutions. Preferred experience with Snowflake, DBT, Looker, HighTouch, and Segment
  • The ability to push the boundaries of analytical insights with modern machine learning and data science stacks (including Python)
  • Strong individual contributor who can operate autonomously throughout an organization across all levels and manage multiple projects across stakeholders in a fast-paced environment

Desirable

  • Experience with large-scale consumer products at start-ups or within fast growing finance or technology companies

What the job involves

  • As a Senior Data Analyst, you will be a key member of Public’s data analytics and engineering team and will report directly to the Head of Strategic Finance
  • You will build systems that process data efficiently and scale with our business, and then model that data to enable analytics and insights across the business
  • You will collaborate cross-functionally to help execute a variety of complex data projects in alignment with our business goals and product roadmap
  • Develop an in-depth understanding of our business fundamentals and success metrics in order to build data solutions that capture top-line initiatives and inform decision-making
  • Partner closely with our engineering and product pods to provide data and insights on our most important brokerage features
  • Build and manage advanced reporting, dashboards, data models, and tools to support cross-functional teams and initiatives, and enable teams to self-service where possible, while being the primary point of contact for ad hoc data requests
  • Extract, manipulate, cleanse, and synthesize data from a variety of sources through ETL technologies
  • Identity, manage, and implement data-driven recommendations for product and lifecycle marketing through alerts, automated reverse ETL pipelines, A/B testing, and machine learning applications
  • Be a thought leader in refining the ways we are developing, testing, deploying, organizing and documenting our data infrastructure, data transformation models, and BI tools for self-service reporting

Otta's take

Sam Franklin headshot

Sam Franklin

CEO of Otta

The stock market can be a confusing place unless you work on Wall Street, making investing a pretty daunting experience. Public.com brings accessibility to the stock market, helping people invest regardless of experience or available funds.

This is done through a commission-free platform that allows users to own fractional shares of stocks, funds, and crypto, making it easier to get started. It has created a safe space for a broad audience, with educational and social features that help users become more familiar with investing. These include "ask-me-anything" sessions with public company CEOs, and Public Live, a daily in-app live audio that helps contextualize market news.

The concept of making investments more accessible is not unique to Public.com, with its most notable competitor being the larger and more established Robinhood. One draw that Public has over the competition is its focus on creating a social community; and it has also been quick to innovate, such as with the launch of investment research tool Alpha, powered by GPT-4. Its UK launch, ahead of Robinhood, should also help cement its position in the market.

Insights

Top investors

43% employee growth in 12 months

Company

Funding (last 2 of 6 rounds)

Feb 2021

$220m

SERIES D

Dec 2020

$65m

SERIES C

Total funding: $309.5m

Company benefits

  • Fully paid health, dental, and vision premiums
  • 401(k) matching - ongoing 4% company match
  • Paid time off - vacation days and additional sick leave
  • Wellness stipend - up to $750/year on gym memberships, massages, and more
  • Paid parental leave - up to 3 months of paid parental leave and additional time to care for your children
  • Flexible spending account
  • Citi Bike membership
  • Reproductive care - $5,000 travel stipend if reproductive care is unavailable where you live
  • In-office meals

Company values

  • Honesty kills bullshit
  • Feedback comes from a place of care
  • Loyalty through care
  • Autonomy through alignment
  • Work fast through organized speeding
  • Embrace urgency
  • We are directly responsible
  • We don't make excuses
  • What could go right?
  • Find a way

Company HQ

Financial District, New York, NY

Founders

Previous Head of Product in the founding team at CFH Group, and co-founder of Tradable.

Leif Abraham

(Co-CEO)

Previously co-founded and was CEO at AND.CO. Also co-founded Pay with a Tweet, and has worked as Director of Product Experience at West.

Previously a Trading Associate at Dominick & Dominick.

Sean Hendelman

(Board Member)

Founder and CEO at T3 Companies.

Salary benchmarks

We don't have enough data yet to provide salary benchmarks for this role.

Submit your salary to help other candidates with crowdsourced salary estimates.

Share this job