Expert Business Intelligence Analyst

Sony USA Foundation Inc
San Diego, CA, United States
3 days ago
Apply on sonyglobal.wd1.myworkdayjobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Compensation
$160,992 - $175,000
Working hours
Regular working hours

Tech stack

Microsoft Excel Artificial Intelligence Microsoft Azure Cloud Computing Software Documentation Code Review Continuous Integration Data Dictionary Data Governance Extract Transform Load (ETL) Data Warehousing Excel Formulas
+27 more
Python (Programming Language) Microsoft SQL Server Performance Tuning Powerpivot Raw Data Power BI SAP (Applications) SAP NetWeaver Business Warehouse SAP FI/CO SAP Materials Management SAP Sales and Distribution Microsoft SharePoint SQL Databases SQL Server Integration Services Systems Integration Technical Data Management Systems Transact-SQL Microsoft Power Automate Informatica Powercenter Git Powerquery Microsoft Fabric Pyspark Information Technology Vba Programming Language Data Analytics Data Pipelines

Job description

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.

Requirements

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.

Benefits & conditions

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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on sonyglobal.wd1.myworkdayjobs.com
Prepare application

Good distractions

Loading talks and stories from around this role…