Business Intelligence Analyst, Public.com

• 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
• Experience using modern data pipelines and warehousing platforms (such as Snowflake, DBT, FiveTran, Airflow)

Desirable

• 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
• Will report directly to Lead Analytics Engineer
• 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