Expert Business Intelligence Analyst
Sony
Summary
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.
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
- Master's degree or equivalent in Computer Science, Data Science, Information Technology, or related field plus 4 years of experience in Business Intelligence and Data Analytics, or related experience OR Bachelor's degree or equivalent in Computer Science, Data Science, Information Technology, or related field plus 6 years of experience in Business Intelligence and Data Analytics, or related experience
- Experience defining and overseeing long-term technical architecture and strategic roadmaps for cloud-based BI ecosystems
- Experience providing technical training to junior developers and enforcing enterprise-wide data governance, documentation standards, and peer code review processes
- Experience partnering with executive-level stakeholders to translate organizational KPIs into technical data strategies
- Experience designing and developing BI dashboards and semantic data models in Microsoft Power BI and Fabric (DAX, Power Query/M, Lakehouse, Dataflows Gen2, Pipelines)
- Experience integrating and modeling SAP FI/CO, SD, MM, and BW, SQL Server and SharePoint data into star-schema models
- Experience building Power Automate Cloud/Desktop flows
- Experience designing and maintaining ETL with Informatica PowerCenter, SSIS and SQL Server
- Experience writing and optimizing complex SQL/T-SQL queries/views
- Experience creating interactive dashboards for pricing, revenue and performance analytics
- Experience designing dimensional Data Warehouse schemas
- Experience implementing data quality/governance controls
- Experience developing Python and PySpark solutions for data pipelines, AI/ML predictive & statistical analytics
- Experience building advanced Excel analytics (Power Pivot, complex formulas, pivots, VBA)
- Experience converting business requirements into technical specifications and process flows
- Experience delivering Finance/Accounting and Sales reporting
- Experience enabling CI/CD with Azure DevOps and Git
- Experience leading design of projects and models ensuring deliverables meet best practices and on time
- Experience leading system upgrades and platform health monitoring
Benefits
- Medical, Dental & Vision
- Paid Medical Leave
- 401(k) Matching
- Vacation Time
- Education Assistance
- Student Loan Assistance
- Paid Sick Leave
- Paid Parental Leave
- Bonus
- Hybrid Work Environment
Company overview
Sony Group Corporation is a Japanese multinational conglomerate headquartered in Tokyo, Japan, founded in 1946. The company operates across diverse business segments including Game & Network Services (PlayStation), Music, Pictures, Entertainment Technology & Services (consumer electronics), Imaging & Sensing Solutions (semiconductors), and Financial Services. With approximately 113,000 employees globally, Sony has established itself as a leader in consumer electronics, gaming, entertainment, and semiconductor manufacturing. The company's iconic products include PlayStation gaming consoles, Bravia televisions, Alpha cameras, Xperia smartphones, and the historic Walkman portable music player. Sony's entertainment divisions encompass major film studios, music labels, and anime production companies. As the world's largest manufacturer of CMOS image sensors, Sony plays a critical role in the global semiconductor industry. The company continues to innovate across its portfolio while maintaining its mission to fill the world with emotion through creativity and technology.