Product Analyst; dbt modeling

Position: Product Analyst (dbt modeling)

Overview

Join to apply for the Product Analyst (dbt modeling) role at Spot On

.

At Spot On, 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 Spot On 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 Spot On’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 Spot On

Benefits

At Spot On, 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

Spot On 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. Spot On is an e-verify company.

Seniority level

• Entry level

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology

Referrals increase your chances of interviewing notified about new Product Analyst jobs in Chicago, IL.

#J-18808-Ljbffr