Reporting Data Analyst

Job Responsibilities:

Compile Reports for Performance for 7-10 Agency Clients

Ideal candidate is analytical and has experience with Powerbi , Seller Central, Amazon Campaign Manager, Scale Insights and is well versed in Excel.

Assist Growth Specialist in analyzing reports to highlight wins, opportunities and challenges for clients.

Download and source reporting from Powerbi that track current month to date KPI's to the previous months KPI.

Preparing weekly client facing reports and performance summaries that include across Amazon, Walmart and Target.
Overall account performance including total sales, PPC sales, conversion, impressions, click through rate, PPC spend, ROAS
Keyword ranking to show improvements/declines in organic ranking per sku and per brand
Highlighting top performing campaigns
Top performing keywords per sku
Breakdown on branded verses non branded performance
Help to provide daily reporting that track the delta compared to the previous month for profit, total sales, total ad sales.

Prepare reports that comparing current monthly sales forecast trends to approved budgets/forecast set at the beginning of the year.