Ecommerce Data Analyst

Advance Plumbing and Heating Supply Company; Michigan; On-site; USD 60,000 - 85,000; Full time

Job summary

Advance Plumbing & Heating Supply Company seeks an Ecommerce Data Analyst to own and maintain product data, including pricing and new launches, and to ensure accuracy across our online catalog. You will work with the web team to optimize product positioning based on customer trends and promotional plans, and you will process data for different sales channels.

Qualified candidates have advanced Excel skills, basic HTML comfort, and ideally Power BI experience, plus familiarity with ecommerce

Qualifications

• High School Diploma or GED required.
• Associate or bachelor’s degree preferred.
• Proficient in Excel with VLookup and Pivot Tables. Familiarity with Power BI and basic HTML.
• Experience in ecommerce and data management is desired; familiarity with channels like Shopify, eBay, Walmart, Amazon is helpful.

Responsibilities

• Own product data including pricing, new product launches, and updating information for accuracy.
• Collaborate with web team to recommend product positioning and categorization based on customer trends and promotions.
• Understand channel data requirements and process files between channels efficiently.

Skills

Advanced Excel

HTML basics

Power BI

Shopify

eBay

Amazon

ChannelAdvisor

Ecommerce experience

Honesty

Time management

Education

Diploma or GED

Associate or Bachelor’s preferred

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