Senior Data Analyst

About Public

Public is an investing platform that makes building a multi-asset portfolio fast, frictionless, and secure. Members can trade stocks, options, bonds, crypto, ETFs, and alternative assets—all in one place. Alongside its robust suite of investing tools, Public offers Alpha, a layer of artificial intelligence that provides fundamental data and custom analysis to support informed investment decisions.

Since 2019, Public has raised over $300 million. Investors include Accel, Tiger Global, Will Smith’s Dreamers VC, The Chainsmokers’ Mantis VC, and Shari Redstone’s Advancit Capital, as well as renowned figures in business and culture, like Maria Sharapova, Tony Hawk, and NYU Stern professor Scott Galloway.

About the role 

We are looking for an experienced and passionate data professional to join our team! 

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. 

This role is based in New York City. We operate as a hybrid workplace.

What you’ll do

• 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

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

Bonus Points:

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

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 cash compensation range for this role is $140k-$175k, based on skills and experience. This position also includes an equity package.