Data Analyst

Spot 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, we recently joined forces with MrBeast to find homes for 100 homeless pets and committed to giving each of them 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 ridiculously fun company events every quarter. Our dedication to fostering a positive and rewarding work environment for our team has even earned us a Great Place to Work certification.

We are seeking a Data Analyst to join our dynamic team! The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis for business users. We are looking for someone who is high energy, willing to run through walls, and has a great ability to collaborate.

*This job is in office only at our Downtown Miami Office. No remote work offered*

Responsibilities:

• Work directly with management to help drive strategy and execute experiments to improve company efficiency across sales and marketing channels
• Build full-cycle experiments, reports, dashboards that help the business achieve its goals and enable better decision-making
• Capture our stakeholders' data needs and identify the primary output metrics that measure success. Regularly report on those metrics
• Investigate new data sources and work on adding, automating, and updating data pipelines responsible for delivering data
• Explore data correlations to refine the relationships between metrics
• Align data handling practices with data privacy in mind
• Build data governance with a single source of truth
• Ensure data integrity and observability across all data

Qualifications:

• Have 2-3 years working as a data analyst, business analyst, or data engineer.
• Strong experience using SQL to turn datasets into metrics.
• Experience with the ELT pattern
• Experience in managing databases, including relational database architecture, query optimization, and database schema design.
• Empathy and creativity to understand and solve stakeholders' problems.
• Passion for data origins, integrity, accuracy, and storytelling.

Technologies:

• SQL Databases (Postgres, MySQL)
• Data Studio and Tableau
• Google Analytics
• GCP
• BigQuery
• Segment CDP
• Python Programming
• R Studio

Nice to haves:

• Experience in analytics & visualization tools such as Tableau, Power BI
• Experience with data engineering tools such as BigQuery
• Experience with machine learning, advanced modeling, or market mix modeling
• Experience with advanced statistics

What we offer:

• The opportunity to work on challenging and impactful projects at the intersection of design and data.
• A collaborative and supportive work environment, recognized as a Great Place to Work.
• Cell phone allowance of $100
• Benefit package
• Dental, and visions benefits
• Life insurance
• Unlimited PTO
• Bring your pet to work
• Your pet insurance is covered (Up to $100)
• 401k with Company match
• Annual performance-based bonus