Finance Data Analyst [Remote]

Finance Data Analyst (Contract) 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 our Candidate Privacy Notice for 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 here to 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. Note: Posting is subject to change so please refer to career site for latest availability (SBJ-G337). Apply Job! Apply tot his job