Business Analyst

Summary

Join our dynamic Advertising team where data meets creativity! As a Data Analyst, you will leverage PPC and DSP data, Amazon Marketing Cloud, and SQL to evaluate campaign impact and identify trends. You will create dashboards using Power BI and DAX, and automate data pipelines using Power Automate. Collaboration with technology teams across time zones is expected, along with contributing to case studies. You will design experiments, integrate solutions across ad platforms, and support QA across data systems. The ideal candidate possesses a Bachelor's degree in Computer Science and 2-5 years of experience in a data analyst role, with expertise in SQL, Excel, and statistical analysis tools. Experience with PPC or DSP and Amazon Marketing Cloud is preferred. We consider candidates who meet the specific job qualifications, whether they are located near our Lehi, UT office or have the ability to work remotely.

Requirements

• Bachelor's in Computer Science with 2-5 years' experience in a data analyst role, bonus for experience in digital marketing, PPC or DSP
• Expert level proficiency in SQL, Excel, and in statistical analysis tools and BI tools preferably Power BI & Quicksight
• Adept at queries, analyzing results using statistical techniques, report writing, and presenting findings
• Quick learner, analytical thinker and able to rapidly acquire and apply technical skills under tight deadlines
• Must be detailed oriented and have the ability to prioritize multiple tasks
• Excellent English communication skills, both written and verbal

Responsibilities

• Leverage PPC and DSP data, Amazon Marketing Cloud, and custom SQL queries to evaluate campaign impact and identify trends across KPIs
• Create content improvement analytics and compliance dashboards to assess the impact of language updates on sales performance
• Build and maintain Power BI dashboards (DAX proficiency required) and automate data pipelines using Power Automate for continuous insights
• Coordinate with technology teams across time zones and contribute to case studies showcasing advertising outcomes
• Design experiments, integrate solutions across multiple ad platforms, and support QA across data systems to refine strategy and execution

Preferred Qualifications

• Experience analyzing PPC (or DSP) and search advertising products on multiple ecommerce marketplaces highly preferred
• Experience with Amazon Web Services or Amazon Marketing Cloud