Lead Analytics Engineer
Summary
PlayStation is hiring a Lead Analytics Engineer in Ottawa to design and own data models for in-game telemetry across its games, working with game studios and analysts to scale the analytics platform. The stack centers on SQL (Redshift/OLAP), dbt, SQLMesh, Airflow, Python, AWS Glue, and Git/Liquibase.
- 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:
