Analytics Engineer Sports & Media Analytics

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, Excel, and other analytical tools to validate business requirements and uncover insights.

Enhance and maintain analytics engineering codebases, including dbt models, macros, packages, tests, and documentation.

Implement data quality frameworks, automated testing, and governance-aligned transformation logic.

Optimize SQL workloads and analytical queries through partitioning, clustering, materialization strategies, and performance tuning techniques.

Ensure consistency of business metrics, semantic definitions, and data logic across dashboards and reporting platforms.

Apply software engineering best practices, including version control, code reviews, CI/CD pipelines, and automated deployments.

Participate in Agile development processes and collaborate effectively with global and offshore teams to ensure high-quality delivery.

Required Qualifications

Bachelor s or Master s degree in Computer Science, Statistics, Mathematics, Engineering, or a related quantitative field.

8+ years of experience in analytics-focused data engineering or analytics engineering roles.

3+ years of hands-on experience with dbt, including advanced model development, macros, packages, testing, and deployment.

Strong expertise in dimensional modeling, data warehousing concepts, and analytics data architecture.

Advanced SQL skills with proven experience in query optimization and performance tuning for large-scale datasets.

Experience working with modern cloud data platforms such as Snowflake and Amazon Redshift.

Familiarity with Python and Jinja templating for analytics engineering and automation use cases.

Experience implementing data governance, privacy controls, data quality standards, and access management requirements.

Strong understanding of Agile methodologies and experience working in distributed team environments.

Excellent problem-solving skills, attention to detail, and a strong ownership mindset focused on building clean, reliable, and trusted data assets.

Preferred Qualifications

Experience in Sports, Media, Entertainment, Digital Marketing, or Consumer Analytics domains.

Exposure to modern BI and visualization platforms such as Tableau, Power BI, or Looker.

Understanding of customer engagement, audience analytics, campaign measurement, and digital product analytics.

Experience working with large-scale event, clickstream, or behavioral datasets.