Analytics Engineer, Cameo

$125-163k

SQL

Tableau

Looker

Power BI

Redshift

Snowflake

BigQuery

Git

dbt

Mid and Senior level

Chicago

4+ days a week in office (West Loop, Chicago)

Marketplace for gifting personalised videos from celebrities

Open for applications

Marketplace for gifting personalised videos from celebrities

201-500 employees

B2CMarketplaceSocialDigital Media

Open for applications

$125-163k

SQL

Tableau

Looker

Power BI

Redshift

Snowflake

BigQuery

Git

dbt

Mid and Senior level

Chicago

4+ days a week in office (West Loop, Chicago)

201-500 employees

B2CMarketplaceSocialDigital Media

Company mission

Cameo's mission is to create the most personalised and authentic fan experiences in the world.

Job

Company

Role

Who you are

3+ years of analytics engineering or data engineering experience, with a strong focus on data warehouse modeling
Expert-level SQL skills and experience optimizing complex queries
Strong understanding of dimensional modeling concepts applied to modern data warehouses: Snowflake, BigQuery, Redshift, or similar
Advanced DBT engineering experience: maintaining large-scale DBT projects, materialization strategies for optimal performance, modular transformation with macros and packages, and data testing frameworks
Proficiency with Git and CI/CD practices for data
Relevant technical background through education and/or professional experience. We value demonstrated skills and practical knowledge over specific degrees
Nice-to-have: Proficiency building dashboards and visualizations in Looker or similar dashboarding tools (Tableau, PowerBI, Sigma, etc.)

What the job involves

Cameo is seeking an experienced Analytics Engineer to join our data team. As a technical owner of our extensive data transformation pipelines, you'll architect data models that power decision-making across the organization
This high-impact role balances engineering best practices with business requirements to deliver reliable, performant data that can scale with our growth
Own and maintain Cameo's DBT environment for data transformations and ELT processes
Design and implement dimensional models that balance performance with flexibility for a dynamic business
Maintain standards for data modeling, validation, and documentation
Collaborate with data analysts, engineers, and business stakeholders to translate between business concepts and data structures
Develop and maintain data visualizations and reports to track business performance and provide actionable insights to stakeholders
Identify opportunities for data-driven optimization across different business functions, including fan and talent acquisition and growth

Our take

Cameo is an American video-sharing website that allows celebrities to interact with users via video. For a low price of $5 to a high fee of $3,000, customers pay Cameo for lightly scripted messages from celebrities.

They've helped create over 500,000 moments for their customers and built a marketplace for over 20,000 celebrities to connect with their biggest fans. They're breaking down the exclusivity myth of celebrity by building personal relationships between fans and talent.

Whilst Cameo has done exceptionally well over the past few years, it's now starting to wane as it fails to source A-listers for its platform, and as a result, the company has reduced the number of its staff. Off the back of the launch of Cameo Business, a lack of proper disclosure concerning endorsements led to several lawsuits filed against the company in 2024. However, the company has taken action to balance the costs with its cash reserves and refocus its goals.

Freddie

Company Specialist at Welcome to the Jungle

Insights

Top investors

1% employee growth in 12 months

Glassdoor (3.1)

Trustpilot (2.2)

Company

Funding (last 2 of 5 rounds)

Mar 2024

$28m

LATE VC

Mar 2021

$100m

SERIES C

Total funding: $193.7m

Company benefits

Competitive salaries
Equity
Health insurance
401(k)
Wellness perks
Nlimited PTO
Heads Down Hump Days 🐪 (aka no recurring meetings), and an annual talent show that will have you LOL-ing - just to name a few
Oh, and did we mention Cameo works with noteworthy actors, athletes, musicians, your favorite creators, global superstars, famous furry friends and more!?

Company HQ

West Loop, Chicago, IL

Leadership

Devon Townsend

(Co-Founder & CTO)

Previously Program Manager at Microsoft for 1 year and Senior Software Engineer at CollegeBand for 2 years.

Steven Galanis

(Co-Founder & CEO)

Previously Options Trader at Belvedere Trading for 3 years and Broker Associate at North Clybourn Group for 2 years.

Salary benchmarks

We don't have enough data yet to provide salary benchmarks for this role.

Submit your salary to help other candidates with crowdsourced salary estimates.

Share this job

View 1 more job at Cameo