Remote

Finance Data Analyst (Contract)

Sony Interactive Entertainment
United States
Jan 03, 2025
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. *Please note: this is a temporary position through our staffing partner DZX with an anticipated duration of 6 months.* The Finance Data and Reporting (FDR) team within the Studios Business Group (SBG) is focused on streamlining the relevant data and reporting infrastructure to provide speedy and easy access to the relevant data and metrics needed for delivering strategic insights and recommendations, and for facilitating informed business decisions to achieve our financial objectives. The FDR team is looking for a Finance Data Analyst to help streamline the data flows and related data pipelines, and drive continuous improvement, standardization, speed, and automation of end-to-end financial data management. The Data Analyst will collaborate with cross-functional teams to ensure data accuracy and integrity and assist in implementing data governance practices. They will work in collaboration with the enterprise data team in complementing the existing data, designing and maintaining ETLs/ELTs, and developing data models. They will work on financial and operational data to support a variety of global teams with their data and BI needs. Work you'll be doing As a Data Analyst in the FDR team, you will: Collaborate with the enterprise data infrastructure team and complement their efforts in providing the finance team with easy access to relevant data Collaborate with the broader SBG Finance team members to improve data models that feed the business intelligence tools Streamline the existing data processes in use for reporting Design, develop, and maintain ETL/ELT processes from a variety of sources to Snowflake Data Warehouse Monitor ETL/ELT performance and identify ways to streamline processes and reduce time or resource load Design a data quality framework, and implement processes and systems to monitor data quality, ensuring production data is always accurate and matches across systems Create and maintain relevant process documentation for all data management processes along with documenting mapping of data across sources Create user documentation and a data dictionary for all the relevant data across various data environments in a Wiki to allow for the effective use of available data Support BI analysts in building highly functional and appealing reports/dashboards with the creation of advanced SQL queries Support BI Analysts with report performance optimization Work on ad hoc data reporting requests and perform other role-related duties as assigned Qualifications you have 4+ years of experience working with ETL/ELT centered around Snowflake; proficient with ETL processes and industry leading ETL tools Experienced in designing, building, and maintaining data processing systems; advanced knowledge of ETL best practices Advanced knowledge of database schema design, dimensional data modeling, and data warehouse architecture (4+ Years) Advanced knowledge of SQL (4+ Years) Experience in troubleshooting data integrity issues and creating frameworks to avoid/catch them Proficiency with Microsoft Excel & PowerPoint Intermediate knowledge of Python Experience with Tableau/Domo/Looker/PowerBI Additional skills you have Proven ability to learn new tools/environments Comfortable working in a global matrix-based team with a varied set of customer groups Analytical orientation and strong problem-solving/troubleshooting skills, demonstrated by the ability to structure an issue and analyze alternative solutions Knowledge of best practices and IT operations in an always-up, always-available service Process-oriented with great documentation skills Excellent oral and written communication skills with a keen sense of customer service Self-starter with the ability to take things to the next level Ability to balance multiple priorities simultaneously and meet deadlines as required Other skills that may be beneficial to have Ab Initio Alteryx Familiarity with finance data and reporting systems such as SAP, COGNOS, etc JIRA & Confluence experience *Please refer to ourCandidate Privacy Noticefor more information about how we process your personal information, and your data protection rights.* At SIE, working with our partners, 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 individual base pay range may vary based on job-related factors which may include knowledge, skills, experience, and location. In addition, this role is eligible for benefit offerings that include medical, dental, and vision. Click hereto learn more. The estimated base pay range for this role is listed below, this is an hourly rate. $47 — $71 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.