Analytics Engineer – Sports & Media Analytics

This is a remote position.

Job Title: Senior Analytics Engineer (DBT, Snowflake, SQL) Experience: 8 to 10 Years Location: Remote Employment Type: Contract /

Job Summary

We are seeking an experienced Senior Analytics Engineer with strong expertise in dbt, SQL, Snowflake, and Data Warehousing to design, develop, and optimize scalable analytical data models and transformation pipelines. The ideal candidate will have extensive experience building business-ready datasets, dimensional models, and analytics solutions that support reporting, BI, and advanced analytics initiatives.

Mandatory Skills

• 8+ years of experience in Data Engineering / Analytics Engineering
• 3+ years of hands-on experience with dbt
• Strong expertise in Advanced SQL
• Strong experience in Snowflake
• Experience with Amazon Redshift
• Expertise in Dimensional Data Modeling (Star Schema, Snowflake Schema)
• Experience with Data Warehousing Concepts
• Knowledge of Jinja Templating
• Working knowledge of Python
• Experience with Git, CI/CD, and Agile methodologies
• Experience implementing Data Quality, Testing, and Governance Frameworks

Key Responsibilities

Analytics Engineering & Data Modeling

• Design, develop, and maintain scalable data transformation pipelines using SQL, dbt, and Jinja templating.
• Build and maintain robust dimensional data models to support analytics, reporting, and business intelligence.
• Develop reusable dbt models, macros, packages, tests, and documentation.
• Translate business requirements into scalable analytical data models.

Data Warehousing & Optimization

• Design and optimize analytical data marts and warehouse structures.
• Implement best practices for dimensional modeling, fact tables, and dimension tables.
• Optimize SQL workloads using clustering, partitioning, materialization strategies, and performance tuning techniques.
• Ensure high-performance data pipelines and efficient query execution on large datasets.

Data Quality & Governance

• Implement automated testing and validation frameworks within dbt.
• Ensure consistency and accuracy of business metrics across reporting platforms.
• Support data governance initiatives, privacy controls, and access management requirements.
• Maintain high standards of data quality, reliability, and documentation.

Collaboration & Delivery

• Partner with Product, Analytics, BI, and Data teams to understand business requirements.
• Participate in Agile ceremonies and sprint planning activities.
• Perform code reviews and maintain development best practices.
• Collaborate with distributed global teams for successful project delivery.

Required Technical Skills

Analytics Engineering

• dbt Core / dbt Cloud
• dbt Models
• dbt Macros
• dbt Packages
• dbt Testing
• Incremental Models
• Snapshot Management
• Documentation

Database & Data Warehouse

• Snowflake
• Amazon Redshift
• SQL Query Optimization
• Performance Tuning
• Data Warehousing
• Dimensional Modeling

Programming & Automation

• SQL (Advanced)
• Python
• Jinja Templating

DevOps & Development Practices

• Git
• CI/CD Pipelines
• Code Reviews
• Agile/Scrum

Preferred Skills

• Experience with Tableau, Power BI, or Looker
• Experience in Sports, Media, Entertainment, Consumer Analytics, or Digital Marketing domains
• Experience working with customer engagement, audience analytics, and campaign measurement data
• Experience handling clickstream, event-stream, or behavioral datasets
• Exposure to semantic layer design and metric standardization

Educational Qualification

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Mathematics, Statistics, or a related quantitative discipline.

Originally posted on Himalayas