System Analyst – BI

Swing Consulting Ltd.; Hong Kong; On-site; HKD 446,400 - 669,600; Full time

Job summary

A consulting firm in Hong Kong is seeking an experienced Systems Analyst to perform system analysis and development for business intelligence applications. The ideal candidate will have a minimum of 6 years in system development, with at least 3 years focused on BI or data analytics. Proficiency in Microsoft Power BI, SQL, and ETL tools like SSIS is essential. Strong communication skills in English and Chinese are required. High caliber applicants may be considered for a Senior Systems Analyst role.

Qualifications

• Minimum 6 years of system development experience, with at least 3 years in BI or data analytics development.
• Sound technical knowledge in ETL processes and tools.
• Expertise in designing and developing complex SQL queries.

Responsibilities

• Perform system analysis, development, and support for BI applications.
• Occasional system support after office hours.
• Collect requirements, design, program, test, and implement with minimal supervision.

Skills

Microsoft Power BI

SSIS

SSRS

SQL

C#

.NET

DAX

Excel Power Query

Data Visualization

Education

University graduate

Tools

Oracle PL/SQL

React JS

Python

Jupyter Notebook

Neo4j

Job description

• Various system analysis, development and support tasks for the business intelligence applications.
• Occasional needs to perform system support after office hours.
• Other ad-hoc tasks or projects.
• University graduate Minimum 6 years of system development experience with at least 3 years in BI or data analytics development.
• Proficient and hands-on development experience using Microsoft Power BI, SSIS, SSRS and SSAS.
• Sound technical knowledge of following: - Strong experience in ETL processes and tools such as C#, .NET and SSIS.
• Expertise in designing and developing complex SQL queries, stored procedures and functions.
• Proficiency in data modelling and dimensional data modelling concepts.
• Familiar with data visualization best practice and principles.
• Experience in creating and maintaining reports and dashboards using Power BI, DAX, SSRS and Microsoft Excel Power Query.
• Oracle PL/SQL development and tuning.
• Experience with the following a plus:
• React JS / Ant Design - Python / Juypter Notebook.
• Text Analytics and machine learning experience - Graph database modeling, data loading and visualization using Neo4j.
• Ability to perform requirement collection, design, programming, testing and implementation with minimum supervision.
• Good English and Chinese communication skills (both written and verbal).
• High caliber applicants may be considered for the position of Senior Systems Analyst.