Sr. Business Analyst I

SpotHero; Chicago (IL); On-site; USD 102,000 - 115,000; Full time

Benefits offered by this job

Generous medical and dental coverage

401(k) with match and immediate vesting

Flexible PTO policy

Weekly lunch stipend

Professional development budget

Annual parking stipend

Job summary

A cutting-edge parking technology company is seeking a Sr. Business Analyst I in Chicago. In this role, you will leverage your SQL expertise to transform complex datasets into actionable insights, drive data-driven decision-making, and collaborate with cross-functional teams. The ideal candidate has a Bachelor’s degree and 5-7 years of experience in analytics, along with proficiency in data modeling and visualization tools like Looker. This position offers a competitive salary and comprehensive benefits in a dynamic work environment.

Qualifications

• 5–7 years experience in an analytics background.
• Expert ability to write effective SQL queries.
• Excellent skills in data modeling and warehousing.

Responsibilities

• Lead cross-functional analytics projects from conception to completion.
• Write scalable SQL and build LookML models.
• Transform analytical results into compelling narratives.

Skills

SQL Expert

Data modeling

Data visualization

Analytical skills

Stakeholder management

Education

Bachelor’s degree

Tools

Looker

AWS (S3/Redshift)

Fivetran

dbt

Airflow

Job description

Overview

Join to apply for the Sr. Business Analyst I role at SpotHero

Who We Are

At SpotHero, we work as a team to empower people to get everywhere, easier! We’re rapidly growing with the mission of bringing the parking industry into the future through technology. Drivers across the nation use the SpotHero mobile app or website to reserve convenient, affordable parking in advance, on-the-go or through their connected cars, and parking companies rely on us to help them reach new customers while optimizing their business. We connect the dots with cutting-edge technology, delivering value to both sides of this exciting, evolving marketplace.

Senior Business Analyst I at SpotHero

Our goal is to turn complex datasets into scalable building blocks to enable data‑driven decision making for an entire organization. You will be a full‑stack business analyst, starting with raw data directly from our application all the way to an actionable insight provided to our stakeholders.

A Great Candidate Will

• Be an expert writing SQL queries to transform complex, disparate datasets into scalable analytical building blocks
• Have a strong understanding and passion for data modeling and the modern data stack (fivetran > AWS (Redshift/S3) > dbt > airflow > looker)
• Have a structured, analytical approach to problem solving and the ability to tackle highly ambiguous business questions
• Be a thought leader within the organization, not afraid to challenge norms and present new ideas backed by data‑driven insights
• Be autonomous by nature—a self‑starter able to work independently on large‑scale projects
• Excel at stakeholder management, translating complex analytical findings into actionable business recommendations for executives and cross‑functional partners

What You Will Do

• Lead high‑impact, cross‑functional analytics projects from conception to completion, coordinating with multiple teams to deliver actionable business insights
• Write performant, scalable SQL and build sophisticated LookML models with focus on maintainability and reusability across the organization
• Partner with business stakeholders to understand complex requirements, translate them into analytical solutions, and design data products that drive measurable business outcomes
• Transform complex analytical results into compelling narratives and present findings confidently to influence strategic decision‑making
• Establish and maintain deep expertise across SpotHero's data ecosystem, serving as a go‑to resource for data sources, business context, and analytical approaches

Qualifications

• Bachelor’s degree and 5–7 year experience in an analytics background
• SQL Expert – able to write both effective and efficient queries
• Excellent modern data modeling and data warehousing skillset
• Strong data visualization skills, using a variety of analytics tools
• Advanced proficiency in working with a BI dash‑boarding tool; Looker is our current tool
• Prior experience in marketplace/platform companies, or pricing/revenue optimization highly valued

Core Competencies

• Analytical – examines information methodically and in detail to solve problems or complete tasks.
• Technical Capability – ability to identify how systems and technology can improve ways of working and provide for collaboration and contribution across teams to provide business insights, including proficiency with SQL, data visualization tools, and modern analytics platforms.
• User‑Focused – ability to take complex analysis and develop business insights from the perspective of how it will be understood and used by a user.
• Communication – communicates effectively across all organizational levels, translating complex technical concepts for non‑technical stakeholders and influencing decision‑making through clear, compelling narratives.
• Detailiented – pays attention to details and learns to understand causes and not just effects.
• Efficient – ability to work and identify processes with the least amount of waste (time, materials or other resources) possible.
• Strategic – ability to identify strategic opportunities through data analysis, proactively surfacing insights that drive competitive advantage and business growth

Systems / Tools

AWS Cloud Provider (S3 and Redshift), Data Loading (Fivetran), Transformation (dbt, Airflow), Business Intelligence (Looker)

Seeking Candidates in

• Chicago, IL or Toronto, ON 1x a week

Steps to Apply

Please include any GitHub account, LinkedIn profile, and any project that you’re particularly proud of. We love seeing work that others loved working on.

What We Are Offering

• Career game changer – A truly unique experience to work for a fast‑growing startup in a role with unlimited growth potential.
• Excellent benefits
  • We cover a generous portion of Medical Premiums, 50% of Dental and Vision Premiums, company‑sponsored Life Insurance, a 401(k) with match and immediate vesting, and comprehensive leave policies to meet your needs in creating space for life
  • Canada: We offer Medical (prescription drug and paramedical coverage), Dental, Vision, Life Insurance, STD and LTD.
  • Flexible PTO policy and outstanding work/life balance – We value and support each individual team member.
  • Grubhub weekly lunch stipend for in office days (SkipTheDishes for Canada)
  • Udemy and Personal Learning Budget – We support the professional and personal growth of our people by providing everyone with learning resources and development opportunities.
  • Annual parking stipend – Duh. We help people park!
  • The opportunity to collaborate with fun, innovative, and passionate people in a casual yet highly productive atmosphere.
  • Our commitment to allyship has been a central driver of how we Respect Fellow Drivers. You’ll have the opportunity to be part of Employee Resource Groups, access allyship learning resources, and actively contribute to our ongoing effort of making SpotHero inclusive for all.
  • Employee programs to grow and support our people such as Discovery Days for Product and Engineering, Gearing up for Aspiring Leaders, and Mentorship Program.
  • A workplace recognized as CityLights award winner by 1871, 2025 Best Places To Work by BuiltIn, Most Loved Workplace Certified by the Best Practice Institute, and recipient of multiple Comparably awards, including Best Company Culture, Best Company for Women, and Best Company for Diversity.
• Compensation in Illinois
  • Depending on your skillset and experience, you can expect your base salary to be between $102,000 - $115,000 as well as a discretionary bonus and leading total rewards package including stock options.
  • At SpotHero, we Respect Fellow Drivers by providing an inclusive interview experience for everyone, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process. Please let our team know of your need when you apply or as you begin interviewing with our team. SpotHero is an equal opportunity employer. We know that a diverse workforce is the strongest workforce, and are committed to building and supporting an inclusive environment for all. Additionally, because we want to Remember to Signal, if you choose to provide us personal information in connection with a job application, please review our Applicant Privacy Notice which provides details about what information we collect and process about you in order to consider your candidacy.
  • PLEASE NOTE: This position is ineligible for visa sponsorship. To be considered for this role, you must be legally authorized to work in the US or Canada and not require sponsorship for employment now or in the future.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Research, Analyst, and Information Technology

Industries

Software Development