3-5 years in analytics engineering, business intelligence, or data analytics, ideally in finance or fintech
Hands-on experience with dbt for building production data models
Familiarity with Kimball dimensional modeling and star schemas
Strong SQL skills for efficient querying in cloud warehouses (Snowflake preferred)
Experience with modern BI tools featuring a semantic layer, like Omni or LookML
Proficient in using AI coding tools for data tasks, such as Claude Code or Cursor
Strong analytical skills to translate business needs into technical solutions
Effective communicator for presenting data-driven insights
Responsibilities
Build and maintain centralized metrics and data models in dbt and Omni semantic layer
Collaborate with cross-functional teams to convert business questions into self-serve data
Define data contracts and model eventstream data with engineers
Design and create dashboards and reports for key metrics
Prepare data for AI readiness, ensuring accurate outputs from AI agents
Conduct analyses to enhance product and business metrics using various methods
Participate in code reviews to maintain code quality
Implement automated reverse ETL pipelines for data-driven recommendations
Benefits
Comprehensive health, dental, and vision plans
Generous PTO and parental leave policy
401(k) plan with company match
Opportunities for career growth and professional development
Full Job Description
About the Role
As a key member of Public's data team, you will own the development and optimization of our semantic layer and the data models behind it. Working with stakeholders across product, marketing, finance, CX, and brokerage ops, you'll use SQL and dbt to build reliable pipelines, define the company's core metrics once, and make them usable by people and AI agents alike. Your work will directly shape how Public makes decisions, from daily business reporting to product experiments.
This role is based in New York City and reports directly to the Director of Data. What You'll Do
Build and maintain centralized company metrics and data models in dbt and our Omni semantic layer, so every team works from the same definitions
Partner with product, finance, marketing, CX, and brokerage ops to turn business questions into well-modeled, self-serve data
Work with frontend and backend engineers to define data contracts and event tracking, and model eventstream data from app, backend, and Braze sources
Design and build Omni dashboards and reports for key metrics and KPIs
Make our data AI-ready: curate models, descriptions, and topics so teams can get accurate answers through Claude and other AI agents
Run analyses that improve product and business metrics, using visualization, experimentation, backtesting, and data science methods
Participate in code reviews and give feedback to keep our codebase high-quality and maintainable
Feed data-driven recommendations back to lifecycle marketing and backend systems through automated reverse ETL pipelines (Hightouch, Segment)
Maintain, optimize, and improve Public's data infrastructure across dbt, Omni, Snowflake, Fivetran, Airflow, and Hightouch
Experience
3-5 years of experience in analytics engineering, business intelligence, or data analytics, preferably in finance, brokerage, or fintech
Hands-on experience building production data models in dbt
Familiarity with data modeling techniques such as Kimball dimensional modeling and star schemas
Strong SQL and the ability to write efficient queries on a cloud warehouse (Snowflake preferred; Redshift or BigQuery also relevant)
Experience with Omni or other modern BI tools with a semantic layer (e.g. LookML)
Hands-on experience using AI coding tools such as Claude Code or Cursor in your data work, such as writing and refactoring dbt models, debugging pipelines, and speeding up analysis
Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions
Clear communicator who can present data-driven narratives in writing and in person
Quick learner who can grasp the fundamentals of the business and the key drivers behind company metrics
Investigative mindset; willing to think outside the box and contribute ideas across business functions
Bonus Points
Interest in personal finance and investing
Experience in a fast-paced startup, especially in fintech or consumer brands
Experience with modern ingestion and orchestration tools (Fivetran, Airflow) and reverse ETL (Hightouch, Segment)
Experience modeling product event data (Segment, Braze, or similar) and defining tracking plans or data contracts
Experience building AI agents or tools on top of data (e.g. MCP servers, text-to-SQL)
Demonstrated interest or experience applying machine learning to business problems, including on Snowflake ML
Proficiency in Python
Expertise in marketing attribution and performance measurement
Compensation
The base salary range for this role is $150,000 to $190,000 plus equity, depending on skills and experience.
Comprehensive health, dental, and vision plans
Generous PTO and parental leave policy
401(k) plan with company match
Opportunities for career growth and professional development
About Public
Public is a retail company that operates a chain of discount department stores. The company was founded in 1962 and is headquartered in Cincinnati, Ohio. Public offers a wide range of products including clothing, footwear, home decor, electronics, and groceries. The company has over 1,000 stores across the United States and employs over 12,000 people.