Data Engineer II

Sony Interactive Entertainment
paid time off, 401(k)
United States, California, San Mateo
Dec 18, 2024
Why PlayStation? PlayStation isn't just the Best Place to Play - it's also the Best Place to Work. Today, we're recognized as a global leader in entertainment producing The PlayStation family of products and services including PlayStation5, PlayStation4, PlayStationVR, PlayStationPlus, acclaimed PlayStation software titles from PlayStation Studios, and more. PlayStation also strives to create an inclusive environment that empowers employees and embraces diversity. We welcome and encourage everyone who has a passion and curiosity for innovation, technology, and play to explore our open positions and join our growing global team. The PlayStation brand falls under Sony Interactive Entertainment, a wholly-owned subsidiary of Sony Corporation. Data Engineer (ICDS) PlayStation is for The Players. Sony Interactive Entertainment (SIE) has over 150 Million customers across 109 countries. We use data to understand our customers, The Players, better. We analyze how they use PlayStation5 and other systems for gaming, as well as networked services like streamed games, music, and video. Our goal is to enhance their customer experience by collaborating with games developers, marketing, R&D, PlayStationStore, and other Sony departments. PlayStation also strives to build an inclusive environment that empowers employees and embraces diversity. We welcome and encourage everyone who has a passion and curiosity for innovation, technology, and play to explore our open positions and join our growing distributed team. The PlayStation brand falls under Sony Interactive Entertainment, a wholly-owned subsidiary of Sony Corporation. The ICDS DE team has expanded quickly in recent years to meet the growing demand for data-driven decision-making and identifying new opportunities. Currently, the ICDS DE team consists of around 120 staff members in London and California. These professionals specialize in architecture and platform support, data processing, and technical program management. ICDS DE is seeking dedicated, hard-working individuals who have excelled in previous roles and are seeking a new challenge in a dynamic and rewarding environment. ICDS provides data for Analytics, Data sciences, Marketing, ML, and other teams in PlayStation business. The data is high quality, valuable, accessible, and continuously improving. ICDS Data Engineer We are looking for a Data engineer to join the ICDS Player DE team within the Sony PlayStation environment. The Data Management team is seeking a Data engineer who will design, develop, and maintain the data processing platform. The successful applicant must work well in a skilled team and be self-motivated. Based in our San Diego offices, the team provides data services for various global business units associated with Sony PlayStation. Responsibilities Engineer data pipelines and provide automated solutions for ICDS DE teams Work proactively to address project requirements, and articulate issues challenges with enough lead time to address project delivery risk System monitoring and alerting, dashboards, charts/reports and alerts delivery Ensure code is fully scalable, maintainable, and performant Verifies program logic by coordinating the preparation of test data, testing, and debugging of programs Work with Project Managers and TPM to ensure the timely delivery of project deliverables that meet requirements Requires ability to work in a global and multi-cultural environment. Team members are in multiple geographies, resulting in time constraints due to time zones differences and a requirement for occasional travel Participate in the agile development process Develops new documentation, departmental technical procedures and user guides Experience BS Degree in Engineering or Masters, Computer Science or equivalent experience 5+ years of experience in database development, programming, design, and analysis - 5+ years of experience in coding and scripting languages - Java, Python, JavaScript, bash, batch files, Korn. 5 years of experience with Spark, Scala, PySpark 3+ year of experience with data and ETL programming (Databricks, Ab Initio) 5+ years of experience in SQL and a variety of database technologies - Snowflake, Teradata and Oracle. 3+ years of experience in No Sql db (dynanmo db, Cassandra) Good technical analysis & troubleshooting skills Experience in crafting and architecting medium to complex systems, proficient with design standards & framework General knowledge in Linux, Unix Administration and Windows Administration Knowledge of Dimensional Modelling 3+ year of experience with streaming services - Flink, Kafka Experience with automation, configuration management, orchestration, enterprise schedulers 3+ years of experience with AWS services (EKS, S3, EC2, Kinesis, DynamoDB, Glue, Deequ, etc) Skills Required (essential): Demonstrable experience in developing large-scale data processing platforms Extensive experience throughout the software development lifecycle Interpersonal skills including presentation, negotiating, conflict resolution, etc. Strong communication skills. It is imperative that the successful candidate can effectively communicate complex technical issues to customers and partners in a non-technical manner. Ability to multi-task and prioritize within parallel development cycles and aggressive timelines Knowledge and experiences of SDLC methodologies e.g. Agile, Waterfall Strong troubleshooting and problem solving ability Skilled in business requirements analysis with ability to translate business information into technical specifications Eager to learn Skills Required (desirable): Knowledge of data warehouse appliances, e.g. Snowflake, Databricks, Python, Scala, AWS #LI-AT1 *Please refer to ourCandidate Privacy Noticefor more information about how we process your personal information, and your data protection rights.* At SIE, we consider several factors when setting each role's base pay range, including the competitive benchmarking data for the market and geographic location. Please note that the base pay range may vary in line with our hybrid working policy and individual base pay will be determined based on job-related factors which may include knowledge, skills, experience, and location. In addition, this role is eligible for SIE's top-tier benefits package that includes medical, dental, vision, matching 401(k), paid time off, wellness program and coveted employee discounts for Sony products. This role also may be eligible for a bonus package. Clickhere to learn more. The estimated base pay range for this role is listed below. $158,900 — $238,300 USD Equal Opportunity Statement: Sony is an Equal Opportunity Employer. All persons will receive consideration for employment without regard to gender (including gender identity, gender expression and gender reassignment), race (including colour, nationality, ethnic or national origin), religion or belief, marital or civil partnership status, disability, age, sexual orientation, pregnancy, maternity or parental status, trade union membership or membership in any other legally protected category. We strive to create an inclusive environment, empower employees and embrace diversity. We encourage everyone to respond. PlayStation is a Fair Chance employer and qualified applicants with arrest and conviction records will be considered for employment.