Senior Data Analyst

About SpotSpot Pet Insurance is the fastest-growing pet insurance company in North America. Our commitment to an exceptional end-to-end customer experience and our data-driven approach have quickly established us as a leading pet insurance provider. We're dedicated to providing pet parents with peace of mind by offering accessible and comprehensive coverage so their furry companions can lead happier, healthier lives.To demonstrate this commitment, we recently joined forces with MrBeast to help find homes for 100 homeless pets and committed to providing each of them with pet insurance for life. Along the way, we've created a company culture that allows our employees to thrive, with perks like daily free meals, a pet-friendly office, and fun company events every quarter. Our dedication to fostering a positive and rewarding work environment has even earned us a Great Place to Work certification.About the RoleWe are seeking a Senior Data Analyst to join our dynamic team. The ideal candidate is passionate about data, highly analytical, and eager to turn complex datasets into clear, actionable insights that drive business performance. This role will support both recurring and ad hoc analysis across the business, helping teams make faster, smarter decisions.We are looking for someone who is high-energy, hands-on, collaborative, and willing to dive in and "run through walls" to get things done.Responsibilities

• Partner directly with management to support strategy development and execution through data-driven insights and experimentation across sales and marketing channels.
• Design and build full-cycle experiments, dashboards, and reporting frameworks that improve decision-making and business outcomes.
• Gather stakeholder requirements, define key success metrics, and maintain regular reporting on performance indicators.
• Identify, integrate, and help automate new data sources and pipelines to improve data availability and reliability.
• Analyze datasets to identify trends, correlations, and relationships between key business metrics.
• Ensure data practices are aligned with privacy, compliance, and governance standards.
• Help establish and maintain a single source of truth across core datasets and reporting layers.
• Ensure ongoing data integrity, consistency, and observability across all reporting systems.Qualifications
• 5-6 years of experience working as a Data Analyst, Business Analyst, or Data Engineer.
• Strong experience using SQL to transform datasets into meaningful metrics and insights.
• Experience with ELT processes and methodologies.
• Experience managing databases, including relational database architecture, query optimization, and database schema design.
• Empathy and creativity to understand and solve stakeholder problems.
• Passion for data origins, integrity, accuracy, and storytelling.Technologies
• SQL Databases (PostgreSQL, MySQL)
• Looker Studio and Tableau
• Google Analytics
• Google Cloud Platform (GCP)
• BigQuery
• Segment CDP
• Python
• R StudioNice to Have
• Experience with analytics and visualization tools such as Tableau and Power BI.
• Experience with data engineering tools such as BigQuery.
• Experience with machine learning, advanced modeling, or market mix modeling.
• Experience with advanced statistical analysis.CompensationBase pay range: $91,325 – $114,158 per year. This is the range we reasonably expect to pay at hire. Placement within the range depends on job-related factors such as experience, skills, and certifications. This position is not eligible for bonus or incentive pay. Base pay is one part of a total rewards package that includes benefitsInterview Technology NoticePlease note that phone and video interviews or screenings may be recorded and transcribed using interview technology to support our recruitment process.By continuing with the interview, you consent to this use.Text Messaging NoticeIf you provide a mobile phone number, you may receive job-related communications via text message. Message and data rates may apply.You may opt out of text communications at any time by replying "STOP."