Business Intelligence Analyst II

Public.com • New York City, NY

Company

Public.com

Location

New York City, NY

Type

Full Time

Job Description

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 reporting layer.  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 role is 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 data requirements with frontend and backend engineers to understand data requirements and design scalable data solutions
  • 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 business intelligence, data analytics, or related roles, preferably in the finance or brokerage industry
  • Expertise in administration of BI tools, building dashboards, and creating compelling data visualizations with dashboarding tools (ex. Looker, Tableau, PowerBI)
  • Strong SQL knowledge and ability to write efficient queries (preferably experience in Snowflake, Redshift, BigQuery)
  • 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
  • Experience using modern data pipelines and warehousing platforms (such as Snowflake, DBT, FiveTran, Airflow)
  • 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 Now

Date Posted

03/07/2024

Views

1

Back to Job Listings ❤️Add To Job List Company Info View Company Reviews
Positive
Subjectivity Score: 0.9

Similar Jobs

Strategic Customer Success Manager - Rokt

Views in the last 30 days - 0

mParticle by Rokt a leading customer data platform is seeking a Strategic Customer Success Manager The role involves building strong relationships wit...

View Details

Enterprise Customer Success Manager - Rokt

Views in the last 30 days - 0

mParticle by Rokt a leading customer data platform is seeking an Enterprise Customer Success Manager The role involves serving as a trusted consultant...

View Details

AWS Alliance Driver, Director - PwC

Views in the last 30 days - 0

The text describes a role for an AWS Alliance Director at PwC The individual will lead the AWS Alliance across various sectors focusing on the overall...

View Details

Business Account Executive - Spectrum

Views in the last 30 days - 0

The Business Account Executive role involves selling primary and ancillary communications solutions to small and mediumsized businesses within a speci...

View Details

Senior Software Engineer, Devices Automation - Block

Views in the last 30 days - 0

Square a company that has evolved since its inception in 2009 is seeking a Software Engineer with extensive experience in embedded devices and test en...

View Details

Principal Product Marketing Manager - Rokt

Views in the last 30 days - 0

mParticle by Rokt a leading customer data platform is seeking a Principal Product Marketing Manager The role involves driving market leadership creati...

View Details