Senior Business Intelligence Analyst

Tbwa Chiat/Day Inc; Aliso Viejo (CA); On-site; USD 147,000 - 222,000; Full time

Job summary

An established industry player is seeking a Senior Business Intelligence Analyst to join their dynamic team in Aliso Viejo. This role involves developing and implementing MicroStrategy dashboards, collaborating with engineering teams, and creating a self-service portal for stakeholders. The ideal candidate will have a Master's degree in Information Technology and experience in data analysis. This innovative firm promotes a diverse and inclusive workplace where creativity and collaboration are encouraged. If you are passionate about data and technology, this is an exciting opportunity to make a significant impact in the entertainment industry.

Qualifications

• Master's degree in IT or related field required.
• 1+ years experience in data analysis and reporting.

Responsibilities

• Develop dashboards and reports using MicroStrategy.
• Collaborate with teams to optimize software performance.
• Create Business Intelligence Self Service Portal.

Skills

MicroStrategy dashboards

SQL

Business Intelligence

Data analysis

Collaboration

Education

Master’s degree in Information Technology

Tools

MicroStrategy

Job description

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.

Position Overview

Sony Interactive Entertainment LLC seeks a Senior Business Intelligence Analyst in Aliso Viejo, CA to develop, implement, and deliver specifications for new tables and views to the data engineering team, and write analytical software documentation that discusses the impact of changes in the streaming environment.

Responsibilities

1. Develop MicroStrategy dashboards and reports to communicate data.
2. Collaborate with software development and engineering system teams to maintain and make changes to software code to ensure optimal performance and resiliency.
3. Convert freeform SQL reports to Schema Object reports by mapping database tables in MicroStrategy.
4. Create Business Intelligence Self Service Portal to empower stakeholders and business users to generate ad-hoc reports and access interactive dashboards in MicroStrategy.
5. Create tables and views in ad-hoc schema for validating the addition/updates in database for existing or new systems.
6. Create reports for user analysis for games, to onboard new titles and manage the catalog.
7. Develop reporting systems software and communicate analyses derived from these with Business Intelligence leadership.

Telecommuting and/or working from home may be permissible pursuant to company policies. Sony is an EOE.

Qualifications

Requires a Master’s degree in Information Technology, or related field or equivalent, and one (1) year of experience performing in-depth analysis of functional and business requirements. Prior experience must include:

1. One (1) year of experience developing MicroStrategy dashboards and reports.
2. Experience collaborating with software development and engineering system teams.
3. Experience converting freeform SQL reports to Schema Object reports.
4. Experience creating Business Intelligence Self Service Portal.
5. Experience creating reports for user analysis for games.

Salary Information

Salary range: $147,847.00 - $221,500.00/year

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.

Apply for this job

* indicates a required field

First Name *

Last Name *

Email *

Phone

Resume/CV

LinkedIn Profile

Website

Please indicate your highest level of education * Select...

Are you legally authorized to work in the United States? * Select...

Will you now or in the future require sponsorship for employment visa status (e.g., H-1B, TN, E-3 visa status, etc.)? * Select...

Are you related to, or in a close personal relationship with, anyone who currently works for SIE or any SIE-affiliated studios? (This includes spouses, domestic partners, and significant others.) * Select...

If yes, please state their name, the department or studio they work for, and their job title (if you know it).

By selecting "Yes", I am certifying that, to the best of my knowledge, the information I have provided in this employment application is true and correct. * Select...

US Voluntary Demographic Question

Voluntary Self-Identification

Our vision at PlayStation is to bring out the best in our global team members by creating a sense of belonging, being a place where they can grow, and ensuring everyone feels valued, heard, and supported so we can push the boundaries of play. That vision begins with our candidates, and we are working to better understand the diversity of our candidate population.

This data will also be aggregated and sent to the government for reporting purposes. Please know that the completion of this form is entirely voluntary. Your personally identifiable information (name, address, etc) will not be considered in the hiring process or thereafter. Any information that you choose to provide will be recorded and maintained in a confidential file for XX time.

Protected Veteran

You are a “protected veteran” under United States law if any of the following apply to you:

• Disabled Veteran: a veteran of the U.S. military who is entitled to compensation (or who would be entitled to compensation if not for the receipt of military retired pay) under the administration of the Secretary of Veterans Affairs and/or a person who was discharged or released from active duty because of a service-connected disability.
• Recently Separated Veteran: a veteran who has discharged or released from active duty in the U.S. military within the last three years.
• Armed Forces Service Medal Veteran: a veteran who, while serving on active duty in the U.S. military, participated in a U.S. military operation for which an Armed Forces Service Medal was awarded pursuant to Executive Order 12985.

Disability

Under U.S. law, you are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and will not be seen by selecting officials or anyone else involved in making personnel decisions, nor will it be shared with our accommodations team. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past.