Senior System Analyst (SQL, SSIS)


Salary:

HK$65,000.00 - HK$75,000.00 / 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
Financial Planning and Controlling Manager
Central and Western District
Permanent
16 August 2019
Finance Director, FMCG, Big 4 trained
Central and Western District
Permanent
16 August 2019
Assistant Accountant - MNC
Hong Kong
Permanent
16 August 2019
Financial Analyst Contract to Perm up to $28k
Hong Kong
Consulting
16 August 2019
Contract Financial Accountant(Renewable) , up to 35k
Hong Kong
Consulting
16 August 2019
Full Stack Developer- up to 50k
Central and Western District
Consulting
15 August 2019
IT Specialist
Central and Western District
Consulting
15 August 2019
Regional Accountant- up to 35k!
Central and Western District
Permanent
15 August 2019
E-Credit Trading Application Support - Production
Central and Western District
Consulting
15 August 2019
Client onboarding (Private bank)- up to 50K
Central and Western District
Consulting
15 August 2019
Systems Analyst (C#) - Finance - 48k - Contract
Central and Western District
Permanent
15 August 2019
See more jobs >