Skip to content

Analytics Engineer

Cameo LogoCameo
View Organization

Salary

The salary range for this position is $125,000 to $163,000 with opportunities for additional compensation based on performance.

Location

Chicago, IL

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

‌