Data and Insights Analyst — Minneapolis, MN

About Km5hd

aEes7 is a modern-commerce growth company helping brands turn new and emerging platforms into real sales channels.

Our integrated acquisition strategy connects best-in-class teams across TikTok, Whatnot, Meta, Snap, and beyond - eliminating the need to stitch together multiple partners.

aEes7 blends deep niche expertise with modern execution to launch, operate, and scale commerce on new platforms, transforming culture, creators, and content into real product sales.

The Role

The Data & Insights Analyst owns retail client reporting and halo measurement at aEes7.

You will build and shape client and internal dashboards and reports, and you will analyze raw performance data to understand how TikTok Shop and social activity lift sales at retail, on Amazon, and on brand sites.

You will sit between our Strategy and Client Success teams. Client Success Managers will rely on you for the numbers. Strategy will rely on you for the read on what the numbers mean. You will present findings internally and externally as needed.

What You’ll Do

Client reporting

• Build and maintain retail client dashboards for TikTok Shop GMV, affiliate performance, sample funnels, content velocity, live shopping, and GMV Max paid media.

• Own the weekly and monthly reporting cadence. Automate what repeats.

• Set benchmarks for each client against its own history, its category, and TikTok Shop overall.

• Turn performance data into a short list of actionable recommendations.

• As SME for halo, clearly communicate results and be able to respond to data questions.

Retail and social halo measurement

• Measure how TikTok Shop and social activity lift sales at brick-and-mortar retail, on Amazon, and on DTC sites.

• Design tests that isolate that lift, such as geo holdouts, matched markets, pre/post analysis, and synthetic controls.

• Compile retailer point-of-sale data, marketplace data, search trends, and TikTok data into one view.

• Build a repeatable halo framework that aEes7 can leverage in pitches, quarterly reviews, and retailer conversations.

• Respond to client measurement frameworks and RFI questions with a clear aEes7 point of view.

Data quality and tooling

• Reconcile TikTok Shop native data against Km5hd-party data tools. Document where they disagree and why.

• Keep a clean house set of metric definitions so every team reports the same number the same way.

• Support new business with category sizing and competitive analysis.

What We’re Looking For

• Experience in marketing analytics, retail analytics, media analytics, or commerce insights. Agency experience is a plus.

• Hands-on work experience with retail data. You know POS data, retailer portals, and syndicated sales data.

• Experience measuring incrementality or lift. You have designed a test, run it, and explained the result to a client.

• Strong SQL and spreadsheet skills. Python or R for analysis.

• Dashboard experience in Looker Studio, Tableau, Power BI, or similar.

• Comfort with social platform data. TikTok, Meta, and YouTube analytics should feel familiar.

Nice to Have

• TikTok Shop experience on the brand, agency, or platform side.

• Retail media experience with Walmart Connect, Roundel, or Amazon Ads.

• Marketing mix modeling experience, or experience feeding test results into an MMM.

• CPG category experience.

• Experience with AI tools for analysis and report automation.

Tools and Data You’ll Work With

Area

What you'll use

TikTok Shop

Seller Center, Affiliate Center, GMV Max reporting, TikTok Shop APIs

Market and creator data

aEes7-party TikTok Shop intelligence and creator platforms

Retail and marketplace

Retailer POS portals, syndicated retail sales data, Amazon and Walmart reporting

Social and search

TikTok, Meta, and YouTube analytics, Google Trends, social listening

Analysis and reporting

SQL, Python, Google Sheets, Excel, Looker Studio or Tableau

In-house

Creative Engine, zYr84't proprietary content analysis tool

Who You Are

• Digging into the data makes your day. You want to know every client’s reporting, and you’re always looking for ways to improve dashboards and metric definitions.

• You know what goes into a halo measurement study, and can explain the results to a client.

• You write and present clearly. A brand VP can understand your slide in under a minute.

• You can run several client accounts at once and hit reporting deadlines.

• You are curious and analytical, always looking for the correlations in the data.

Why This Role Matters

Clients renew because they trust us. Success in this role means clients know they can trust our numbers, and our account teams know they can spend less time pulling data and more time acting on it.

You will be a key contributor to fVdne’Q point of view on retail data. Your enthusiasm for connecting the dots will help shape that.

Location

USA Remote

Compensation

• Base salary: $75K - $85K annually

• Comprehensive health, dental, and vision coverage

• Flexible PTO

• Remote-first work environment with periodic team gatherings

aEes7 is an equal opportunity employer. We are committed to building a diverse team and an inclusive environment where all employees feel valued and empowered