Business Intelligence & Analytics Lead for a Leading Lighting Company

Treehouse Partners

Business Intelligence & Analytics Lead for a Leading Lighting Company

Carson, CA
Full Time
Paid
  • Responsibilities

    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.

    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