Senior System Analyst (SQL, SSIS)


Salary:

$55000 - 70000 / month

Location:

Hong Kong

Date posted:

29 March 2019

Employment type:

Permanent

Reference:

JT20190329

Specialisation:

IT and technology


Description

We're looking for an experienced Senior System Analyst (SQL, SSIS)/ IT Manager (SQL), who will provide technical support for the building and operations of a data warehouse, which includes the data collection modules interfacing with various data sources. The incumbent is expected to be strong in database technologies, especially MS SQL. o build data marts to support data analytics in Computer Science, Computer Engineering, or equivalent.

Job Responsibilities:

  • Perform business analysis and lead the requirements gathering with business users;
  • In the area of Data Warehouse, develop and implement data collection systems to build the necessary data-warehouse;
  • Perform Data Mapping, prepare functional specifications & other relevant documents;
  • Review mappings and functional specification;
  • Maintain and enhance existing application systems on an on-going basis per user request to keep the systems relevant to current business requirements and practices;
  • In the area of Business Intelligence, collect, manipulate and interpret data, analyse results using statistical techniques when required;
  • Create reports which may be in the form of visualisations such as graphs, charts and dashboards, detailing significant results they deduced;

Job Requirements:

  • Degree in Computer Sciences, or related fields; At least 5 - 7 years of experience working with data warehouse methodologies, dimensional data modelling, ETL (extraction, transformation, load) scripting to process data from operational source systems into the data warehouse;
  • Competency in SQL; A good SQL knowledge and experience working with relational databases and familiarity with Microsoft SQL databases as well as knowledge of Extraction, Transformation & Loading (ETL) tools such as MS SQL Integration Service (SSIS) and MS SQL Analysis Service (SSAS) is essential;
  • Experience in data analytics tools and using statistical packages for analysing large datasets (Excel, SPSS, SAS etc.) will be desired;
  • 2 years' experience in implementation and support of IT application systems, preferably in the ASP.NET environment;
  • Oversee the installation and configuration of new systems to customize them for the organization.

Apply Today

To apply online (Word attachment only), please click the 'Apply' button. Please note that only short-listed candidates will be contacted.

Should you need more detail, please reach me at 3653 7300, Joe Tsoi or Email your resume to [email protected]



Hong Kong

9th Floor, Nexxus Building
41 Connaught Road
Central
Hong Kong Island
hk
+852 3653 7300
AP Accountant,MNC,1 year contract(Native Mandarin preferred)
Central and Western District
Consulting
11 June 2019
Software Developer(.Net, Oracle)-AP-SAP-Up to 36k-Bank/FS
Central and Western District
Consulting
11 June 2019
Financial Planning&Analysis Director,VBA,Macro,BI tools,Data
Central and Western District
Permanent
11 June 2019
Accountant | UK MNC
Central and Western District
Permanent
11 June 2019
Regional Senior Accountant | Business Advisory Firm
Central and Western District
Permanent
11 June 2019
Management Accountant ( MNC )
Central and Western District
Permanent
11 June 2019
(Assistant) FP&A Manager | APAC
Central and Western District
Permanent
11 June 2019
Cash equities IT BA
Central and Western District
Permanent
10 June 2019
Fund Account, Hedge Fund, HKD 35-45k
Central and Western District
Permanent
10 June 2019
Senior Developer(Backend Java)-30k-40k -Leading Retailer
Kwai Tsing District
Consulting
10 June 2019
Financial Controller | 60k monthly
Hong Kong
Permanent
10 June 2019
VIP Desktop Support-Insurance-12M Contract-25- 37K
Central and Western District
Consulting
10 June 2019
Executive Assistant/ 3-5yrs exp/ 25-28k/ Finance firm
Central and Western District
Permanent
10 June 2019
See more jobs >