Analytics Engineer
About Us:
Public.com is an investing platform that helps people become better investors. Members can build a diverse portfolio of stocks, ETFs, and crypto within a single platform.
On Public, ownership unlocks an experience of content and education, contextual to their portfolio, created by a million+ strong community of investors, creators and analysts.
Public puts investors first, and doesn’t sell trades to market makers or take money from Payment for Order Flow (PFOF).
We announced our Series D funding round of $220 million in Feb. 2021, just two months after our Series C round. Our investors include Accel, Greycroft, (the original investors in Venmo) and Lakestar, as well as Will Smith (Dreamers VC), Tony Hawk, The Chainsmokers’ Mantis VC; NFL star J.J. Watt, NYU Stern professor and entrepreneur Scott Galloway, business executive Dick Parsons, Business Class founder Sophia Amoruso, and Shari Redstone’s Advancit Capital.
What we’re looking for:
As a new member of a growing analytics engineering team, you aren’t afraid to wear multiple hats. You are comfortable working across multiple tools and concepts to provide our analysts with the data needed to support their insights.
You take a software engineering approach to data. You believe that all processes in the data pipeline should be tested, automated, version-controlled, reproducible, and extensible.
Most importantly, you are a lifelong learner. At Public, we value a deep understanding of time-tested concepts over any specific tool.
Who you are:
- Ability to turn complex business logic into clean SQL code.
- Experience creating ETL/ELT pipelines.
- Familiarity with data modeling concepts (Star Schema, OBT, etc.).
- Experience with a data warehouse.
- Willingness to learn GCP.
- Passionate about user experience and solving problems.
- Strong communication skills.
- Familiarity with a programming language.
Bonus Points:
- Experience with dbt.
- Experience with Fivetran.
- Proficiency with Python.
- Experience tuning and optimizing SQL queries.
Our Stack
- dbt
- Snowflake
- Looker
- Python
- Airflow
- Fivetran
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.