Data Engineer

The Partners Data Engineering team (LA) provides data pipe, warehousing and analytics solutions for the PlayStation Partners Platform - a vital collection of applications and services used by our partners (content creators, game developers and publishers) worldwide to create and publish games and content on PlayStation.

Our mission is to deliver timely, scalable and high quality data and insights to empower our business to make data-driven decisions, drive operational efficiencies and identify revenue opportunities.

As Data Engineer you will implement end-to-end data solutions that are highly available, maintainable, secure and cost-effective.

We are looking for

• A Data Engineer with a strong background in AWS to build scalable, highly available data pipes and data warehousing solutions
• An energetic professional who is passionate about solving complex problems with data, and who plays well with others!

The ideal candidate will be highly self-motivated and willing to work with multiple teams, local and remote. If this is you, please apply!

What you’ll be doing:

• Create and socialize designs, lead design sessions, perform technical reviews.
• Build highly scalable, resilient data pipelines
• Design and build data models which produce high quality datasets.
• Own, maintain and ensure high quality engineering standards and practices in the team
• Contribute to our SDLC tooling and processes.
• Diagnose and solve platform and data issues - perform root cause analysis and apply solutions to prevent re-occurrence
• Deliver analysis that distills clear, meaningful insights from large, complex datasets.

What we are looking for:

• 3+ years of relevant industry experience in a data engineering capacity
• Experience translating business needs to scalable data solutions.
• Experience building highly scalable data pipelines (batch and streaming) using AirFlow, Spark, EMR, Kafka, AWS Kinesis.
• Experience designing and developing solutions on AWS, including infrastructure as Code (e.g. Cloud Formation, Terraform, AWS CDK)
• Experience with AWS compute resources such as Lambda and EC2
• Experience with containers such as AWS ECR, ECS, and Docker.
• Experience with Cloud Data Warehousing / Data Lake technologies and architectures such as Snowflake, AuroraDB or any relational database experience.
• Proven data modeling skills - must have demonstrable experience designing models for data warehousing and analytics use-cases (e.g. from operational data store to semantic models)
• Python, shell scripting experience for automation, data manipulation and creation of applications.
• Expert SQL skills to create views and power dashboards for analysis.
• Strong understanding of software engineering principles - able to write elegant, scalable and maintainable code.
• Strong communication skills - you will be able to tailor your communication to technical and less technical audiences alike

Desirable Skills:

• Experience with Airflow highly advantageous
• Experience with Snowflake highly advantageous
• Python expertise with object oriented programming knowledge.
• Experience using dashboarding tools such as Tableau, Superset, Domo or similar.
• Experience preparing large, complex datasets for Machine Learning pipelines.
• Prior experience working in an Agile environment.
• Gamer or experience in the gaming industry is a plus.