Ecommerce Data Analyst

ADVANCE PLUMBING SUPPLY OF WALLED LAKE INC; Commerce Charter Township (MI); On-site; USD 60,000 - 80,000; Full time

Job summary

Advance Plumbing & Heating Supply Company is seeking an eCommerce Data Analyst to own product data, pricing, launches, and accuracy across web channels. You will work with the web team to optimize product positioning based on customer trends and promotional plans.

Strong Excel (VLookup, Pivot Tables), HTML basics, and Power BI are essential, with hands-on experience in eCommerce platforms such as Shopify, Channel Advisor, and marketplaces like Walmart, eBay, and Amazon helping drive decisions.

Qualifications

• High School Diploma or GED is required.
• Associate or bachelor’s degree preferred.
• Advanced Excel experience with VLookup and Pivot Tables.
• Experience in eCommerce and product data management is a plus.

Responsibilities

• Own product data including pricing, new product launches, reviewing product information for accuracy, and updating as necessary.
• Work with web team to provide recommendations for product positioning and categorization, based on analysis of customer trends and promotional plans.
• Understand different channel requirements for data and be able to process files from one channel to another.

Skills

Advanced Excel

HTML basics

Power BI

eCommerce experience

Education

High School Diploma or GED

Associate or Bachelor's degree preferred

Tools

Shopify

Rithum/Channel Advisor

Walmart

eBay

Amazon

Job description

Description

About Us:

Welcome to Advance Plumbing & Heating Supply Company, a fourth-generation family owned and operated business, started in 1920. The company's original location was at 2984 Grand River Ave. in Detroit, across from the Motor City Casino. On October 31st, 2016 we moved to our new location at 150 Parsons St. in Midtown Detroit. The new state-of-the-art location features the City of Detroit's first ever Decorative Plumbing Showroom which opened in winter of 2018.
In 1990, with a solid reputation for excellence and an expanding market, Advance opened up a second location in Walled Lake, Michigan which features a state-of-the-art 5,000-square foot decorative plumbing showroom and an outstanding plumbing & heating parts counter.

Requirements:

What You’ll Do:

As our eCommerce Data Analyst, you will be the product expert for the web. Ability to learn, interest in growing a business and clear communication will be keys to being successful in this role.
Some Duties May Include:

• Own product data including pricing, new product launches, reviewing product information for accuracy, and correcting/updating as necessary.
• Work with web team to provide recommendations for product positioning and categorization, based on analysis of customer trends and promotional plans.
• Understand different channel requirements for data and be able to process files from one channel to another.

What You Need to Get the Job Done:

• Advanced Excel Experience (VLookup, Pivot Tables, etc)
• Comfort with basic HTML or willingness to learn
• Preferred experience with Microsoft Power BI
• Experience in eCommerce. Unlog experience would be a major asset. Rithum/Channel Advisor, Shopify, eBay, Walmart, or Amazon experience helpful.
• Demonstrate honesty and integrity while maintaining commitments
• Recognizes issues, problems or opportunities and determines whether action is needed
• Ability to navigate through multiple computer platforms with speed and accuracy
• Ability to effectively manage workload, shift priorities and meet deadlines
• Ability to comprehend technical details

What Will Make Us Really Love You:

• A self-motivated, positive, team player eager to join the family
• Excellent organization skills with the ability to prioritize and handle multiple tasks
• Strong communication skills, both verbal and written

What You’ll Love About Us:

• A family-oriented business is kind of our tradition – for 100 years and counting!
• We are Rebuilding Detroit, both through the physical buildings and the people who call it home. Regardless of your position, we hope that more people can find meaningful careers in Detroit’s construction industries.
• Come grow with us! Have the ability to learn skills or knowledge from educational and learning opportunities.

Requirements:

• High School Diploma or GED Equivalent required
• Associate or bachelor’s degree preferred