Analytics Engineer – Sports & Media Analytics

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…