Awards
English Chinese
工讀
兼職/約聘
全職
>> 瀏覽職缺 >> 進階搜尋
請鍵入您想搜尋的資訊。(可用空格或逗號區隔,空格表示所有搜尋條件均須符合,逗號表示搜尋條件符合其一即可)

MG-Database Administrator (藥廠)

發表於: 13 Apr 2018

工作內容:

1. Sales System Operation and Maintenance:

(1) Daily sales transaction data check and upload

(2) Daily sales performance report generation

(3) Co-work with supply chain team, provide daily sales data for further SAP upload

(4) Communicate with distributors’ contact window for raw data related issue

(5) SQL database maintenance: customer account and margin fee management, product master files management, account and sales territory allocation, user access management, …etc.

(6) As contact window to collect and reflect sales system related issues to vendor to seek for solution. E.g. report error, user access issue…etc.

(7) Support data export from SQL database

 

2. BI System Operation and Maintenance:

(1) SQL database maintenance, including: user access management, territory hierarchy changes, …etc.

(2) Daily data upload for system data refresh

(3) BI (Oracle and QilkView) system support and further change request process.

(4) As contact window to collect and reflect BI system related issues to vendor to seek for solution. E.g. report error, users access issue…etc.

 

3. Support DB related project - Coding

(1) MS Database Stored Procedure Build and maintenance

(2) Schedule Job maintenance and creation

(3) ETLs Maintenance and Monitor

 

4. Monthly Sales Closing:

(1) Conduct monthly closing with distributors. Data export from database, cross check and confirm monthly sales and margin fees.

(2) Provide monthly report to distributors and finance team.

 

5. Sales Plan(Target) Data Load:

(1) Cooperate with BUs to collect sales plan data.

(2) Generate data load template and conduct data load to Sales database.

 

Qualifications

(1) 2-3 Years in MS SQL DB Stored Procedure Development

(2) 2-3 Years in MS SQL ETL development and maintenance

(3) 1-2 Years in BI applications (QilkView, Tableau, MicroStrategy), QilkView Preferred.

(4) 2-3 Years in MS SQL Reporting Service

行業: 醫療照護/醫藥/生命科學
職業: 高科技產業/電信
其他
工作地: 台北市
僱傭類型: 兼職/約聘
工作經驗: 2
薪資範圍: NT50,001-NT70,000 / mth

For enquiries, you can contact Meg Yen for a confidential discussion.

Email: meg@recruitexpress.com.tw

Contact: 0287806822

**All information will be treated with the strictest confidence. We regret that only short-listed applicants will be notified.