Commercial Insights Analyst

Responsibilities

• Develop and maintain trusted data assets and reporting solutions that serve as a single source of truth for ICD’s key financial performance metrics, forecast indicators, customer and channel insights, product portfolio performance, and operational service benchmarks.
• Create and enhance a unified self-service analytics hub for Product Managers (PMs), Product Line Managers (PLMs), Regional Sales Managers (RSMs), Sales Operations, and division leadership.
• Support and advance ICD’s AI data readiness by establishing and maintaining the data, knowledge management, governance, and documentation practices required for effective use of enterprise AI capabilities.
• Manage commercial data structures, SharePoint knowledge sources, semantic models, metadata, and other foundational assets to enable the safe and effective use of Microsoft 365 Copilot, Copilot Studio, Power BI, GitHub Copilot, and related Microsoft technologies in support of sales enablement, portfolio growth, customer responsiveness, productivity improvements, and data-driven decision-making.
• Maintain access to relevant commercial data sources for the division and ensure datasets are clean, documented, governed, and fit for analytics, reporting, and AI-enabled use.
• Cleanses, shapes, and combines data using Power Query and transformation best practices; works across Excel, SQL, Snowflake, SAP BW, SharePoint, OneDrive, and other approved sources; and documents source ownership, refresh cadence, definitions, and business context so data is analysis-ready and AI-retrievable.
• Transforms and models data using Power BI, Python, R, and related tools to enable reporting, analysis, and AI-assisted insight generation.
• Builds efficient semantic models using star schemas, proper relationships, optimized joins, governed measures, calculated tables, and KPI definitions that can serve as trusted inputs for dashboards, Copilot-assisted analysis, and future automation and AI-enabled business processes.
• Create effective, user-friendly reports aligned with Eaton standards and business priorities. Create dashboards, landing pages, and self-service reporting experiences that consolidate key metrics, improve visibility across teams, and enable business users to independently explore data and derive actionable insights.
• Support priority commercial, product line, sales, and marketing initiatives by developing ad hoc analyses, reports, and data views based on defined business questions and stakeholder requirements. Support trend analysis, forecasting activities, and performance measurement to improve business planning and decision-making. Partner with sales, marketing, product management, and commercial leadership to identify opportunities, evaluate business performance, communicate insights, and support data-driven decision-making.
• Provide training, documentation, and support to business users and report consumers. Guide teams on self-service analytics, Power BI workspace usage, data literacy, responsible Copilot use, and best practices for interacting with governed data and reporting assets.
• Maintain a commercial data dictionary documenting approved KPI definitions, source ownership, refresh cadence, business context, known limitations, and data lineage. Establish and maintain governance standards for commercial data, SharePoint knowledge sources, semantic models, and approved enterprise content to support consistent reporting, trusted analytics, and AI readiness.

Qualifications

• Bachelor’s degree from an accredited institution.
• Minimum of two (2) years of experience in business analytics or data science.
• Minimum of one (1) years of experience using SQL and analytical languages such as Python, R, or similar.
• Minimum of one (1) year of experience developing dashboards, scorecards, and executive-level reporting using data visualization tools such as Power BI, Tableau, or Qlik.
• Experience with Microsoft Power Platform, including Power BI, Power Apps, Power Automate, or similar data transformation and automation tools.
• Understanding of semantic models, data modeling concepts, dataset performance, and governance.
• Background supporting sales, marketing, pricing, customer experience, or other commercial organizations.
• Demonstrated ability to analyze sales performance, pricing, profitability, customer behavior, market trends, or commercial KPIs to inform business decisions.
• Experience gathering business requirements and translating them into analytical solutions, dashboards, and reporting tools.
• Experience working with enterprise data warehouses, ERP systems, or governed data environments (e.g., Snowflake, SAP BW, Palantir, Azure Data Platform).
• Experience preparing structured and unstructured business content for governed enterprise use, including SharePoint libraries, metadata management, documentation standards, semantic models, and approved knowledge sources.
• Ability to identify trends, develop forecasts, and generate actionable insights from business data.