Remote Analytics Engineer

Summary

Join Rec Room as an Analytics Engineer and be a key member of a small team supporting our data warehouse and analytics layer, setting us up to scale in both the number of players and internal users.

Requirements

• 3+ years of SQL development experience
• Solid proficiency in SQL (aggregate functions, window functions, complex joins, CTE), including query optimization skills
• Previous experience with pipeline orchestration. DBT and Prefect preferred
• Experience with dashboarding tools. Sigma and Hex experience is a plus
• Familiarity with processes for handling event-based data is a plus
• Experience with Python and Javascript is a plus

Responsibilities

• Partner with PMs, designers, engineers, and analysts/data scientists to build out the data layer to empower analysis, experimentation, and new product features
• Develop and maintain our ELT pipeline, which includes streaming, micro-batch, and daily batch load processes using tools such as Rudderstack, Fivetran, Prefect and DBT
• Develop data warehouse models on a Databricks SQL Warehouse using established patterns and processes that serve as the foundation for scaling our data
• Apply software engineering practices (e.g., code review, testing, version control, iterative development) when creating new datasets to ensure data quality across our pipelines and BI tools
• Work with the support of senior engineers, taking on increasingly complex projects
• Design and implement top-level company dashboards to serve as the source of truth for company performance using tools such as Sigma and Hex
• Build out experimentation datasets and pipelines to allow for granular analysis of A/B tests
• Partner with ML teams to build out data models to be used in model deployment
• Work with partner teams to build datasets that will impact production, such as creator and player statistics
• Be curious and constantly learning!

Benefits

• Flexible vacation
• Medical, dental, and vision plans that cover you, your spouse/domestic partner, and your children
• Retirement benefits with a company match
• Unlimited paid time off