Analytics Engineer – Sports & Media Analytics
BEEU Infotech Limited · United States · posted today ago
Listing supplied by Himalayas. 101 Careers did not originate this post and applications are handled by the employer.
About this role
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
