Expert Business Intelligence Analyst
- San Diego
- Full-time
- $160,992 to $175,000
- Posted
Skills
Job description
Sony Electronics Inc. is looking for the risk-takers, the collaborators, the inspired and the inspirational. We want the people who are brave enough to work at the cutting edge and create solutions that will enrich and improve the lives of people across the globe. In addition to competitive pay and benefits, we offer an environment and culture that promotes Diversity, Equity and Inclusion. In addition, our team members enjoy innovative work-life balance opportunities including a hybrid home/office workplace, monthly “Free Fridays”, and early shutdowns on Fridays throughout the year (including half-days during the summer).
Join us on our mission to fill the world with emotion through the power of creativity and technology.
Position : Expert Business Intelligence Analyst
Job Location : 16535 Via Esprillo, San Diego, CA 92127
Duties : Architect and lead enterprise BI strategy: Lead the architectural design and long-term roadmap for the Microsoft Fabric and Power BI ecosystem; oversee the development and enhancement of enterprise-scale BI solutions to ensure they are scalable, secure, and aligned with evolving business needs. Platform governance and health management: Establish enterprise-wide development standards, security protocols, and monitoring frameworks; manage the stability and performance of high-compute analytics environments while overseeing the prompt resolution of complex platform issues. Advanced integration and modeling oversight: Direct the architectural design of end-to-end ETL/ELT pipelines and dimensional schemas, integrating complex data from SAP (FI/CO, SD, MM, BW) and cloud sources to support strategic decision-making and operational reporting cycles. Technical requirement engineering and collaboration: Serve as the lead technical advisor for Finance and Sales leadership, translating complex business objectives into robust technical specifications and overseeing cross-functional collaboration and high-level process documentation. Performance optimization and actionable insights: Lead the optimization of complex SQL/T-SQL workloads and PySpark solutions; direct the transformation of raw data into actionable insights while identifying and implementing new methodologies to improve data quality and process delivery. Leadership and user excellence: Oversee the full project lifecycle and conduct technical code reviews; provide and lead user training initiatives to ensure the organization maximizes the utility of BI tools and adheres to global best practices.
Minimum education and experience required : Master’s degree or the equivalent in Computer Science, Data Science, Information Technology, or a related field plus 4 years of experience in Business Intelligence and Data Analytics, or related experience OR Bachelor’s degree or the equivalent in Computer Science, Data Science, Information Technology, or a related field plus 6 years of experience in Business Intelligence and Data Analytics, or related experience.
Skills required : Must have experience with: defining and overseeing long-term technical architecture and strategic roadmaps for cloud-based BI ecosystems to ensure enterprise-scale scalability and cross-platform compatibility; providing technical training to junior developers and enforcing enterprise-wide data governance, documentation standards, and rigorous peer code review processes; partnering with executive-level stakeholders to translate organizational KPIs into technical data strategies and managing the end-to-end delivery of high-impact analytics projects; designing and developing BI dashboards and semantic data models in Microsoft Power BI and Fabric (DAX, Power Query/M, Lakehouse, Dataflows Gen2, Pipelines); integrating and modeling SAP FI/CO, SD, MM, and BW, SQL Server and SharePoint data into star-schema models for analytics; building Power Automate Cloud/Desktop flows to orchestrate dataset refreshes, move files, and automate distribution/alerts; designing and maintaining ETL with Informatica PowerCenter, SSIS and SQL Server for staging and DW loads; writing and optimizing complex SQL/T-SQL queries/views for extraction, transformation, validation and reporting; creating interactive dashboards for pricing, revenue and performance analytics; designing dimensional Data Warehouse schemas for high-performance reporting; implementing data quality/governance controls (validation rules, reconciliations, data dictionaries, lineage); developing Python and PySpark solutions for data pipelines, AI/ML predictive & statistical analytics and automation of Excel/pricing models; building advanced Excel analytics (Power Pivot, complex formulas, pivots, VBA) for pricing/financial reporting; converting business requirements into technical specifications and complete process flows to build scalable BI/ETL solutions; delivering Finance/Accounting and Sales reporting; and enabling CI/CD with Azure DevOps and Git; Leading the design of Projects and models, ensuring all deliverables meet best practices and on time; Leading system upgrades and platforming health monitoring while establishing platform-wide development standards and best practices to ensure scalable, high-performance BI environments. Employer will accept any amount of experience with the required skills.
The base pay range for this position is $160,992 to $175,000. The actual base salary offered depends on a variety of factors, which may include as applicable, the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, certifications or other professional licenses held, and the location in which the applicant lives and/or from which they will be performing the job.
In addition to a competitive base salary this position is also eligible for a bonus, and a comprehensive benefits package including healthcare benefits (medical, dental, and vision), paid medical leave after three months of employment, a 401k plan with matching company contributions, vacation time, education assistance, student loan assistance program, eighty hours of paid sick leave time annually, and up to twelve weeks paid parental leave after six months of employment.
To apply for this position, please visit https://www.sonyjobs.com/jobs.html and insert requisition number HJ-EBIA-MF. Sony Electronics, Inc. is an Equal Opportunity/Affirmative Action Employer.
Sony Electronics Inc. is an Equal Opportunity Employer that values employees with a broad cross-cultural perspective. We strive to create an inclusive environment, empower employees and embrace diversity. We encourage everyone to respond.
We sincerely appreciate the time and effort you sp
ent in contacting us and thank you for your interest in Sony Electronics Inc.
Honesty, integrity, and ethical conduct are material requirements for the responsibilities outlined above.
Sony Electronics is an Equal Opportunity Employer that values employees with a broad cross-cultural perspective. We strive to create an inclusive environment, empower employees and embrace diversity. We encourage everyone to respond. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, citizenship status, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.
Individuals residing, or applying to work, in California or Philadelphia. The Company will consider qualified applicants with arrest or conviction records in accordance with the California Fair Chance Act, Los Angeles City Fair Chance Act Ordinance, Los Angeles County Fair Chance Act Ordinance, and San Francisco Fair Chance Act Ordinance. Los Angeles applicants can review additional information regarding the Los Angeles City Fair Chance Act here , and Philadelphia applicants here .
Disability Accommodation for Applicants to Sony Electronics Inc. and Sony of Canada ULC
Sony Electronics Inc. and Sony of Canada ULC. provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. For reasonable accommodation requests, please contact us by email at talenthelp am.sony.com , or you can mail your resume to: Sony Electronics, Human Resources Department, 16535 Via Esprillo, San Diego CA 92127. Please indicate the position you are applying for.
Recruitment Fraud Notice
We are aware that unauthorized individuals or organizations may attempt to impersonate our company through fraudulent job postings to solicit personal information or payments from applicants. While we take these matters seriously, we cannot control third-party websites. To protect your personal information, always verify that any job posting you respond to also appears on our official Careers page: www.sonyjobs.com . Be advised that we never request personal identifying information (such as Social Security numbers, bank details, or copies of identification documents) during the initial stages of our application process. If you have any doubts about the authenticity of a job posting or communication, please contact talenthelp am.sony.com before submitting any information.
EEO is the Law
EEO is the Law Supplement
Know your Rights
Right to Work
E-Verify Participation