Website Product Data Management

Los Alamitos, CA
May 28, 2017
Jobs Outside Higher Education
Other Jobs Outside Higher Education
Institution Type
Outside Academe

Job Description

This position involves continually adding and updating products for our e-commerce website which currently contains over 50,000 items. Data is supplied by manufacturers in various raw Excel spreadsheets and must be manipulated to fit into our schema, uploaded into our database and manipulated further. Data is stored in a remotely hosted MSSQL 2000 database and managed using SQL Server Enterprise. The method by which the data is managed will need to be re-developed and used by the person(s) seeking this job. Managing images and other media assets associated with each product is also fundamental part of the task.

Applicant must be extremely proficient at the following:

1) Data manipulation in Excel and MSSQL

2) Creating tables and views and performing queries in MSSQL

3) Importing and Exporting Data from/to MSSQL in various data formats

4) TSQL / Query Analyzer / SQL Server Enterprise Manager

5) Image manipulation both manually and in batches.

Other helpful skills:

1) Classic ASP/VBScript

2) ASP.Net

3) Responsive Web Design

4) MSSQL Database Management

About our company:

We are an Internet company with a retail website specializing in ceiling fans, lighting and other home decor products (over 50,000 products). We have been online since 1994 and were in fact the very first ceiling fan website on the Internet. We are a small business that is very lean and profitable and have shown growth virtually every year since we began selling online...even during the recession. Our website is developed in-house and I have been the webmaster from the beginning (over 20 years). Most of our employees have been with us for at least 10 years. We are experts at the products we sell and are expanding our in-house web development team to broaden the products that we offer in order to further our growth. This is not a short term data entry type of project; keeping our website updated is like painting the golden gate bridge. So we are looking for a long-term dedicated person who wants job security and has the necessary skills to help us keep this ball rolling.

I look forward to hearing from you:

Greg Tillotson

V.P. Marketing/Webmaster

Hansen Wholesale

Company Description
We are a growing internet company that is looking for a go getter.

Los Alamitos, CA


Sat, 27 May 2017 07:26:13 PDT