Skip to content
Analytics Engineer
| Company | Cameo |
|---|
| Location | Chicago, IL, USA |
|---|
| Salary | $125000 – $163000 |
|---|
| Type | Full-Time |
|---|
| Degrees | |
|---|
| Experience Level | Mid Level, Senior |
|---|
Requirements
- 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.
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.
Preferred Qualifications
- Proficiency building dashboards and visualizations in Looker or similar dashboarding tools (Tableau, PowerBI, Sigma, etc.).
