Treehouse Partners

Job Description Job Description Our 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. Please note: Applicants must be authorized to work for ANY employer in the U.S. Unfortunately, our client is unable to sponsor or transfer sponsorship of an employment Visa at this time. 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 similar 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 $120-$130k (DOE), plus performance-based bonus