Senior System Analyst (SQL, SSIS)


Salary:

HKD65000 - 75000 / month

Location:

Hong Kong

Date posted:

4 July 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
Online SharePoint Developer - Consultancy - Up to 35k
Central and Western District
Consulting
19 July 2019
Business Analyst - up to 55k
Central and Western District
Permanent
19 July 2019
Program Director - up to 85k
Central and Western District
Consulting
19 July 2019
SAP/Senior Developer (Backend Java) - Commerce - Up to 38k
Kowloon City District
Consulting
19 July 2019
Controls Assurance Analyst - Insurance- up to 65K
Central and Western District
Consulting
19 July 2019
SAP/Systems Analyst (AS400) - Life Insurance - Up to 42k
Kwai Tsing District
Consulting
19 July 2019
Regional Senior Manager, Business Finance - Insurance
Central and Western District
Permanent
18 July 2019
Personal Assistant, HKD30k
Central and Western District
Permanent
18 July 2019
Assistant Business Analyst-Insurance/ Finance-22k-Contract
Central and Western District
Consulting
18 July 2019
AVP, Capital Management/ ALM - Well-known Bank
Central and Western District
Permanent
18 July 2019
Office Manager, Shipping Company, HKD50k
Central and Western District
Permanent
18 July 2019
UAT Tester -Insurance/ Finance - 15k - Contract
Southern District
Consulting
18 July 2019
Risk Manager / Senior Manager
Central and Western District
Permanent
18 July 2019
See more jobs >