SQL - Write Quires to Manage e-commerce Feeds

Closed Posted 3 years ago Paid on delivery
Closed

We are seeking a skilled Data analyst help with the day to day management of our marketplace feeds.

This will be an on going project requiring daily meetings, screen share sessions, and phone calls.

INITIAL RESPONSIBILITY

* Compare the marketplace categorization to our internal categorization and map the data accordingly.

* Write complex queries aka "business rules" to manipulate data according to each marketplace requirement.

* Analyze the marketplace data compared to ours to determine the best strategy to populate the valid values.

* Manage Error resolution for all marketplace feeds.

* Report bugs and open cases with support to resolve system/data issues.

* Write SQL reports as needed

REQUIREMENTS

1. Must be detail oriented and organized.

2. Looking to dedicate your time to a long term project. (100% dedicated to our project)

3. Available to work full time between 7am - 5pm PST. Monday-Friday (on US Time Zone)

4. Must communicate and write English well.

5. You need 2 monitors to extend the display

6. Access to email, phone and screen share sessions.

7. Have Microsoft excel

8. Stable internet access

9. Must be good with SQL queries (stored procedures), excel formula's. (Excel macro's or google sheets script would be a plus)

Please provide some previous projects you have worked on similar in nature. We are looking to hire someone to start right away.

Thank you,

Jacob

Tableau, Bower Bi, data visualization, data Ninja, data scientist, Channel Advisor

SQL MySQL Excel Excel VBA Tableau

Project ID: #28108515

About the project

8 proposals Remote project Active 3 years ago

8 freelancers are bidding on average $9/hour for this job

sajidjasi

Dear Customer, Hope you doing well. I am an expert data analyst. My expertise includes econometric modeling and data analysis using SPSS, Stata, E-Views, for business data analysis and data visualization, I am expert i More

$5 USD / hour
(4 Reviews)
3.7
Gameel92

hi, I am a professional data analyst.I hold the data analyst degree from Udacity .I am advanced in SQL queries, creating dashboards with power bi and excel.I have advanced excel skills like VBA,power query, and power More

$5 USD / hour
(3 Reviews)
2.1
bagryanskayaoles

Dear sir. I read your description carefully. Your project is required attentivity, accountability and high skill,rich experience. As I am a attentive and talent developer. your project is very interesting and match wit More

$10 USD / hour
(0 Reviews)
0.0
bsuvham

I'm currently a business and economic student with management base level studies . In this lockdown I'm trying to make myself more productive in a way forward.

$6 USD / hour
(0 Reviews)
0.0
rajaaijaz10

I m expert in data analysis and data warehousing. My previous projects include MySQL to NoSql translatior(realtime) and data cleansing etc. and have experience in R software and Mini Tab including deep statistics knowl More

$10 USD / hour
(0 Reviews)
0.0
RalphChapman

Hello, I have 13 years of experience with designing, implementing, maintaining, and debugging sql queries and procedures.

$6 USD / hour
(0 Reviews)
0.0
NaumanBinSattar

Hi, I have recently developed a Feed comparison Portal for a company that works same like stockinthechannel.com. it was a dropshipping Company. what i did in portal: 1: I get the updated Feed in CSV files from distri More

$17 USD / hour
(0 Reviews)
0.0