Product Analyst (dbt modeling)

SpotOn

Chicago (IL)

On-site

USD 70,000 - 100,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, Dental and Vision Insurance

401k with company match

RSUs

Paid vacation and company holidays

Monthly stipend for cell phone and internet

Tuition reimbursement

Job summary

A technology solutions company in Chicago is seeking a driven Product Analyst to enhance data quality and drive insights. The ideal candidate will have strong SQL skills, experience with big data and BI tools, and a Bachelor's in a quantitative field. This full-time position offers a competitive salary between $70,000 and $100,000, alongside a comprehensive benefits package.

Qualifications

2-3 years of experience in analytics engineering, product analytics, or a related field.
Ability to write complex SQL queries to extract insights.
Experience with Python or Jinja is a plus.

Responsibilities

Build and maintain dbt models for clean datasets.
Collaborate with Product Managers, Engineers, and Designers.
Investigate unexpected metric movements to provide data-backed recommendations.

Skills

Strong SQL skills

Experience with BI tools

Experience with big data

Problem solving

Education

Bachelor's in a quantitative field

Tools

dbt

Power BI

Metabase

Job description

Overview

Join to apply for the Product Analyst (dbt modeling) role at SpotOn.

At SpotOn, we’re helping restaurants and small businesses compete and win with flexible payment and software technology—backed by real people who really care. From seamless point-of-sale systems to integrated restaurant management solutions, every SpotOn tool is designed to help local businesses increase profits and create better experiences for their customers and employees.

We are looking for a driven and curious Product Analyst to join our team. In this role, you will work alongside product managers, engineers, and your teammates to build scalable data models, improve data quality, and drive insights that support smarter product and business decisions. You will partner with Product to shape strategy, improve the user experience, and support data-informed decision-making. You will be the subject matter expert in your domain, owning success measurement, data development, and visual storytelling.

That’s where you come in.

Essential Functions

You’ll thrive in this role if you…
Enjoy bridging the gap between data engineering and data analysis, helping to transform raw data into clean, well-modeled datasets that analysts and business users can explore with confidence
Value using technology to drive insights and efficiency
Are passionate about wringing insights out of large amounts of data

Your Mission

Cultivate Data Best Practices: Build and maintain dbt models to create clean, documented, and tested datasets for downstream use.
An Eye for Quality: Get to the bottom of data discrepancies and chase down oddities, support the rollout and maintenance of SpotOn’s analytics layer, ensuring trust in our metrics and KPIs.
Drive Constant Improvements: Collaborate with data engineers to understand source systems and identify opportunities to improve pipeline performance or schema design.
Team Up: Collaborate with Product Managers, Engineers, and Designers to drive the business forward.
Data Detective: Investigate unexpected metric movements, identify future opportunities, and serve up data-backed recommendations.

Minimum Qualifications

Strong SQL skills (ability to write complex queries to extract insights), bonus points for experience with Python or Jinja.
Experience working with big data
Experience with BI tools such as dbt, Heap, Metabase, and Power BI
Operating with a bias toward sharing, transparency and collaboration is your default
Diving in, solving problems, and getting things done is second nature – no waiting for perfect conditions
Thriving in fast-paced environments, embracing ambiguity, and taking initiative without a rulebook

Experience Requirements

2-3 years of experience in analytics engineering, product analytics, or a related field

Education Requirements

Minimum: Bachelors in a quantitative field of study

This position is not eligible for work authorization sponsorship by SpotOn

Benefits

At SpotOn, we put people above everything else. We’re known for our innovative software and technology solutions, but we stand out because of the hard-working humans behind the tech. We invest in you with a competitive benefits package including:

Medical, Dental and Vision Insurance
401k with company match
RSUs
Paid vacation, 10 company holidays, sick time, and volunteer time off
Employee Resource Groups to build community and inclusion at work
Monthly cell phone and internet stipend
Tuition reimbursement for up to $2,000 per calendar year

Compensation

Base pay range starts at $70,000 – $100,000 for this role
Salary range is one component of a competitive compensation package which includes a company stock plan
Offers will be reflective of location and experience

The base salary range listed will vary depending on location and experience. Base salary range: $70,000 USD - $100,000 USD

SpotOn is an equal employment opportunity employer. Qualified candidates are considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, military or veteran status, disability, or any other characteristic protected by applicable law. SpotOn is an e-verify company.

Seniority level