Overview:

We are seeking an Analytics Engineer II to join our growing Data organization and help establish our Risk & Governance Analytics team. This role reports to the Analytics Engineering Manager and will focus on building scalable data models and analytics infrastructure to drive business growth, partnering closely with all organizations within the business.

As an Analytics Engineer, you’ll be responsible for designing and implementing robust data models, transforming raw data into reliable analytics-ready datasets, and establishing best practices for our data transformation layer using modern data stack tools.

Responsibilities:

• Design, develop, and maintain dimensional data models (fact and dimension tables) that support the organization.
• Build and optimize dbt models, including staging, intermediate, and mart layers, following software engineering best practices
• Create and maintain comprehensive documentation for data models, business logic, and data lineage
• Implement data quality tests and validation frameworks using dbt tests and other testing tools
• Collaborate with Data Engineers to optimize data warehouse performance and design efficient ELT/ETL processes
• Partner with Analytics, Machine Learning, and Data Science teams to understand business requirements and translate them into scalable data models
• Establish and maintain data modeling standards, naming conventions, and best practices across the organization
• Develop insightful KPIs and metric definitions in collaboration with business stakeholders
• Remain current on analytics engineering best practices, data modeling techniques, and modern data stack technologies

Qualifications:

• 3-5 years of experience in analytics engineering, data engineering, or related roles
• Strong expertise in data modeling concepts including star schema, snowflake schema, fact tables, dimension tables, and slowly changing dimensions (SCDs)
• Proficiency with dbt (data build tool)
• Expert-level SQL skills with experience writing complex queries, CTEs, window functions, and performance optimization
• Experience working with modern cloud data warehouses (Snowflake, BigQuery, Redshift, or Databricks)
• Understanding of data transformation best practices and software engineering principles (version control with Git, code reviews, CI/CD)
• Familiarity with BI tools (Tableau, Sigma, Power BI, or similar) and understanding of how data models support downstream analytics
• Demonstrated ability to translate business requirements into technical data solutions
• Strong documentation and communication skills with ability to explain complex technical concepts to non-technical stakeholders
• Experience with data quality frameworks and testing methodologies
• Customer-focused mindset with strong problem-solving abilities and attention to detail

Preferred Qualifications:

• Experience or interest in the sports betting/gaming industry
• Experience with metadata management and data catalog tools

• Understanding of DataOps and analytics engineering workflows

The base salary range for this role is $110,200 - $163,850 per year, depending on job-related knowledge, skills, and experience. This role is eligible for the Fanatics Betting and Gaming annual bonus program and an equity award. In addition to the base, bonus, and equity, full-time employees are eligible for Medical, Dental, Vision, 401K, paid time off, and other benefits like GymPass, Pet Insurance, Family Care Benefits, and more. We’ll also give you $700 to set up your home office!

For information about our benefits, please visit https://benefitsatfanatics.com/

Launched in 2021, Fanatics Betting and Gaming is the online and retail sports betting subsidiary of Fanatics, a global digital sports platform. The Fanatics Sportsbook is available to 95% of the addressable online sports bettor market in the U.S. Fanatics Casino is currently available online in Michigan, New Jersey, Pennsylvania and West Virginia. Fanatics Betting and Gaming operates twenty-two retail sports betting locations, including the only sportsbook inside an NFL stadium at Northwest Stadium. Fanatics Betting and Gaming is headquartered in New York with offices in Denver, Leeds and Dublin.