Lead Analytics Engineer

PlayStation; Ottawa; On-site; CAD 90,000 - 120,000; Full time

Job summary

PlayStation is seeking a Lead Analytics Developer to scale our analytics platform, working with cross-disciplinary teams and game studios to design durable in-game telemetry and data models. You will own data models for specific games and ensure consistency and performance in analytics pipelines.

The role emphasizes SQL on analytics databases (Redshift), and advancing data modeling tooling such as dbt and SQLMesh, with a focus on quality and testable database development.

Qualifications

• Experience building data models for game analytics and telemetry.
• Strong SQL for analytics on OLAP databases (Redshift).
• Degree in Computer Science or equivalent.

Responsibilities

• Develop data models for new title launches and telemetry validation.
• Collaborate with game studios and data analysts to design scalable data models.
• Expand use of dbt and Airflow across analytics pipelines.

Skills

SQL

Python

Airflow

AWS Glue

Git

Liquibase

dbt

SQLMesh

Big Data

Education

Bachelor's degree in Computer Science

Tools

Redshift

Airflow

dbt

SQLMesh

Liquibase

Git

AWS Glue

Job description

• As a Lead Analytics Developer, you'll work in our cross-disciplinary engineering team to scale our platform, expand its reach, and help define and build the future of analytics for PlayStation games. You should have a passion for video games and a background in data or analytics engineering. You're looking for a fun, dynamic environment to take on new challenges
• In your first six months, you will work on new title launches, and build data models to ensure efficient and consistent queries. To build these data models, you'll work directly with game studios and data analysts to design and validate suitable in-game telemetry
• You'll also help expand our use of technologies, such as dbt and airflow, in ways that are suitable to our use cases. You will be given ownership of data models for specific games and work closely with Game Analytics team members and game studio colleagues to ensure we're building with consistency and performance in mind

You are adept at writing SQL on analytics (OLAP) databases (preferably Redshift, or similar databases)You're committed to quality as a top priority, and have an interest in repeatable, testable, destructible, test-driven database developmentYou have experience in transforming business needs into data model requirements & solutionsExperience with Python, AWS Glue, source control (Git, Liquibase), AirflowYou have experience implementing and using data modelling tools such as dbt or SQLMeshA degree in Computer ScienceFamiliarity with AAA game development and modern console gamesYou're excited by Big Data projects and technology, and want to gain more experience in this area

Bonus points for: