Sr Product File Analyst

Req ID:  29485
Date:  May 3, 2024

Upper Marlboro, MD, US, 20774

Company:  Sonepar
Brand:  Capital Electric

Own Your Expertise, And Your Future 

At Capital Electric, we embrace what makes us unique. As a company with local roots and global reach, we thrive on the diversity of our associates and the different ways each of us contributes to our success. What keeps us at the forefront of progress? Our people. No matter where they work or who they are, we trust in their individual skills and qualities and give them everything they need to reach their full potential.  

Capital Senior Product File and PDW Specialist

Location: Hybrid. The office is located in Upper Marlboro, MD


Position Objective:

This Product Specialist position is responsible for maintaining the ERP’s Product File and all related data files to ensure accurate product information, units of measure, discount/rebate groups, and costs in the Eclipse system.  Product data will be supplied by IDW, TSP or the purchasing departments and implemented into Eclipse by the Product Specialist.  This position works cross-functionally with our purchasing, sales and branch management on all aspects of the product data system and files.


As an integral member of the Capital product team the Product Specialist will be expected to perform maintenance tasks based on current Sonepar/Capital SOP’s.  As part of the Sonepar product team the Product Specialist will be expected to participate in weekly conference calls with the Sonepar product team.  There may also be various Sonepar product file related tasks that you will be asked to participate in.  Daily responsibilities may be temporarily shifted to get some of these Sonepar product file tasks completed.


Reporting Responsibilities:

This position will report directly to the Director of Product File/Rebate Filing at Sonepar USA and secondarily to the Director of Vendor Relations at Capital Electric.


Job Responsibilities:

  • Manage PDW implementation for NJPROD01, 02 and 04
  • Implement and maintain PIM Sonepar Product ID (SPID) process
  • Implement and maintain IDW data pool downloads and PDW loads
  • Implement and maintain Trade Service data pool downloads and PDW loads
  • Perform routine data management processes to ensure the product file is accurate and information is synced to the product data warehouse (PDW).
  • Load/update all price sheet information for products based on information provided by purchasing.
  • Proactively review vendor product lines for errors and fix or provide solution where needed.
  • Help to research unusual costing variances.
  • Help in researching errors in COGS and assist as needed.
  • Ensure data integrity between the PDW and product file.  Investigate errors and make appropriate corrections to accurately reflect the manufacturer pricing and company reporting.
  • Load in product substitution, reminders, and sell groups as requested by the Opcos.
  • Load in other mass product changes for purchasing agents as needed.
  • Create/maintain customer and promotional kits.
  • Load new non TSP/IDW items into the PDW when provided on a new item template.
  • Participate in the resolution of any product-related issues that may arise, as directed.
  • Follow proper procedures for product file maintenance.  Provide recommendations or new requirements to Director of Product File/Rebate Filing at Sonepar USA, as needed.
  • Represent the company’s business interests at all times in a positive and professional manner and conduct business transactions and communications in a fair and ethical manner.
  • Perform other duties as assigned.
  • Working with the pricing and rebate personnel to find and research causes of pricing and rebate discrepancies.
  • Support the Sonepar USA Product Team on an as-needed basis, providing staffing coverage for vacations or illnesses and assist with ad-hoc analysis, special projects or tasks as directed.
  • Opco computer conversion support


Additional Job Responsibilities:

  • Create, run, and schedule reports for various departments as needed.
  • Attend weekly product team calls.
  • Provide training for new Purchasing personnel and continual refresher training as needed.
  • Position may require occasional travel to branch locations or offsite meetings.
  • Maintain safe work practices and adheres to company policies and procedures.
  • Some of the product file updates may require them to be performed on nights and/or weekends.  It will be necessary that a laptop be taken home on a daily basis so that these “off hour” updates can be performed.
  • Maintain confidentiality of proprietary and sensitive business information.



Preferred Education and/or Experience:

  • Associates degree or higher, and/or a combination of relevant knowledge through job related experience & training.
  • Prefer four+ years of related experience in the electrical industry; or equivalent combination of education and experience.


Job-Specific Knowledge, Skills and Abilities:

  • Organized self-starter, who can work independently with little supervision, effectively prioritizes tasks.
  • Ability to listen and comprehend information from others.
  • Strong verbal and written communications skills to write reports and business documents; and to speak effectively with internal and external contacts.
  • Excellent problem-solving skills are required to effectively perform work, to research issues and follow through to completion or resolution.
  • Solid computer skills; including Microsoft Office Applications (Work, Excel, SharePoint, Windows) and ERP (Eclipse) experience.


Physical Demands & Work Environment:

The physical demands and work environment characteristics described here are representative of those typically encountered while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands: 

  • Frequent sitting at work area, using phones, computer and 10-key.
  • Frequently moving between other departments to perform job. Walking and standing on hard surfaces.
  • Requires close vision with computer and paperwork, distant and peripheral vision for driving and for safety in warehouse.
  • Requires ability to clearly hear in-person and phone conversations.


Work Environment:

  • Primarily office work areas with exposure to warehouse and safety sensitive areas.  Light to Moderate noise level.
  • Some of the product file updates may require them to be performed on nights and/or weekends.  It will be necessary that a laptop be taken home on a daily basis so that these “off hour” updates can be performed.

We offer excellent training, career advancement opportunities, and a competitive compensation package to include vacation time, sick time, full health benefits, 401(k) and more. Capital Electric is an EEO Employer.


About Us:

Capital Electric is The Electrical Distributor of Choice in the Mid-Atlantic region and a proud member of the Sonepar family. Capital Electric delivers excellence in service, products from the finest lighting and electrical manufacturers, extensive application expertise, and customized, comprehensive solutions to our customers.  Altogether, we serve customers in the District of Columbia, Maryland, Virginia, Delaware, Pennsylvania, West Virginia, North Carolina, South Carolina and Georgia from over 70 locations and from our central distribution center and company headquarters in Upper Marlboro, MD.

Capital Electric is also part of the Sonepar family, an independent family-owned company with global market leadership in B-to-B distribution of electrical products, solutions and related services. Sonepar entered the US in 1998 and continues to grow due to strategic acquisitions and organic growth. Today, Sonepar serves the market through a network of companies with over 400 locations nationwide.

Stay up to date with Capital Electric, follow us on LinkedIn, Instagram, Twitter and Facebook.

Equal Employment Opportunity Statement 
Sonepar is an Equal Opportunity and Affirmative Action Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to their race, color, creed, religion, national origin, citizenship status, ancestry, sex, age, physical or mental disability unrelated to ability, marital status, family responsibilities, pregnancy, genetic information, sexual orientation, gender expression, gender identity, transgender, sex stereotyping, order of protection status, protected veteran or military status, or an unfavorable discharge from military service, and other categories protected by federal, state or local law. 
EEO is the Law 
Applicants and employees are protected under Federal law from discrimination. To learn more, Click here
Pay Transparency Non-Discrimination Provision 
Sonepar follows Executive Order 11246, including the Pay Transparency Nondiscrimination Provision. To learn more, Click here

Nearest Major Market: Washington DC