Data Reporting Analyst (remote)
Location: Shelton, Connecticut
Job Type: Not Specified
Hubbell Incorporated was founded in 1888 and has grown into an international manufacturer of quality electrical, lighting and power solutions with more than 75 brands used and recognized around the world. Our founder, Harvey Hubbell, developed tooling and equipment to serve the growing demand for new assembly and manufacturing machinery during the industrial revolution. An early, and one of many patents awarded, came for the creation of the first practical method to control electricity through the pull chain socket that remains unchanged today. As a market leader in reliable, electrical solutions, we provide more than half a million products delivered through our various business groups. Hubbell is committed to continually innovating solutions that work, transforming old products with new ideas, and ensuring that we Energize, Enlighten and Empower the communities that support us.
Responsible for the design, development and implementation of business solutions that support Hubbell Electrical Products reporting needs including compensation systems, sales quotas, budgets, and commissions. Strategically analyze sales data to improve sales efficiencies, profit margins, and market share utilizing Power BI and evolving reporting applications. This position reports to the Manager of Reporting and Analysis with a working relationship with Director of Marketing Operations, Directors of Product Marketing, VP Product Development, and Hubbell Enterprise Marketing personnel.
Duties and Responsibilities
Data Management & Reporting
-Ability to create data driven solutions using SQL Server and various business intelligence tools including Power BI
-Design and maintain ETL processes by gathering detailed requirements and coordinating the implementation and rollout and support of relevant systems
-Coordinate monthly point-of-sale (POS) data collection from channel partners including data manipulation and expansion of data collections and management.
-Identify and diagnose data quality issues; provide recommendations on solutions and manage resolution
Sales & Commission Reporting
-Responsible for quarterly and monthly commission reporting involving all personnel records pertaining to salaries/commission rates, calculations, adjustments, and maintenance of data sets in support of direct sales force and sales agents.
-Manage multi-tiered processing efforts with other team members and ensure deadline compliance.
-Maintain current reporting structure and sales reports in SQL/SSAS and Crystal Reports and work towards converting to a Power BI data model.
-Develop customer reports that identify areas of business opportunity including price realization, product mix, and market share
-Create and communicate business unit performance and insights in areas including sales quotas, pre-sale pipeline and forecasting, trending, markets and end-users
-Support ad hoc requests and proactively create reporting tools and business process automations to improve sales organizations efficiency.
-Support field sales personnel via demonstrations and training on reporting application as applicable.
-Manager Data Reporting and Analysis & Data Reporting and Analysis Team
-Master Data Administrators, Systems Analysts, Application Developers
-Director Marketing Operations, Director(s) Product Development, VP Product Development
-VP Sales, District Managers, Strategic Account Managers,
-Department Managers; especially Finance, Accounting, Pricing, Inside Sales, Operations
-Hubbell Unified Business Services (HUBS) & SAP Support Group
-Software Consultants, Application Developers
Skills and Experience
- Minimum three years’ experience working with SQL development, proficient in
CRUD (Create, Read, Update, Delete) operations
- Microsoft Power Platform experience –Power BI (DAX, Power Query (M))
- Experience with Microsoft SharePoint & Power BI Workspaces
- Strong communication skills, problem solving capabilities, and analytical skills
- Understanding of data modeling and optimization techniques and best practices
- Previous SAP and Salesforce.com experience a plus
Hubbell Incorporated, its subsidiaries and affiliates, is an EO Employer AA: M/F/Veteran/Disability. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender identity or any other protected class.