Hotspex Media Looking for Data Analyst at Toronto, Ontario, Canada Full Time

🏆 Named to Ad Age’s Best Places to Work 2023

🙌 #1 Ranked Media Buying and Planning Agency on Clutch.co

🔥 Finalist ‘Game Changing Ad Tech’, 2023 Drum Awards

🎉 Deloitte Fast 500

Responsibilities:

• Create, manage, and QA data streams, ensuring integrity of ads data using our ETL tool
• Blend datasets to support aggregated reporting requirements
• Load data into BI Platform and visualize results based on campaign parameters
• Create custom metrics in BI Platform as requested
• Identify opportunities for process improvement and automation
• Modify visualizations to allow for insight identification and campaign optimization
• Support campaign management and client service team members with ad hoc requests
• Write reproducible SQL queries for data processing and manipulation
• Work alongside vendors to improve API management and data collection opportunities

Skills and Requirements:

• Bachelor’s or Master’s degree in Statistics or Applied Mathematics or equivalent experience
• Fluent in SQL, JavaScript, Python
• Familiarity with Google BigQuery
• Adept in at least one visualization tool (DataStudio, Tableau, Power BI)
• High attention to detail
• Excellent written and verbal communicator
• Collaborative team-player yet comfortable with independence

Nice-To-Haves:

• Python
• Experience with Google Campaign Manager, DV360, Facebook, and/or Google Ads Data
• Experience working with Slack and other project management applications

The Interview Process:

• Intro Call (15-20 minutes)
• Panel Interview (45 minutes)
• Final Round Interview (30-45 minutes)
• Meeting with management

Benefits:

• Competitive Salary
• RRSP Matching
• Generous Equipment Budgets: get what you need to be productive.
• Work From Home: many of our team members work from home, but come into the office as you’d like!
• Globetrotter: For up to six weeks every year, you can work anywhere you’d like as part of our ‘Globetrotter’ remote work policy.
• Benefits + Wellness: enjoy a comprehensive package that includes a health spending account that you can use at your discretion.
• 3 Weeks Vacation: take time off when you need it! We also close during the holiday break.
• Extended Long Weekends: for each statutory holiday, we’ll close our office and extend the holiday to a 4-day weekend.

Our Values:

We know our people are what allows us to achieve all that we do and that’s why it’s important that everyone we bring onto our team lives our values with us.

• Give A Sh!t: we learn nonstop because we love what we do. Because we love what we do, we do it extremely well
• Got Your Back: we take care of each other. We support one another. We build each other up. There is no culture without great people.
• Yes Before No: we are solution focused. We are flexible, inquisitive and positive. Any innovation must start with yes.
• Inclusive: we seek differing opinions. We ensure all voices are heard. We are strong when we are different.
• We’ve Got Guts: we empower change. We step outside our comfort zone and bring our teammates with us. We have tough conversations. We ask to be challenged. We listen.

Hotspex Media Inc. is an equal opportunity employer and values diversity in its workforce.