Marketing Data Analyst

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.Salary: $80-90K*This job is in office only. No remote work offered*Look, we get it, remote work is the new thing, and many people are loving the WFH option. Spot is not your ordinary company though. We have built an amazing work culture that encourages everyone to voice their ideas and everyone's voice matters. In our offices you'll find a fully stocked fridge along with healthy and not-so-healthy snacks stationed throughout. We do quarterly company outings, fully catered breakfast, lunch, and dinner and we fully reimburse you for your pet's Spot Insurance coverage. Your dog is also expected in the office as we all understand that nothing can get done without our furry friends.Responsibilities:Work directly with management to help drive strategy and execute experiments to improve company efficiency across sales and marketing channelsBuild full-cycle experiments, reports, dashboards that help the business achieve its goals and enable better decision-makingCapture our stakeholders' data needs and identify the primary output metrics that measure success. Regularly report on those metricsInvestigate new data sources and work on adding, automating, and updating data pipelines responsible for delivering dataExplore data correlations to refine the relationships between metricsAlign data handling practices with data privacy in mindBuild data governance with a single source of truthEnsure data integrity and observability across all data

Qualifications:Have 1-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 patternExperience 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.Nice to haves:Experience in analytics & visualization tools such as Tableau, Power BIExperience with data engineering tools such as BigQueryExperience with machine learning, advanced modeling, or market mix modelingExperience with advanced statistics

Technologies:SQL Databases (Postgres, MySQL)Data Studio and TableauGoogle AnalyticsGCPBigQuerySegment CDPPython ProgrammingR Studio