remote
Analytics Engineer - Sports & Media Analytics - Ziventra
Data Engineer
Senior Analytics Engineer with 8‑10 years of experience building scalable data pipelines and dimensional models in SQL and dbt, driving sports and media analytics insights for remote teams.
About the role
Key Responsibilities
- Design, develop, and maintain scalable data transformation pipelines using SQL, dbt, and Jinja templating.
- Build and optimize dimensional data models in dbt to support analytics, reporting, and BI consumption.
- Collaborate with Product, Analytics, and BI teams to translate business requirements into robust analytical data models.
- Perform exploratory data analysis (EDA) using SQL to uncover insights and inform model design.
- Implement advanced dbt macros, packages, testing, and deployment workflows to ensure data quality and reliability.
- Document data models, transformation logic, and best practices for cross‑functional teams.
Requirements
- 8‑10 years of experience in analytics-focused data engineering or analytics engineering.
- Proficiency in SQL, dbt, and Jinja templating.
- Strong background in dimensional modeling and data warehouse design.
- Experience with automated testing, CI/CD pipelines, and deployment of data models.
- Excellent communication skills and ability to work collaboratively in a remote environment.