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.
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.
