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

As a key member of Public’s data analytics team, you will be responsible for the continuous development and optimization of our data infrastructure.  Collaborating with stakeholders across the business, you'll leverage your SQL expertise to build ETL pipelines, create compelling data visualizations, and extract actionable insights from the data. Your contributions will directly influence pivotal business decisions across product, marketing, and finance domains, driving our organization's success through data-driven innovation and informed strategies. 

This is a hybrid role (4 days onsite) based in New York City and will report directly to Lead Analytics Engineer. 

What you’ll do

  • Collaborate with product, finance, marketing, and brokerage ops to translate internal data into visually actionable data insights
  • Design and develop interactive Looker dashboards and reports to visualize key metrics and KPIs
  • Coordinate with frontend and backend engineers to align data requirements and design a robust data architecture that supports various business functions
  • Full stack analytics engineering development, building models to consume, transform, and expose data to stakeholders and production systems while ensuring data quality through strategic testing
  • Build centralized company metrics and data models for our BI layer using LookML
  • Perform analyses aimed at optimizing product and business metrics using a variety of methods including data visualization, backtesting, and data science methods
  • Participate in code reviews and provide feedback to other team members to ensure code quality and maintainability
  • Feed data-driven recommendations back to lifecycle marketing and backend databases through automated reverse ETL pipelines using HighTouch and Segment Reverse ETL
  • Maintain, optimize, and improve Public’s data infrastructure across DBT, Looker, Snowflake, FiveTran, Airflow, and HighTouch

Who you are

  • Proven experience (1-3 years) in data analytics, data engineering, or related roles, preferably in the finance or brokerage industry with experience using modern data pipelines and warehousing platforms (such as Snowflake, DBT, FiveTran, Airflow)
  • Strong SQL knowledge and ability to write efficient queries (preferably experience in Snowflake, Redshift, BigQuery)
  • Experience in administration of BI tools, building dashboards, and creating compelling data visualizations with dashboarding tools (ex. Looker, Tableau, PowerBI)
  • Excellent analytical and problem-solving skills with the ability to translate business requirements into technical solutions
  • Strong communication skills and can present data-driven narratives in both verbal and written form
  • Quick learner with ability to swiftly grasp the fundamental components of the business and the key drivers that influence company metrics
  • Investigative mindset, willing to think outside the box and contribute ideas across business functions 

Bonus Points

  • Interest in personal finance/ investing
  • Experience working in fast-paced, start-up environment in the FinTech and/or consumer brand space
  • Demonstrated interest or experience in applying machine learning to enhance business operations
  • Proficiency in data science languages such as Python and R
  • Expertise in marketing data attribution and performance measurement

 

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 $115k-$135k, based on skills and experience.

Apply for this Job

* Required
resume chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
U.S. Standard Demographic Questions We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
How would you describe your gender identity? (mark all that apply)





How would you describe your racial/ethnic background? (mark all that apply)











How would you describe your sexual orientation? (mark all that apply)








Do you identify as transgender? (Select one)




Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication (seeing, hearing, speaking), and learning? (Select one)




Are you a veteran or active member of the United States Armed Forces? (Select one)




Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Public’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Our system has flagged this application as potentially being associated with bot traffic. Please turn off any VPNs, clear your browser cache and cookies, or try submitting your application in a different browser. If this issue persists, please reach out to our support team via our help center.
Please complete the reCAPTCHA above.