Business Intelligence & Analytics Lead for a Leading Lighting Company

Job Description

Job DescriptionOur client is a top-tier lighting manufacturer known for designing and producing premium modular downlighting systems that deliver exceptional performance, adaptability, and aesthetic appeal. Their reputation is built on a foundation of superior design, engineering innovation, and dedicated customer service.They're seeking a Business Intelligence (BI) & Analytics Lead to own enterprise reporting, analytics strategy, and data governance across the organization. This role serves as the business-facing analytics leader, responsible for ensuring that financial, operational, manufacturing, and eCommerce data is accurate, consistent, and trusted across reporting and decision-making processes.

This position leverages Microsoft Fabric as the core analytics platform and partners closely with Finance, Operations, Manufacturing, Sales, and IT teams. The role blends strategic ownership with hands-on oversight of data models, pipelines, dashboards, and reporting standards, while coordinating delivery with offshore BI development resources. This role will play a key part in the organization's transition to Microsoft Fabric, supporting adoption, standardization, and long-term analytics ownership.

This is a hybrid role, reporting to our client's headquarters in Carson, CA (greater LA area) three days per week.

Responsibilities:
- Serve as the primary owner of enterprise analytics and reporting, partnering with Finance, Operations, Manufacturing, Sales, and eCommerce teams to define KPIs and reporting requirements
- Own and govern semantic models, datasets, and reporting layers within Microsoft Fabric, maintaining consistent metric definitions, calculations, and data standards
- Translate business questions into clear analytics, reporting, and dashboard specifications
- Review and validate data pipelines and transformations feeding Fabric, ensuring reports and dashboards are performant, scalable, and user friendly
- Collaborate closely with Oracle Fusion Functional Leads and the Integration and Applications Technical Lead, while partnering with eCommerce and Operations stakeholders to validate reporting requirements
- Ensure data accuracy and consistency across Oracle Fusion Finance and Supply Chain modules, CPQ platforms, Warehouse Management Systems, and both B2B and B2C eCommerce platforms
- Establish and maintain data dictionaries, KPI definitions, and reporting documentation, balancing self-service analytics with appropriate governance and controls
- Act as the escalation point for reporting, dashboard, and data quality issues, troubleshooting data discrepancies and coordinate fixes across technical teams
- Identify opportunities to automate reporting and reduce manual processes
- Provide functional direction and prioritization to offshore BI and Microsoft Fabric developers; reviewing deliverables to ensure accuracy, usability, and completeness; and participating in regular status updates, reviews, and issue-resolution meetings

Qualifications:
- 5–8 years of experience in business intelligence, analytics, or enterprise reporting roles
- Hands-on experience with Microsoft Fabric or Power BI within the Microsoft data ecosystem
- Experience delivering analytics and reporting on ERP and operational data with Oracle Fusion preferred
- Experience working with offshore or third-party development teams
- Exposure to manufacturing, supply chain, or financial reporting environments, strongly preferred
- Strong understanding of data modeling and semantic layer design with the ability to validate, troubleshoot, and reconcile data pipelines and dashboards
- Working knowledge of ETL and ELT concepts and data pipelines
- Experience defining KPIs, metrics, and reporting standards
- Strong communication skills with both business and technical stakeholders; highly organized with the ability to manage multiple priorities
- Knowledge of Power BI, Synapse, or Azure data services
- Exposure to finance and supply chain metrics, a plus
- Familiarity with CPQ and eCommerce reporting, a plus

Compensation: Targeting a base salary of $130-$140k (DOE), plus performance-based bonus