Analytics Engineer

At Cameo, we make impossible connections possible. Our platform allows fans to get personalized messages from their favorite comedians, actors, athletes, and more.... not gonna lie, it’s pretty magical. And now we’re looking for passionate, hardworking humans to help take Cameo to the next level.

🚀 Our #Fameo means everything to us. Join a stellar team of smart, curious, and driven individuals, and experience working at a globally known consumer startup.

📈 Best in class. We’ve been named one of LinkedIn’s Top 50 Startups to Work For, voted one of America’s Best Startup Employers by Forbes, and the #1 Most Innovative Social Media Company by Fast Company.

💰Get all good stuff. Health insurance, 401(K), Fun work environment at our Downtown Chicago Headquarters, and opportunities to meet Cameo Talent!

Come to work every day knowing your efforts will have a material impact, shaping the direction of the next outstanding tech company!

About the role:

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.

Responsibilities:

• 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.

What you bring to the table:

• 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.).

Benefits:

• Competitive compensation package with benefits.
• Collaborative work culture that encourages innovation and personal development.
• Flexible work arrangements, including remote work options.
• Opportunity for career growth and learning in the analytics and entertainment industries.

Cameo is an equal opportunity employer. We are committed to creating an inclusive and welcoming environment for every person who walks through our doors. All employment is decided on the basis of qualifications, merit, and business need. Cameo celebrates and embraces diversity.

The salary range for this position is $125,000 to $163,000 with opportunities for additional compensation based on performance.  Cameo determines salary ranges by role and level with ranges for US roles typically based on our home market of Chicago. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within that range, individual pay is determined by job-related skills, experience, and relevant education and training. Posted salary ranges reflect base salary only, exclusive of equity, commissions, and other compensation and benefits.

Please consult the Notice to California Residents contained in Cameo's Privacy Policy available at https://www.cameo.com/privacy for information regarding your rights under the California Consumer Privacy Act if you are a California resident.